Forum Discussion

BH22One's avatar
BH22One
Helper I
4 years ago
Solved

JSON API Call Script Help

Good Afternoon PBI Community,   I am fairly new to JSON language as it pertains to APIs. Currently, I have an M script in Power Query that returns a binary list as seen below (FYI I have a Bearer T...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi BH22One , does the following work:

     

    let
    Source = 
    Csv.Document( 
        Web.Contents(
            "https://US.api.blackline.com/api/completedqueryrun/",
            [
                RelativePath = GetReportId() &"/CSV",
                Timeout=#duration(0, 0, 30, 0),
                Headers=[Authorization="Bearer "& GetAccessToken(), #"Content-Type"="application/octet-stream"]
            ]
    ), 
    [
        Delimiter=",",
        Columns=13, 
        Encoding=65001, 
        QuoteStyle=QuoteStyle.None
    ]
)
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi BH22One !

Can you elaborate how your GetAccessToken() function works?

I'm strugguling with authorization..

 

  • BH22One's avatar
    BH22One
    Helper I
    3 years ago

    Hello Anonymous Sorry for the delay. I have been away on parental leave and logged off completely from anything work related. Are you still in need of some information on the GetAccessToken() function? You can send me a direct message and I can try and provide some assistance.

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Sure! No worries 🙂 

      Message should be in your mailbox. Will appreciate your guidance!