Post API with JSON Array in Body

[Anonymous]

Hi all,
I hope you had a great Christmas!

I'm new working with APIs in BI. I have a json body that works well when there is one carrier.

= Text.ToBinary("{""object_type"": 7, ""carrier_id"": 20}")

But I need to add more than 30 carrier and it will be a pain to create a query for each carrier.

Does anyone know if it possible to add an array to the existing json body?

This is what I had in mind but it didn't work.

Text.ToBinary("
[
{""object_type"": 7, ""carrier_id"": 1},
{""object_type"": 7, ""carrier_id"": 2},
.............
{""object_type"": 7, ""carrier_id"": 30},
]
")


Any help would be appreciated. 🙂

[Anonymous]

Hi @Anonymous ,

Text.ToBinary can only deal with one elemental, I suggest you to try List.Transform or List.Generate which can process multiple elements one by one in a queue:
List.Transform - PowerQuery M | Microsoft Learn
List.Generate - PowerQuery M | Microsoft Learn

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.