Skip to main content

Power BI

New

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

b2418153 da10-4610-8bcf-e49f5f12a047 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,