API out put to excel

[Dinesh_Babu_S]

Hi all.
I am practicing on currency converter API, and this is the out put I am getting.
Now I need to write the currency name and value to excel in separate columns.
How can we achieve this.
Thank you

[Yurii_Horobets]

Hey,
Check out this topic

How to read key_value from the json array

This is my json, I want to read the values and save into excel. { “marketValues”:[ {“location”:“kakinada”,“species”:“shrimp”,“subSpecies”:“bolt shrimp”,“date”:“43799”,“count”:100,“rate”:116,“rateValue”:0}, {“location”:“kakinada”,“species”:“shrimp”,“subSpecies”:“bolt shrimp”,“date”:“43800”,“count”:100,“rate”:129,“rateValue”:0}, {“location”:“kakinada”,“species”:“shrimp”,“subSpecies”:“bolt shrimp”,“date”:“43801”,“count”:100,“rate”:114,“rateValue”:0} ] }

[SowmyaLeo (Sowmya Sivakumar)]

@Dinesh_Babu_S

Hello and welcome to the community.
Build a data table with 2 columns for currency code and value (ensure the data types chosen are correct)
You can Use a Deserialize Json activity on the output variable of the API request.
The type argument will be a dictionary of String,String


Then use a For each activity with Type Argument of Key Value Pair (String,String)

item.key will give the currency name
item.value will give the currency value.

They can be added as DataRow into the Data Table created above (within the for loop)
Then they can be added to the Excel sheet.

[Dinesh_Babu_S]

Hi Sowmya.
Thank you for responding.
But I am getting an error while selecting the Argument type in Deserialize JASON.

[NIVED_NAMBIAR (NIVED N)]

Hi @Dinesh_Babu_S

Change the type of argument as

Newtonsoft.json.linq.jobject

[Dinesh_Babu_S]

Hello Nived.
what is he argument type to be selected in the for each loop?
Currently I have selected “System.Collections.Generic.KeyValuePair<TKey, TValue>”(Getting ERROR: Not all generic types could be resolved).
I just want to write the currency name and currency value in to the data table/Excel.

[SowmyaLeo (Sowmya Sivakumar)]

The argument type to be selected in the for each loop is keyvaluepair(string,string)