Passing dynamic variable in Rest API connection

Wed, 25 Nov 2020 16:16:04 GMT

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;

topic Passing dynamic variable in Rest API connection in QlikView

Passing dynamic variable in Rest API connection