Can custom information be used to query an external collection. For example the API needs a users address in order to return the right information.

It’s very related to this, though the query params you’ll use are different, based on which API you’re using: Filtering Airtable Lists - Adalo Resources

Hey Jeremy, Thank you for this! It looks like this may work if I am reading this right. If I am understanding this correctly. I would set up an external collection via API with the “query param” placed in there. Let’s call that “q”. Then when creating the list, I can create a filter with the param…

No, I don’t think so. If I am correct, the filterbyformula option works only for Airtable external collections. I’d like tu use other api / external collections, but they require a dynamic parameter as a path parameter, aka as part of the endpoint url, and that’s not possible today in terms of exter…

Hey Christophe, Yeah. I have been unsuccessful in getting this to work. However, reading through this topic External Collection query parameter - #4 by kcan It does seem that this should be possible using magic text and filterByFormula on non Airtable External Collections as well. Even with using …

I am facing the same issue using an airtable external collection and the need of an intermediate load screen. I have still some adjustments to do but if I succeed in getting the result I expect, I will let you know. The indication about the filterbyformula is not clear enough. In the help docs, it’…

[image] ChristopheHK: The indication about the filterbyformula is not clear enough. In the help docs, it’s stated that filterbyformula accept as value any airtable formula. So I’m not really convinced this query parameter can be used for any other external collection type… Deep dive needed here! …

See Filtering for Airtable not working with Magic Text - #14 by bgschust

Hi @zakakatz . I’m trying to pass in a dynamic query parameter for an external collection via a property in my user collection. It is working, but I’m not able to make a list with the response using the custom action. Any ideas?

You basically have to save the response in an Adalo collection. See tutorial video in Custom Action Outputs are Live!

thanks @karimoo . It works for a response of a single item. What I have been trying to archive is to show on a list of items the response of several items. An input has a value and then the value is taken as a param on the Api Call, the response comes with several items and not just a single one. I…

Custom Data in API request?

Get Help

karimoo August 4, 2020, 6:09am 18

@zakakatz You need to spilt the endpoint URL and the query parameters.
Try to setup it up like this:

External collection - Query parameter not working

Topic		Replies	Views
External collection - Query parameter not working Get Help	15	2423	August 19, 2020
External collection query param works? External Collections, Custom Actions & Collections	5	750	May 31, 2022
Filter an external collection list in adalo page External Collections, Custom Actions & Collections	0	421	October 12, 2022
Custom List with External Collection - filtered result - count? External Collections, Custom Actions & Collections	6	2730	October 4, 2021
External Collection query parameter Get Help	16	2798	September 28, 2021

Custom Data in API request?

Related topics