Forum Discussion

TomTomTom's avatar
TomTomTom
Helper II
5 years ago

PeopleHR API Newly Fails in Desktop Service

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?

Need Help

4 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    5 years ago

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

    • TomTomTom's avatar
      TomTomTom
      Helper II
      5 years ago

      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.

    • TomTomTom's avatar
      TomTomTom
      Helper II
      3 years ago

      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.)