Forum Discussion
Counting JSON Element Value Pair
I was looking to count how many element value pair value we have received in the json response from one of our Web API. Anyone had any luck or can figure out for me how to achieve this. I have includ...
Thanks for sharing the irisp for sharing the tools. I use the plugin within Notepad mostly but nice to know.
Eric_Zhang we are looking to do exactly what you mentioned by doing at the data end, which in our case is PostgreSQL, but the issue is we have the solution in place in production and we identified that for some reason our current solution is not extracting all the element from the json object.
So we trying to have a temporary report in Power BI for now to see how many of those records with extracted element do not match to the actual number of element available in the json object.
thanks