In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start Free Trial

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
Top Solution Authors