Forum Discussion
Http Get with specifying 'all' for a required field
Hi parry2k : Thanks for the help! Really appreciate it.
For those newbees like me:
-I had to change the function in advance editor-> to change NoticeId type from text to number and use Number.toText(NoticeId) in the url.
-Also I copied my master data source into a 2nd table, renamed it and kept only Id Column. Then selected this table to -'Add Column', 'Invoke Custom Function' step to bring a table of records for each row/ Id on this 2nd table. After expanding the Column-> I selected which fields I need to show up in this table.
-I then added a 'Notice Details' page, added drill-through feature with 'Id', had a 'Table' visual to show info from the 2nd table [giving me the info form my api#2].
-Now I can drill-through on 'Id' from my first page/ Notice Summary: for a specific row/Id-> I go to the 'Notice Details' page and see the Details for that Notice!
Voila! 🙂
Super UserAnonymous in a scenario like this, create a function which takes id as a parameter and then in the function constructs the URL, in your main table let's say you have 10 rows values 1 to 10, and let's say it I called id. Add a custom column and in this call the function and pass the id as a parameter value. and from there you expand this custom column which will append the data for all the ids.
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡
Hi parry2k : Thanks for your response.
Since the data source is [not a db table/ file, but] an API portal, in my 'Get Data' stage: I am using Other-> 'Web' -> Advanced-> then have to specify the Web url . How can I specify the custom Column when I have not yet connected and pulled data from this data source/ Get Data? Best, Sohana
- parry2k
Anonymous I assumed you have a list of IDS that you want to pass to the url, if that is not the case where you suppose to get ids?
Hi parry2k Since I don't know the ids- so, trying to find a way to get "All" of them [that would not require me to specify any id]!
- parry2k
Anonymous it doesn't make sense to me, as per the screen shot, it required Id value and you have to have set of ids you want to pull or may be there is another api call that returns Ids and then use that to pass id to this api.
It is very hard to answer with limited information and how this API works, completely shooting in the dark here.