Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Calling multiple APIs based on a column

Hello - hope someone may be able to give me a steer here; I've looked around the forums, googled a bit and cannot find an answer (that I can understand/implement).   The link for the PBIX is at the...
Need Help
  • parry2k's avatar
    parry2k
    6 years ago

    Anonymous Hi there solution is attached. I just did the basic api call and then made an call for each id to get lat and long. You can make the changes as per your need.

     

    Also created a small visual based on lat and lng. here it is Would appreciate Kudos 🙂 if my solution helped.

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

This is awesome and just what I needed, thank you so much.  Would you mid just talking me through what you did briefly?

 

I can see you've invoked a custom function which I think is calling the lat/long from from the id column, is that right?

 

Thanks again - very much appreciated

parry2k's avatar
parry2k
Super User
6 years ago

Anonymous you are right, created a function which takes ID url as a parameters and transform the data to return a table with Lat/Long.

 

If you need more in-depth detail, please let me know.

 

Would appreciate Kudos 🙂 if my solution helped.