Issue -
I am connecting to a web service using Rest API Post method
and in Request body i am passing start date and End date .
On basis of start and end date i am receiving the data
Now i want to pass dynamic parameters in start date and End date, so that i can control the data in the table.
Ho to do that ?
Code with connection string -
CUSTOM CONNECT TO "Provider=QvRestConnector.exe;url=https://XXXXXXXXXXXXXXXXXXXXXXX/FDRSyncHistory;timeout=30;method=POST;requestBody={
%3FDRSyncQuery%3: {
%3StartDate%3: %301/01/2017%3,
%3EndDate%3: %3%3,
%3RequestID%3: %3%3,
%3RequestTypeID%3: %3%3
}
};autoDetectResponseType=true;keyGenerationStrategy=0;useWindowsAuthentication=false;useCertificate=No;certificateStoreLocation=CurrentUser;certificateStoreName=My;PaginationType=None;XUserId=ZWRddeB;XPassword=LaAUBUB;";
RestConnectorMasterTable:
SQL SELECT
"Transaction",
"RequestID",
"RequestTypeID",
"User",
"Application",
"MCC",
"ConnectionType",
"LastQueryTime",
"DeviceRequestTime",
"ECQueuedTime",
"AdapterReceiviedTime",
"HostRequestTime",
"HostResponseTime",
"AdapterSendTime",
"ErrorType",
"ErrorCode",
"ErrorMessage"
FROM JSON (wrap off) "FDRSyncList";
[FDRSyncList]:
LOAD [Transaction],
[RequestID],
[RequestTypeID],
[User],
[Application],
[MCC],
[ConnectionType],
[LastQueryTime],
[DeviceRequestTime],
[ECQueuedTime],
[AdapterReceiviedTime],
[HostRequestTime],
[HostResponseTime],
[AdapterSendTime],
[ErrorType],
[ErrorCode],
[ErrorMessage]
RESIDENT RestConnectorMasterTable;
DROP TABLE RestConnectorMasterTable;
