PeopleHR API Newly Fails in Desktop Service

[TomTomTom]

Hi folks, 

Grateful for any help here. We use the PeopleHR API to access data, and it works fine in desktop. However, it looks like over Xmas it stopped working in Service.

All of the queries start like this:

url="https://api.peoplehr.net/Query",
body="{""APIKey"": "editted_out",""Action"": ""GetQueryResultByQueryName"",""QueryName"":""editted_out""}",
Source = Json.Document(Web.Contents(url,[
Headers = [ #"Content-Type"="application/json"],
Content = Text.ToBinary(body)
]
)),
Result = Source[Result],
#"Converted to Table" = Table.FromList(Result, Splitter.SplitByNothing(), null, null, ExtraValues.Error),

Any ideas?

[Matt_T1]

Hi @TomTomTom realise this is a very old issue but did you ever find a solution?

[TomTomTom]

Hi @Matt_T1 , have to admit I cannot remember and the report has now been superceeded.

I have a feeling we ended up contacting PeopleHR and asking them to increase the call rate we were allowed - I think we were throttled at 50 calls a minute or something - and that this worked.

(Worth mentioning that PowerQuery can send more API calls than you may think behind-the-scenes.)

[lbendlin]

Please elaborate on "it stopped working".  Do you get an error message?

[TomTomTom]

oops ... silly of me to forget that. Error is:

Processing error: We cannot convert the value "" to type List.
Cluster URI: WABI-UK-SOUTH-B-PRIMARY-redirect.analysis.windows.net
Activity ID: a32ae441-e20d-44b6-ad10-6ec2eef0836f
Request ID: 73847d5f-befe-8980-efff-fb9cc04885d9
Time: 2021-01-18 17:39:18Z

I'm guessing this means it is just not getting anything from the API and thus Table.FromList has nothing to work with.