Error accessing API

[Markzolotoy]

I have to following code:

EncodedCredentials = Binary.ToText(Text.ToBinary("client_id" & ":" & client_id, "username" & ":" & username, 
    "client_secret" & ":" & client_secret, "grant_type" & ":" & grant_type, 
    BinaryEncoding.Base64)),
  
    data  = Json.Document(Web.Contents(api_url,
    [ 
      Headers = [#"Content-Type"="application/x-www-form-urlencoded"],
      Content=Text.ToBinary(EncodedCredentials)
    ]
    )
    )

where I need to send 5 parameters. I am getitng tthis error:

5 arguments were passed to a function which expects between 1 and 3.

Any what tha is?

Thanks

[Markzolotoy]

While I am not getting the rrror anymore the backend still returns 400. That's why I am asking about Fiddler in the other thread.

[PhilipTreacy · Accepted solution]

Hi @Markzolotoy 

Your call to Text.ToBinary has too many arguments.

You should be supplying a string and an encoding type but you are supplying several strings because you are splitting them up with commas.

Text.ToBinary("client_id" & ":" & client_id, "username" & ":" & username, "client_secret" & ":" & client_secret, "grant_type" & ":" & grant_type, BinaryEncoding.Base64)

Remove the commas and make just a single string as the first argument.  Something like this

Text.ToBinary("client_id" & ":" & client_id & ",username" & ":" & username & ",client_secret" & ":" & client_secret & ",grant_type" & ":" & grant_type, BinaryEncoding.Base64)

The exact format will depend on what your API requires.

regards

Phil