API troubles

[dlopez]

Hi Community, 

Was wondering if anyone could tell me what I'm doing wrong, attached is my workflow, I'm trying to play around with APIs and found an open source data table, URL below, and was trying to pull that data table (csv format) into Alteryx to play with it but getting it in the right structure/format is proving a bit difficult for me. Any help would be greatly appreciated. 

URL = https://www.dallasopendata.com/Public-Safety/Police-Incidents/qv6i-rri7

Cheers, 

david

[echuong1 · Accepted solution]

Use the API provided. It downloads the data in a JSON format, and you can use the JSON parse tool to parse it once it's been downloaded.

[patrick_digan · Accepted solution]

@dlopez For another option to get to the same spot, you can download the file and then read it back in with a dynamic input.

[dlopez]

Hi @patrick_digan  and @echuong1 

Thanks for the quick fixes, both worked perfectly, only had one question. There seems to be ~700k records from the site but when I pull it into Alteryx, and even create an output, I'm only getting 1000. Is there a data limit function that I'm missing in one of the tools and is it possible to pull in all 700k records? 

Cheers, 

david

[echuong1]

Looking through the documentation quickly, it looks like you need a license to access the full dataset:

https://dev.socrata.com/foundry/www.dallasopendata.com/qv6i-rri7

[patrick_digan]

@dlopez You can use a different URL to get the whole dataset via csv. Note that their side is really slow, so it took 2 minutes for the file to download. Here is the url:

https://www.dallasopendata.com/api/views/qv6i-rri7/rows.csv?accessType=DOWNLOAD&api_foundry=true

I got that URL from here: