Parsing JSON Output to formated Excel Report

[Arundatla]

** Learning Altrexy ** We are using API to retrieve Data from some applications and the JSON out put is all in rows which we would like to format it appropriately as attached. Have tried using Transpose option and all but not giving appropriate results. Can some one suggest the right Options.

[martinson · Accepted solution]

I hope you're having a great day. I have attached a solution to your problem. Using a Mulit-Row formula and recordID seemed to do the trick. Let me know if this helps.

Cheers,

George 

Bulien

[Arundatla]

Thanks for the quick solution. But i could see the output is not coming in right order especially month. It should be in Jan, Feb --- Dec but i can see It is Jan,Feb, Nov, Dec something like this. Column order should follow JSON _Name Order.

[binuacs · Accepted solution]

@Arundatla one way of doing this

[Arundatla]

Thank you binuacs and martionson. learned a lot and helped to meet my requirement.

[Shifty]

 Lovely solve, @martinson