API Lookup Connection DownLoad transfer error

[Masond3]

Good Afternoon Team, 

Hope your well. 

I am hoping you can help me or point me in the right direction. I am trying to connect to an API where i am hoping to pass company names and in turn the API returns the relevant results. 

The GLEIF LEI Look-up API makes it possible to easily find up to 200 LEI records included in the Global LEI Index with one request.

The GLEIF LEI Look-up API is supported by JSON data so i know that the next step is to parse the data - using the JSON Prse tool and connect the JSON Parse tool to the Download tools

Reading the documentation this is an the API i should be using;

https://api.gleif.org/api/v1/lei-records?filter[entity.legalName]=xxxxx&page[number]=1&page[size]=5

NB : xxxxx is the parameter where i need to pass the relevant company name 

If i use the company name of "Sto Bene Partners SA"

Full URL would be : 

https://api.gleif.org/api/v1/lei-records?filter[entity.legalName]=Sto%20Bene%20Partners%20SA&page[nu...

Using the full URL and pasting into google i can see it returns a result set back 

I have created the following Alteryx Workflow but i am getting an error when using the download tool

Alteryx Version 2019.3 64 bit 

Looking Forward to your response 

[BrandonB]

The Download tool is basically making a cURL request using the Internet Settings that are specified in Internet Explorer: https://help.alteryx.com/current/designer/download-tool

Are you able to navigate to one of those API endpoints directly from Internet Explorer? 

[Masond3]

Hi, 

so if my understanding is correct this is the complete endpoint we should be hitting.

https://api.gleif.org/api/v1/fuzzycompletions?field=entity.legalName&q=hacker

If that’s the case , when I’m chrome when I type  that link into the url and push return it does return data . (I haven’t tried in internet explorer though)

Speaking to some colleagues in the US they are saying it’s a company proxy issue and they got around it via python ... so who knows what the issue is 

[BrandonB]

I would ask one of those coworkers if maybe you could get an example of how they are doing it with the python tool. The same process can be adapted to work within the Python tool and then return the data back into the workflow. 

[Masond3]

HI BrandonB, 

I have read the flow my colleague sent me and i have some understanding of that is doing, however the python connection has still baffled me. I will liaise with my IT team aswell to see if we can query that end point or if it’s completely blocked.

have a great xmass and no doubt il be in touch.