Split an array to strings and object

[Hyacinto]

Dear readers,

First of all, I would like to thank this forum for all the help I have received so far, although I have managed to do everything by searching and reading. I started making my applications about two weeks ago, and now I'm irredeemably confused and stuck.

Sorry if I'm asking something too obvious or the subject designation is very misleading, I've done quite a lot of searching on this topic, and maybe I'm the only one who hasn't managed to put the solution together.

My ultimate goal would be to transfer the data collected by Power Apps (Partner name and address, product ID, and quantity ordered) to Automate and insert it into an HTTP POST request body:

- Partner section:

  "partner": {    "name": "string",    "address": {      "country_code": "HU",      "post_code": "string",      "city": "string",      "address": "string"
    }

- Product/items section:

  "items": [    {
      "product_id": 0,      "quantity": 0
    }
  ]

For more details, see this link. 

Well, now I'm at the point where I convert the data to JSON format, concatenate it, and run the flow. I split it into three in Automate, and this is what I see:

[

  "\"Erdei Papírker\"",

  "\"5200,Törökszentmiklós,Buda Nagy Antal utca 8.\"",

  "[{\"product_id\":\"13127609\",\"quantity\":\"6\"},{\"product_id\":\"13127713\",\"quantity\":\"14\"},{\"product_id\":\"13128107\",\"quantity\":\"8\"}]"

]

(Name, Postcode, City, Address, and Items)

What should be the next step or steps? Any help and constructive criticism is appreciated in advance!

[abm]

Hi @Hyacinto 

So you mentioned you want to insert the data into a HTTP body. Could you please post a sample of the schema body of that HTTP post?

[Hyacinto]

Hi @abm!

Sure, the link is in my original post :), but maybe it's better to see it that way (is a billing program's  (Billingo) API):

{
"vendor_id": "string",
"partner_id": 0,
"block_id": 0,
"bank_account_id": 0,
"type": "advance",
"fulfillment_date": "2023-03-28",
"due_date": "2023-03-28",
"payment_method": "aruhitel",
"language": "de",
"currency": "AUD",
"conversion_rate": 1,
"electronic": false,
"paid": false,
"items": [
{
"product_id": 0,
"quantity": 0
}
],
"comment": "string",
"settings": {
"mediated_service": false,
"without_financial_fulfillment": false,
"online_payment": "",
"round": "five",
"place_id": 0
}
}

One thing is still not clear to me. Do I have to create (POST) the partner first and then retrieve (GET) his ID and insert it into the schema, or can I insert his details into the schema, and it will create a partner too? But I guess the schema is like this on purpose, I have to follow the rules, right?

[abm]

Hi @Hyacinto 

Since its a third party endpoint, better to refer the documentation. Not sure anything I can recommend about the id's here.