Fetch Complex JSON Data with Nested Arrays and convert to csv

Help Activities
, ,
1

Hello Community,
I have a question. I have some complex json data https://api.plos.org/search?q=title:DNA It has multiple nested arrays. I need to Fetch “docs” array data which itself has multiple arrays like “authors” “abstract” etc. I am able to fetch data using HTTP request and get JSON String. Then I use “deserialize JSON activity” on the string and get a JSON Object. Then i use “deserialize JSON array activity” to get “docs” data.
Now here i am storing data in the CSV but the nested arrays like “authors” is showing as System.String in the csv.

What should i do about the nested arrays?
I have attached the xaml and csv output for reference.
Books.txt (2.2 KB)
Main.xaml (10.1 KB)

2

@muhammad_ali
welcome to the forum

grafik
output - myJObject

grafik
grafik1002×391 148 KB

grafik
grafik1007×171 93.2 KB

for the authors and Abstracts we got the result as String array. So we have two options:

  • reacting before conversion
    grafik

  • reacting after conversion
    String.Join(“,”,DirectCast(myDataRow(“author_display”), String()))

1 Like
3

Thank you for replying…
I am new to rpa as a whole. Can you please elaborate a bit about what i need to do and which activity to use