Cannot convert type Binary to type Text - Text.ToBinary

[dedelman_clng]

I am getting the above error message on this piece of PowerQuery code

body = Text.ToBinary(Json.FromValue([login_id = client_id, security_key = client_secret]))

client_id and client_secret are defined as parameters, type "Text" and they are alphanumerics strings except for a single "@" in client_id and a single "-" in client_secret

The error doesn't even make any sense as I thought we're converting to binary not from binary.

I'm on Version: 2.126.927.0 64-bit (February 2024) if that makes any difference.

Any help appreciated,

David

[Anonymous]

Can't you just remove the Binary.FromText function?

[Anonymous · Accepted solution]

That's because JSON.FromValue outputs a binary type, which you are then wrapping in Text.ToBinary. So you are now feeding the Text.ToBinary function an already binary value (the JSON.FromValue). PQ is saying " this value is not text".

--Nate

[dedelman_clng]

Thanks Nate. I got that code from a MS support resource in another thread so I assumed it was correct code. Back to the drawing board...