Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Leverage your QlikView investment to modernize BI – see how! Join Group
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Passing dynamic variable in Rest API connection

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






















FROM JSON (wrap off) "FDRSyncList";


LOAD [Transaction],

















RESIDENT RestConnectorMasterTable;

DROP TABLE RestConnectorMasterTable;