Alteryx Designer Desktop Discussions
Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
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 :
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
Your main issue is that you aren't specifying a query string and it is pointed at the URL which is throwing the error. You will want to choose the "Compose Query String/Body" option up top. Additionally, you will want to follow the API documentation for what parameters to pass through:
It looks like the proper format for the API call for what you are looking to do is
https://api.gleif.org/api/v1/lei-records/5067002PTFI40N9JMB37
where the value after the last slash is the ID for the LEI. I have added additional information below and attached the workflow that returns the results and parses the JSON.
Yep! So this is just another API call. It looks like the proper endpoint is going to be the "Fuzzy Completions"
"You can also find Legal Entities with potentially similar names using the fuzzycompletions endpoint. This type of search can provide a convenient starting point for obtaining LEIs."
This would be your first API call and you would find the ID from the results of this call and then use that ID to create the URL that would be passed in to the next download tool. I will see if I can mock it up for you.
Here you go. I had some time this morning so I built it for you 🙂
I also adjusted the workflow version down so you should be able to open it without a warning. Let me know if this works for you
HI BrandonB,
Thanks for your swift Response.
I am still struggling to run the query ( but i think that an issue for me internally at my company with proxys settings etc.)
I have question for you, I am trying to go through the flow and understand whats happening.
If my understanding is correct the first part of the flow you are doing the following;
- Establishing a connection to the API
- We are using the fuzzycompletion endpoint
- we are only searching in the parameter value of "Entity.legal Name"
- q = is the company name we are passing in the "Entity.legal Name" parameter
The question i have is if i want to pass more than one company name at a time ( lets say 200 at a time).
How would the query reflect this?
You are correct that you most likely have some proxy settings preventing the query.
If you want to pass in multiple values, you can pass in the data from an upstream field rather than hard coding it in the configuration. So instead of hard coding it like I am doing below, you can have a column called q with a list of company names from an Excel file and you would just check the box next to the column in my picture below. You would also want to delete the hard coded q value up top.
The download tool will execute one API call per row of data that is passed into it, so you can do an entire list of companies as part of one process.
