Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Writing API DownloadData as JSON output

fardeen9983
8 - Asteroid

I am using the download tool to fetch JSON data from an API. I want the DownloadData field to be saved as an output JSON file. The problem is that it is not correctly formatting the data and adding it to file as it naturally should

 

What I need the output file to be like:

{
    "value" : [
         Some data
     ] 
}

But what I am getting is this

[
   {
       "DownloadData" : "{ \"value\" : [ some data ]  }"
   }
]

 How do i get it in the proper expected format?

1 REPLY 1
DavidP
17 - Castor
17 - Castor

Hi @fardeen9983 

 

I would configure the Download tool to output the data to a string and then use the Output Data tool and configure it as follows, using CSV file format. Example attached.

 

DavidP_0-1611336368106.png

 

Labels