JSON Parse tool only display two records, API Calls

[Shannon11113]

Hi, I am trying to display the records using the JSON Parse tool but it only displays these 2 records. I have tried using the text to column tool but when I use it, It does not show any records at all. 

[apathetichell]

look into your download data - that's the payload returned from your api call. Does it have more than two pieces of data? If so - please post a sample and include your full json tool config (it's cut off now)... If it only shows the two pieces your next issue is why is the api response different than you'd expect.

[Luke_C]

Hi @Shannon11113 

What output are you looking for? The JSON parse tool will make a record for each item, the usual next step is to cross-tab the data (with additional steps depending on the complexity of the JSON structure)

Also, it may not be wise to chare your account key in the screenshot.

[Shannon11113]

Hi this is my download data. I wanted to use text to column to split the output into different rows, but it did not work, hence why i decided to use the Json tool. 

[Shannon11113]

Hi, I'm looking for an output that looks like this. Right now the download data column containes the api response in one row. I would like to split it into multiple rows. I have tried using JSON Parse tool and text to column, both of which don't seem to work so far 

[Luke_C]

Hi @Shannon11113 

Can you attach a sample dataset? Your last screenshot looks like what I'd expect from a JSON parse. The usual next steps are:

1. Text To Columns on JSON_Name (3 columns based on your screenshot)
2. Crosstab with the 2nd text to column field as your group by, 3rd text to column field as your headers, and JSON_ValueString as your value

[Shannon11113]

Hey this is where i got the data from datamall2.mytransport.sg

I have tried using text to columns, but it does not split the download data for me

[Luke_C]

Hi @Shannon11113 

The text to columns tool will not work on the download data. You need to use the JSON parse tool first, then the steps I described. The link you gave doesn't work for me nor do I have an access code for the data. Please attach the dataset that is output from the json parse tool (assuming there is no sensitive information). Pasting into an excel will work fine to demonstrate the steps - it won't be efficient for anyone to re-type the data from a screenshot.