Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
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.