Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
community Alteryx IO Mission Control
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Free Trial

Alteryx Designer Desktop Discussions

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

How to read data in Jason file using an API

SamSurya
8 - Asteroid
‎08-20-2020 06:30 AM

Hi Team,

 

I need to fetch some information from a Jason file using an API. Please advise How can I do that.

 

Rgds

Reply

Accepted SolutionSolved! Go to Solution.

8 REPLIES 8
echuong1
Alteryx Alumni (Retired)
‎08-20-2020 07:23 AM

To pull data using an API, use the download tool. Once you have the data downloaded in a JSON format, you can use the JSON parse tool to separate into fields, and then the cross-tab tool to put the fields horizontally. 

 

These links may be helpful:

https://community.alteryx.com/t5/Engine-Works/REST-API-In-5-Minutes-No-Coding/ba-p/8137

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Guide-to-Creating-Your-Own-Connecto...

https://community.alteryx.com/t5/Weekly-Challenge/Challenge-7-Download-Data-and-Parse-JSON/td-p/3673...

Reply
0 Likes
SamSurya
8 - Asteroid
‎08-21-2020 07:29 AM

Hi,

 

I have refer the links provided. so my API is Jason based and no Key is required so in the Text Input File, I have created 2 fields : 1. URL 2. Filename : ABC.txt

 

now have connected to Download tool

where in the URL Field I've selected URL & tried with below 2 options:

1Selected Output as String  : then I'm getting below in Download Datar "

 <!-- SiteMinder Encoding=ISO-8859-1; -->

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>Internal Single Sign-on Server</title>
<p hidden>XXX WebSSO Login</p>
<meta http-equiv="Content-Type" content="text/html; char... HTTP/1.1 302 Found
Date: Fri, 21 Aug 2020 14:17:01 GMT
Server: Apache
Cache-Control: no-store
Location: https://post.smlogin.ibb.XXX.net/SmMakeCookie.ccc?GPSESSION=QUERY&PERSIST=0&TARGET=-SM-HTTPS%3a%2f%2......

 

2. If I output data to file  : choose name from Field : Filename 

 

I get Error :  JSON Parse (3) Error message: Invalid value. at character position: 0

 

 

Please advise

 

 

 

Reply
0 Likes
ImadZidan
12 - Quasar
‎08-21-2020 07:57 AM

Hello @SamSurya ,

 

Is it possible to see the workflow.

 

Reply
0 Likes
SamSurya
8 - Asteroid
‎08-21-2020 09:31 AM

sorry... that's my challenge but i can share this much:

SamSurya_0-1598027375198.pngSamSurya_1-1598027416709.png

 

SamSurya_2-1598027457010.png

 

Reply
0 Likes
beckyconning
5 - Atom
‎08-21-2020 10:44 AM

Hey! Check out this Alteryx partner solution that makes this simple : )

 

Simply paste your API details in and it'll handle all types of pagination and authentication, even OAuth2.

 

Screenshot 2020-08-21 at 18.35.03.png

 

Then it shows you all the fields available in the JSON data and you pick the ones you want. It works even if the data is very nested.

 

 

Screenshot 2020-08-21 at 18.35.30.png

  

 

Then you copy a link and paste it into a tool in Alteryx and your API data loads into Alteryx as a nice normal table.

 

Screenshot 2020-08-21 at 18.35.38.png

 

 

You can download the tool here https://gallery.alteryx.com/#!app/Precog---Easy-and-fast-JSON--MongoDB--Web-APIs-and-more/5d5bf6708a...

 

Screenshot 2020-08-21 at 18.35.46.png

  
Simply re-run your Alteryx workflow to refresh and get the latest data from your API.

 

Reply
SamSurya
8 - Asteroid
‎08-28-2020 11:22 AM

this is really good but I t seema I have a different issue because my problem still persists.

Reply
0 Likes
beckyconning
5 - Atom
‎08-28-2020 12:25 PM

I'm happy to help get you up and running, would you like to screen-share or perhaps you can provide additional details as to the problem you're experiencing? Is there a specific error message or something?

Thanks!

Reply
0 Likes
SamSurya
8 - Asteroid
‎08-29-2020 11:17 AM

Thanks, I can not share but please allow me a day time I will share my exact problem. 🙂

Reply
0 Likes
connect with mentors
designer new user guide
Labels
Top Solution Authors
View All