Unanswered

Adding custom json object data to work queue

(0) Share

Report

Posted on by automator11

Hi,

I have a json as custom object read in as shown. I want to add this information to a work queue. I tried indexing each row to get the values but it gave me an error saying that indexing is not allowed for the custom object. Thanks for the help.

Categories:

Power Automate Desktop

All responses (3)

Answers (0)

Sort by

Agnius Bartninkas Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Those are not indexed rows, but instead they're key:value pairs. You can get the value by referencing the key. For example, to get the customer number, use %JsonAsCustomObject['customerNumber']%, and to get the organisation, use %JsonAsCustomObject['organisation']%.

-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.

I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.
automator11 20 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for the reply, however i should have mentioned that the keys are not always present in the json file so I do not want to explicitly call out 'customerNumber' etc
Agnius Bartninkas Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

No other way to do it, though. But you can check if the object contains a key value before explicitly using it, so you can use some default/empty value instead, if it doesn't contain it.