Expected Integer but got string

(0) Share

Report

Posted on by Community Power Pla...

Hi Folks,

Reading in a CSV file using the ParseCSV tool. I then read the data in and process it as a JSON, which works well until the subject error occurs. As its a text file and effectively a long text string, I guess I need to keep all values as string only, and then look to convert the field into a number or an integer (which is the best for really, big numbers?) - or am I missing something here?

Thanks

All responses (1)

Answers (1)

Verified answer

v-litu-msft on at

Like (0)

Report
Re: Expected Integer but got string

Hi @Anonymous,

I assume that the issue is caused by the ParseCSV action to consider the subject as an integer.

As a workaround, you could initialize an array variable to store new array that restructures the JSON. Steps as below, add a Apply to each action to loop the original JSON, then add double quotes at the subject property:

{ "subject": "@{item()?['subject']}", "Name": @{item()?['Name']} }

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.