Forum Discussion
Use existing table column to loop through each id and create a new table with API
Hi All Im working with the Freshservice API (Ticket platform) and have had good success pulling in ticket and associated tables/data into Power BI. I have used this link to get around pagination iss...
Can you provide an example of the query to loop through all ticket ids from the ticket table? Would i need to use some like this to load the values into a variable?
source = Table.SelectColumns(AllTickets,"id"),
As you can probably appreciate it is nearly impossible to help with API queries without access to said API (which you may not be willing to provide for understandable reasons)
