Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
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

}

};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;