Forum Discussion

tthierry's avatar
tthierry
Frequent Visitor
7 years ago
Solved

API Calls from column

Hi   So here is the challenge, I have an API in the format https://api.workflowmax.com/job.api/get/[id]/customfield?apiKey=[apiKey]&accountKey=[accountKey]   The ID changes for each job and jobs ...
Need Help
  • zoloturu's avatar
    zoloturu
    7 years ago

    Hi tthierry,

     

    I've tried this earlier. You need to follow below logic:

     

    let
...
PreviousStep = ... ,    

Step = Table.AddColumn(PreviousStep, "NewColumnName", each Json.Document(Web.Contents("https://api.workflowmax.com/job.api/get/" & [id] & "/customfield?apiKey=[apiKey]&accountKey=[accountKey]"))),

in Step

    Regards,
    Ruslan
    -------------------------------------------------------------------
    Did I answer your question? Mark my post as a solution!

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi i've a curl comand with insecure option to access our splunk(returns unauthorized coz of wrong user name pass)

curl -u user:pass -XPOST "https://splunkeda-api.something.com:8089/services/search/jobs/1" --insecure
<?xml version="1.0" encoding="UTF-8"?>
<response>
<messages>
<msg type="ERROR">Unauthorized</msg>
</messages>
</response>

 

IF i run the curl without insecure oprion it gives certificate error

curl -u user:pass -XPOST "https://splunkeda-api.something.com:8089/services/search/jobs/1"
curl: (77) schannel: next InitializeSecurityContext failed: SEC_E_UNTRUSTED_ROOT (0x80090325) - The certificate chain was issued by an authority that is not trusted.

So basically am writing a powerquery to fetch data from this api :
url="https://splunkeda-api.something.com:8089/services/search/jobs/1",
param="something",
Source = Json.Document(Web.Contents(url,[Query = [start = param]])),
gives error
An error occurred in the ‘’ query. DataSource.Error: The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel.

How can i mention insecure option(verify=False in python requests) in power query

Please help.