Fantastic - clearly explained steps to an issue with REST APIs that I've been fiddling around with for quite a while! Cheers!
@carlos_hernandez2 жыл бұрын
Thanks for putting this together. I was able to recreate the steps in less than 5 minutes for a problem I had been stuck on for a couple hours.
@archangel00719 ай бұрын
Thanks for this! Question though, do you know if this type of set up in the queries is still compatible with the scheduled online refresh?
@chrispy72992 жыл бұрын
I have tried this and get an error "Invalid URI: The hostname could not be parsed" when I use the field value for the offset, any ideas?
@hoangvucamranh3 жыл бұрын
I do like OffsetSample and then I get the error "Formula.Firewall: Query 'Query1' (step 'Added Custom') references other queries or steps, so it may not directly access a data source. Please rebuild this data combination." Is there any way I can ask for your help?
@jonathanhayton314 Жыл бұрын
I get this too did you resolve it ?
@jonathanhayton314 Жыл бұрын
Sorted it if you go to File > Options>Privacy, and select Ignore the Privacy Levels and potentially improve performance
@salvador94033 жыл бұрын
Hi Hossier, thanks for the content. You are solving my current issue: sourcing data through different pages using a REST API! However, I think you have not really explained how you set up the OffsetExample table. Could you please elaborate more on how you inset the List.Number formula? I'm struggling with that step....
@totemimaging3 жыл бұрын
You need to create a 'New Source > Blank Query' then enter the code adapted, if necessary, to the references (for example 'totalcount') that you've used in your report).
@scooterza3 жыл бұрын
Hello Hossier, your video has been very helpful. However, I am getting stuck at the step shown at 16.50. When I do this step, I keep getting an error saying "We couldn't authenticate with the details provided. Please try again." Any suggestions? I created a string as follows: = Table.AddColumn(#"Changed Type", "Custom", each Json.Document(Web.Contents(BaseURLandKey & "&offset=" & [Column1] & """,[Headers=[#""X-Integration-ID""=""MY_INT_ID"", #""X-API-Token""=""API_TOKEN_NO""]]")))