Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

api call with inecure option in powerquery

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

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    HI Anonymous,

    AFAIK, power query does not allow you to get data with SSL credentials. Perhaps you can change to use OAuth credentials to get data to prevent that issue.
    Regards,

    Xiaoxin Sheng