I need help to process json file and write it out in csv. Thanks.
Solved
Request for Workspace to process recursive json file
Best answer by david_r
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."
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
- Best Answer
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."
+18- Supporter
Can you please be elaborate? Thanks
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."
@david_r
