Skip to main content

Power BI

Needs Votes

Allow support for API Jobs (i.e. adding delay support)

Vote (1) Share
Chris Tout's profile image

Chris Tout on 12 Jun 2019 14:37:36

Add support to work with calling and retrieving from API jobs. For example, these: -

https://auth0.com/docs/api/management/v2#!/Jobs/post_users_exports
https://auth0.com/docs/api/management/v2#!/Jobs/get_jobs_by_id

Working with these queries currently fails as the query seems to run at the same second - therefore the job hasn't been given enough time to finish.

Comments (1)
Chris Tout's profile image Profile Picture

Chris Tout on 05 Jul 2020 23:50:42

RE: Allow support for API Jobs (i.e. adding delay support)

For reference (snippet): -

CreateJob =
let
RelativePath = "api/v2/jobs/users-exports",
Options = [Content=Text.ToBinary(""), Headers=[Authorization="Bearer "&GetToken,#"Content-Type"="application/x-www-form-urlencoded"], RelativePath=RelativePath],
RawData = Web.Contents(BaseURL, Options),
Document = Json.Document(RawData),
JobID = Document[id]
in JobID,

GetJob =
let
RelativePath = "api/v2/jobs/"&CreateJob,
Options = [Headers=[Authorization="Bearer "&GetToken,#"Cache-Control"="no-store"], RelativePath=RelativePath],
RawData = Web.Contents(BaseURL, Options),
Document = Json.Document(RawData),
LocationPath = Document[location]
in Document,