I could use some support with setting up a bulk API connection in Qlik Sense.
URL=https://www.frankenthalerfoundation.org
Method=Post
Request body={ "name": "Clickthrough", "fields": { "ActivityId": "{{Activity.Id}}" }, "filter": "'{{Activity.Type}}' = 'EmailClickthrough'", }
Key generation strategy= Sequence ID
Query headers (Name=Content-Type, Value=application/json)
This data connection works, however, i would like to use parameters that i want to control in the application, and not in the 'Request body', else i have to create every day a new data connection.
Hence, i want to use the option: with connection, to override the data connection.
CUSTOM CONNECT TO "provider=QvRestConnector.exe;url=https://www.frankenthalerfoundation.org %3name%3: %3Clickthrough%3, %3fields%3: { %3ActivityId%3: %3{{Activity.Id}}%3 }, %3filter%3: %3'{{Activity.Type}}' %2 'EmailClickthrough'%3,};httpProtocol=1.1;isKeepAlive=true;bodyEncoding=UTF-8;sendExpect100Continue=true;autoDetectResponseType=true;checkResponseTypeOnTestConnection=true;keyGenerationStrategy=0;XMLDTD=0;authSchema=basic;serverCertificateValidation=UseTrust;useCertificate=No;certificateStoreLocation=LocalMachine;certificateStoreName=My;addMissingQueryParametersToFinalRequest=false;queryHeaders=Content-Type%2application/json%1;PaginationType=None;allowResponseHeaders=false;allowHttpsOnly=false;isCookieContainerEnabled=false;useProxy=false;proxyBypassOnLocal=false;proxyUseDefaultCredentials=true;"
LIB CONNECT TO 'Eloqua_Bulk_v2';
RestConnectorMasterTable:
SQL SELECT "name", "filter", "maxRecords", "dataRetentionDuration", "uri", "createdBy", "createdAt", "updatedBy", "updatedAt", "__KEY_root", (SELECT "ActivityId", "__FK_fields" FROM "fields" FK "__FK_fields") FROM JSON (wrap on) "root" PK "__KEY_root" WITH CONNECTION (url "https://www.frankenthalerfoundation.org %3Clickthrough%3,%3fields%3: {%3ActivityId%3: %3{{
