Forum Discussion

TheDev's avatar
TheDev
New Contributor
2 years ago
Solved

I need to retrieve data from a public API

I am new to snaplogic and I have an exercise where I need to retrieve data from randomuser.me/api/. I have to filter the data based on age and a few more things. Can someone tell me the basics and wh...
  • koryknick's avatar
    koryknick
    2 years ago

    TheDev - I just did a quick search on the API you list above and it appears you can get multiple results in a single call:

    https://randomuser.me/api/?results=100

    I recommend you use a JSON Splitter to pull individual records out of the returned results array, then a Filter snap to reduce the data to your desired results.  If you want to transform the records from there, use the Mapper snap.

    If you are looking for a way to kick start into SnapLogic, register for an upcoming training workshop!

    Hope this helps!

     

koryknick's avatar
koryknick
Employee
2 years ago
Copy LinkReport

TheDev - I just did a quick search on the API you list above and it appears you can get multiple results in a single call:

https://randomuser.me/api/?results=100

I recommend you use a JSON Splitter to pull individual records out of the returned results array, then a Filter snap to reduce the data to your desired results.  If you want to transform the records from there, use the Mapper snap.

If you are looking for a way to kick start into SnapLogic, register for an upcoming training workshop!

Hope this helps!

 

  • TheDev's avatar
    TheDev
    New Contributor
    2 years ago
    Copy LinkReport

    Thank you, I solved it before the reply and I came to say it's done. I didn't know much about APIs and now I understand that I should've gone through the documentation first to understand how I can handle the data. I solved it by adding a query parameter like in the picture.

     

    Also, thank you for suggesting the training workshop. Have a good weekend!