JsonObject with Square Brackets

(0) Share

Report

Posted on by andreas@protektit.no

I'm working with an integration where i have to make some API-calls, and some of the filters on the API uses square brackets around their values (see picture)

My problem is that i add this value to the JsonObject, naturally as a string or Code datatype - but once the parameter is surrounded by quotation, it stops working.
If i send "[12230001]" with quotation outside of the brackets, the API returns an error. How can i bypass this? Is there any other datatype that supports brackets that would not be wrapped in quotationmarks in a JsonObject?

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

Andy Sather Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hello - We currently do not have dedicated Dev support via the Dynamics 365 Business Central forums, but I wanted to provide you some additional resources to assist. If you need assistance with debugging or coding I would recommend discussing this on one of our communities.

www.yammer.com/dynamicsnavdev

I will open this up to the community in case they have something to add.

Was this reply helpful? Yes No
Suggested answer

Stefano Demiliani 37,166 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Square brackets in JSON means an array object, so I think you need to pass the data as follows:

"projectIdFilter": ["12230001"]

Was this reply helpful? Yes No
andreas@protektit.no 40 on at

Like (0)

Report
Copy link

Link copied!

You are right, but how do i build a variable for the jsonObject, that takes the brackets [ ] without it being a string/code/text?

This is what i have currently

This ends up as "[ some number ]"
Any tips on how it can end up as ["number"] with the brackets on the outside?

Was this reply helpful? Yes No
Suggested answer

Inge M. Bruvik 1,161 Moderator on at

Like (0)

Report
Copy link

Link copied!

You should use the Json array data type as documented here:

learn.microsoft.com/.../jsonarray-data-type

Was this reply helpful? Yes No
andreas@protektit.no 40 on at

Like (0)

Report
Copy link

Link copied!

Perfect, this is just what i wanted. Thanks for the replies!

Was this reply helpful? Yes No