Repeating query parameters in Connector Builder for API calls

Summary

When adding multiple instances of the same query parameter in Connector Builder for API calls, only the last parameter is taken when generating the call. Looking for a workaround.


Question

hello peeps, I’m using the connector builder to make API calls to an endpoint, I’m adding query parameters to my GET request and I would like to be able to repeat several times a same parameter, like <https://myapi.com/v2/myendpoint?my_parameter=value1&my_parameter=value2> . When I add several times the same query parameter with the same name in the builder it just overwrites and take only the last parameter when generating the call. Does anybody know a workaround?



This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. Click here if you want to access the original thread.

Join the conversation on Slack

["connector-builder", "api-calls", "query-parameters", "workaround"]

Have you tried ?my_parameter[0]=val1&amp;my_parameter[1]=val2 I imagine it will depend heavily on the server framework (i’ve not tried it just used it in the past somewhere some time…)

hey Scott! thanks for your answer, I just tried it and unfortunately it doesn’t seem to be supported by the API I’m using, it’s complaining that the query field is not valid:

ERROR```
(FYI I'm querying the <https://developers.google.com/adsense/management/|AdSense Management API>)

I’m sure there is a way to do that in the Airbyte builder, it feels like a common use case

Can you have use two parent streams. Then it will call for all combinations of those parents:
https://docs.airbyte.com/connector-development/connector-builder-ui/partitioning#multiple-partition-routers

<@U04NSL0BPD0> I have the impression this is more for making different calls with several parameters values and not one call with different values for the same parameter, or?

at the end I hardcoded the query parameters in the URL path, it’s not the cleanest solution but that’s the only thing I could come up with (if people face the same issue and find this thread :sweat_smile:)