Hey Awesome People - Need some help and looking forward to hearing about any potential solutions or experience with Parsing JSON not returning all values. The flow starts when a file is created in SharePoint folder. Then use Encodian to parse the csv file and return the JSON array. The action prior to updating a row in a table, "Parse JSON", returns most of the fields appropriately, but is returning an empty string ("") where there was actually a value. It is also moving around the order of the array but only on the Output side of the action.
On the input side of the "Parse JSON" action the below image shows the column "Tags" with a value of "Touchscreen". It is located after the column "Customer Interactions". You can see in the below image '...interactions":"35","Tags":"Touchscreen"...'. You can see the output side of the same row showing a value of "" in the Tags column.
Tags is the 16th column in the array when it is inputted, but on the output side of the Parse JSON action, it becomes the 57th column value of the array and returns as an empty string for the value. All other values are in the same position on the input side as the output side (I know it doesn't matter because I can just return them wherever I need to after, but it is weird that it moves and then becomes an empty string).
I have tried to recreate the entire flow with no luck returning that one field "Tags". It is a csv file received from our support service about ticket submissions and this field, "Tags", is tied to some KPIs we are trying to track, but unsuccessfully thanks to the Parse JSON action not working. Anyone have any experience with this sort of behavior, or have any ideas how to solve it so as to retrieve ALL values? Looking forward to some awesomeness from all you awesome people.
@Sundeep_Malik- Thanks so much for your reply!
I have never used that parse csv action.
Can you try using this:
Use a compose action,
And write:
Split(data,',')
This will make an array of your data.
After that just use parse JSON.