Sending a GET request

[nariman]

Hi everybody,

Congratulations on the successful launch.

I was wondering if you could help me debug the following GET request:

=GET("https://api.mixnode.com/queries",'[{"Authorization": "Basic XXXXXXXXX"}]')

I get: #FAIL! headers: Invalid JSON

[guven2.0]

Hi Nariman

if you leave out the [ ] in your header, then it should work

Here you go:

=GET("https://api.mixnode.com/queries",'{"Authorization": "Basic XXXXXXXXX"}')

Pro Tip: use PAIR2JSON to build your headers

A1 = Authorization
A2 = Basic
A3 = XXXXXXXXXXXXXX
A4 = A2&" "&A3
A5 = PAIR2JSON(A1,A4)
A6 = GET("https://api.mixnode.com/queries",A5)

Your PAIR2JSON will build the header for you:

Let me know if you encounter any further problems!

Happy building