Forum Discussion

amaasen's avatar
amaasen
Frequent Visitor
1 year ago
Solved

API Connection Question

I've tried to create a PowerBI connection to the API I was provided by our vendor, but it keeps timing out. Any suggetions on how to achieve an API connection with the details below?     
Need Help
  • amaasen's avatar
    amaasen
    1 year ago

    Still an issue with even reporting 1 days worth of data. I spoke with the vendor and we are going to try alternative methods. 

vojtechsima's avatar
vojtechsima
Icon for Super User rankSuper User
1 year ago

Hello, amaasen ,

try something like this:

let
    Source = Web.Contents(
        "https://sam.lqdt1.com",
        [
            RelativePath = "v3/getsold.cfm",
            Query = [
                token    = "<YOUR_API_KEY>",
                accntID  = "<YOUR_ACCOUNT_ID>",
                startdate= "11/30/15",
                enddate  = "12/31/15",
                format   = "json"
            ],
            Headers = [Accept="application/json"]
        ]
    ),
    JsonOut = Json.Document(Source)
in
    JsonOut

Optionally, you need to include Authorization header, in case you need additional security layer. Either way when it will ask, set your Data source credentials to Anonymous and handle authorization inside the call.