How to Dynamically Pass Current User's Name from Bubble to BigQuery via Make.com?

[sales12]

Hello,

I’m using Make.com to integrate Bubble with BigQuery to pull in some data. I’d like to include the current user’s name in the API call so that only data associated with that user is retrieved. While I’ve successfully passed a static variable to BigQuery (as shown in the example below), I’m unsure how to dynamically pass the current user’s name.

Any guidance would be greatly appreciated. Thanks!

[adamhholmes]

You need to ‘uncheck’ the ‘Private’ option on the User ID parameter in order to be able to insert a dynamic value when making the call.

[sales12]

Thank you! That did the trick. I also had to remove the value I had in the API. It’s working well now.