Create nested JSON from Qliksense straight table to Marketing platform

[krishelis]

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 ? 

[J_Lindberg]

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.