Parsing JSON data for int and float

(1) Share

Report

Posted on by swebb111

All,

I'm querying Business Central and one of the fields that I'm querying is listed as type integer. However, it often is not a whole number, and has decimal points, as it is currency. When trying to run a Power Automate flow to gather that data, it often errors out because when it tries to pull the data during a loop, it says "Expected Integer instead got Number" --- is there a work around for this?

All responses (1)

Answers (0)

abm abm 32,464 Most Valuable Professional on at

Like (0)

Report

Re: Parsing JSON data for int and float

Hi @smw356239

Change your Parse JSON Schema integer to number.

See below.

"Amount": {

"type": "number"

}