Reference Data API
The Reference Data API allows to Access Data of Reference Data Solutions. Limited OData Filter is also supported by this API. The API uses GET Method to access data.
Request and Response
For Accessing the Reference Data Solutions, structure of Request and Response will be as follows:
Date format : YYYY-MM-DD
Decimal : No thousand separator and dot would be decimal separator, like 23232.56
Request Data Contract:
Reference Data API does not need a request body.
For Execution Reference Data API requires three parameters mentioned below:
-
AppName: Name of the app where the Reference Data Solution is created.
-
LibraryName: Name of the library where the Reference Data Solution is created.
-
RefSolutionName: Name of the Reference Data Solution to be Accessed.
Following sample illustrates the use of API:
Request Data:
Sample 1
{{Route Prefix}}/api/v1/ReferenceData?AppName=Reference Data&LibraryName=Reference Data Lists&SolutionName=refsolution
Sample 2
{{Route Prefix}}/api/v1/ReferenceData?AppName=Reference Data&LibraryName=Reference Data Lists&SolutionName=ReferenceiList11Items100&$filter=empid eq 1068
Sample 3
{{Route Prefix}}/api/v1/ReferenceData?AppName=Reference Data&LibraryName=Reference Data Lists&SolutionName=ReferenceiList11Items100&$filter=empid eq 1068 and Bitfield eq true
Sample 4
{{Route Prefix}}/api/v1/ReferenceData?AppName=Reference Data&LibraryName=Reference Data Lists&SolutionName=ReferenceiList11Items100&$filter=empid eq 1068 and Bitfield eq true
Response Data Contract:
Response body will depend on the Solution Accessed.
Response Data
"@odata.context": "https://cha-en-vst679.wsdt.local:443/svr/api/v1/ReferenceData?AppName=Reference%20Data&LibraryName=Reference%20Data%20Lists&SolutionName=ReferenceiList11Items100",
"value": [
{
"username": "wsdt\\devuser5",
"CreatedOn": "2020-01-21",
"empid": 1059,
"decimalfield": 666.77,
"Bitfield": true
},
{
"username": "wsdt\\devuser6",
"CreatedOn": "2020-01-22",
"empid": 1060,
"decimalfield": 667.77,
"Bitfield": true
},
{
"username": "wsdt\\devuser7",
"CreatedOn": "2020-01-23",
"empid": 1061,
"decimalfield": 668.77,
"Bitfield": true
},
{
"username": "wsdt\\devuser10",
"CreatedOn": "2020-01-26",
"empid": 1064,
"decimalfield": 671.77,
"Bitfield": true
},
{
"username": "wsdt\\devuser11",
"CreatedOn": "2020-01-27",
"empid": 1065,
"decimalfield": 672.77,
"Bitfield": true
}....
Invalid parameters Response:
Invalid Parameters
[
{
"ErrorCode": "Invalid_data",
"Message": "LibraryName, SolutionName or AppName does not exists.",
"errorPrameters": null
}
]