Create nested JSON from Qliksense straight table to Marketing platform

krishelis — Fri, 22 Oct 2021 05:56:46 GMT

Hello,

I need to send data from Qliksense prepared table to marketing platform. One by one request is easy to do by adding "Get Straight Table Data" and "Call URL" blocks. Everything works like expected.

But to improve process platform support batch API request with 1000 person limit per request.

Body has to be prepared in such a format:

{ "people": [ { "firstName": "John", "lastName": "Johnzzz", "customAttributes": { "first_payment_date": "2021-01-01", "random_attribute": "aaaa" }, "contactInformation": { "phone": [ { "number": "46546546" } ], "email": [ { "address": "aaa@bbb.com" } ] } }, { "firstName": "Brut", "lastName": "Brutzzz", "customAttributes": { "first_payment_date": "2021-04-20", "random_attribute": "cccc" }, "contactInformation": { "phone": [ { "number": "46546464645" } ], "email": [ { "address": "ccc@bb.com" } ] } } ] }

Could anyone help me to prepare Automation rules/blocks so the body is in needed format?

I have simple table in qlik load script:

persons: LOAD * INLINE [ firstName, lastName, first_payment_date, random_attribute, address, phone John, Johnzzz, 2021-01-01, aaaa, aaa@bbb.com, 231231321 Brut, Brutzzz, 2021-04-20, cccc, ccc@bb.com, 465456465465 Ilze, Ilzess, 2021-02-01, bbbb, bb@aa.com, 54654658789 Dudu, Dududss, 2021-10-01, abc, ddd@ggg.com, 798789789 ];

Another question, is it possible to store response result (output) from rest api ?

Re: Create nested JSON from Qliksense straight table to Marketing platform

J_Lindberg — Mon, 21 Aug 2023 08:14:10 GMT

Use the the advanced "Loop batch" block to loop over the output of "Get straight table" in batches.
Within a batch the correct payload can be built using two variables (list and object), after this, the list can be sent to the API.

topic Create nested JSON from Qliksense straight table to Marketing platform in Qlik Automate

Create nested JSON from Qliksense straight table to Marketing platform

Re: Create nested JSON from Qliksense straight table to Marketing platform