Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Post JSON without PowerBI Reformatting it

I need to send this post data to an API endpoint: { "limit": 5, "detailed": "true", "policy.complianceStandard": "Scope 2021", "timeRange": { "type": "to_now", "valu...
Need Help
  • lbendlin's avatar
    lbendlin
    4 years ago

    You are supposed to use Text.ToBinary, not Text.FromBinary.

lbendlin's avatar
lbendlin
Super User
4 years ago

You are supposed to use Text.ToBinary, not Text.FromBinary.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Many thanks for this, I think I tried so many things over many days I kept this error in, I installed fiddler and got a bit further, the posted JSON appears to be valid.

 

What's happening is becuase I have:

Prisma = [
    Authentication = [ 
        UsernamePassword = [
            UsernameLabel = "API User",
            PasswordLabel = "API Password"
        ]
    ],
    Label = "Data Connector"
];

Power Query is adding a header:

Authorization: Basic XXXX

 

The remote webserver is replying:

message=request has different values in X-Redlock-Auth and Authorization, unclear which to use.

 

It doesn't understand why I'm sending over an API key and setting the Authorization header to basic.

 

Is there a way to remove Authorisation from the header or change my inputs so I can ask the end user for a username / password (this is how I get the login key) but don't set the header?

 

API Doc: https://docs.paloaltonetworks.com/prisma/prisma-cloud/prisma-cloud-admin/get-started-with-prisma-cloud/access-the-prisma-cloud-api.html 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Just an update, I got it to work (thanks for the advice), sharing for completeness

     

    I needed:

    ManualCredentials = true

     

    In the request.

            responseAlert = Web.Contents("https://api.io/v2/alert", [
            Headers = [
                #"Content-Type" = "application/json",
                #"x-redlock-auth" = token
            ],
            Content = Text.ToBinary(alertPayload),
            ManualCredentials = true
        ]),