Skip to main content
  • EN

I need help to process json file and write it out in csv. Thanks.

Ctrl+G and see where you end up...

Ctrl+G and see where you end up...

Can you please be elaborate? Thanks

 

 

Did you try simply creating a JSON reader and point at your URL? When I do, I get the following reader definition:

You can then simply use a ListExploder on "response{}" and you should be good to go. You can also use the BulkAttributeRenamer in "Remove prefix string" mode to fix up your attribute names, if necessary. Example result after having removed the prefix "0."

Can you please be elaborate? Thanks

 

 

Thats the shortcut in the Workbench application to generate a workspace.

 

This will open a wizard that requires you to input the reader format and location (your url) and writer format and destination.

 

What @david_r suggests can help you 'clean' the content to a better result.

 

Did you try simply creating a JSON reader and point at your URL? When I do, I get the following reader definition:

You can then simply use a ListExploder on "response{}" and you should be good to go. You can also use the BulkAttributeRenamer in "Remove prefix string" mode to fix up your attribute names, if necessary. Example result after having removed the prefix "0."

Thanks David. This is what I got. Please enlighten me further. Its not showing what yours are showing. All I did is in the image attached. Thanks as I await your support.

 

 

@david_r

 

 

Reply


Community Stats

30,126
Posts
114,375
Replies
37,767
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.