How to get data into Google Data Studio?

User Support Data Management
,
10

I figured this out! Thanks so much for this write up but the instruction is incomplete. Using some info from here: API call sometimes forgets authentication?

I figured it out!

  1. you need to go to here:
    https://www.base64encode.org/

type in USERNAME:PASSWORD (use your own obviously), then hit “encode”, then take that BASE64 String and put it in this string, replace YOURSTRINGHERE

{“Authorization”:“Basic YOURSTRINGHERE”}

so you end up with something like

{“Authorization”:“Basic amZzdGF0czpuZWhlb2lhaA==”}

  1. take that and paste into “HTTP Headers” when you set up the connection in data studio.

Now you should be ok because the API needs authentication!

Buy me a coke :smiley:
Ray

4 Likes