ApexERPHost

<back to all web services

GetDynamicDS

Requires Authentication
The following routes are available for this service:
GET/Core/Dynamic/DataSources/{DsId}
GetDynamicDS Parameters:
NameParameterData TypeRequiredDescription
DsIdpathGuidNo
DynamicDataSource Parameters:
NameParameterData TypeRequiredDescription
DsIdformGuidNo
NameformstringNo
DescriptionformstringNo
QueryformstringNo
HasDatesformboolNo
CategoryIdformGuidNo
ParamsformList<DynamicDataSourceParam>No
HccrtformstringNo
Usedformbool?No
HasParamsformbool?No
HCodeformstringNo
DynamicDataSourceParam Parameters:
NameParameterData TypeRequiredDescription
IdformGuidNo
NameformstringNo
DescriptionformstringNo
DataSourceIdformGuidNo
DbTypeformstringNo
SizeformintNo
QueryIdformGuid?No
FormatformstringNo
IsNullableformboolNo
OrderIndexformintNo

To override the Content-type in your clients, use the HTTP Accept Header, append the .csv suffix or ?format=csv

HTTP + CSV

The following are sample HTTP requests and responses. The placeholders shown need to be replaced with actual values.

GET /Core/Dynamic/DataSources/{DsId} HTTP/1.1 
Host: apex.nikoratrade.ge 
Accept: text/csv
HTTP/1.1 200 OK
Content-Type: text/csv
Content-Length: length

{"DsId":"00000000000000000000000000000000","Name":"String","Description":"String","Query":"String","HasDates":false,"CategoryId":"00000000000000000000000000000000","Params":[{"Id":"00000000000000000000000000000000","Name":"String","Description":"String","DataSourceId":"00000000000000000000000000000000","DbType":"String","Size":0,"QueryId":"00000000000000000000000000000000","Format":"String","IsNullable":false,"OrderIndex":0}],"Hccrt":"String","Used":false,"HasParams":false,"HCode":"String"}