External Collection query parameter

I’m trying to filterByFormula by giving {status} = ‘ Captured’

But it is not working, the page keeps on loading. Is filterByFormula only for using Airtable api?

Any solution to filter the external api with query parameter

Filterbyformula is for Airtable, yes.
But if “status” is a query parameter of the Api used to build the external application, then you should be able to add a filter for the list, status equals “Captured”

Yes, as @ChristopheHK said you should be able to add arbitrary query parameters to the request.

@ChristopheHK @jeremy

Yes, I tried with query parameter but if we provide the values hard coded it works but if we use magic text we get empty screen.

Any solution why it’s not working for magic text

Thanks in advance

Got it. That’s likely happening if you’re pulling in dynamic values and it’s the first screen you’re viewing, because it has not yet loaded the necessary data. We don’t have a great workaround yet for this, but if you load something on the second screen, and the Logged-In User record was referenced on a previous screen, then it should work properly.

1 Like

Interesting. Thanks @jeremy

@jeremy

I’m not using on first screen.

Let me explain what I’m trying to do.

I have created a record using Custom action and in the next page I’m calling the api, where I need to filter with the order number which was created in back screen.

So when I give the same order number in query parameter, it gives blank screen.

The order number I generate and store it in database, the same order number I use it for both functionality mentioned above.

Hi @kcan were you able to figure this out? I am trying to do something similar and unable to so far. I am trying to query an external database, which works using the parameter I pass while setting up the collection. But I would like this to be dynamic using the search term the user is using. I see an option to do that as @jeremy suggested, but is not actually querying using the new term. I also tried the same using custom action with no avail. I would love to hear if there are other ideas.

P.S- I am using the Twinwords API to get a definition/usage etc of a word and would like the API call to be for the term the user is searching.

Try doing the intersectional screen with magic text that has the order number of the new order that gets created and then use screen actions from that screen forward.

Just discovered Adalo. Very cool, but it fails on my first use case. I want to call an external API to implement a search. I can’t use collections because it requires a successful query upfront, which requires I supply all query params; and I can find no easy way to override the query param established when setting up the collection. I can’t use custom actions because there is no way to parse a results list.

Hi @bobcardenas,

You can now use a logged in user related field as magic text in an external collection set up. Then on the step before you reach the screen with the required external collection list, add a step to update these fields on the logged in user. This will then give you the filtered results in this list based on those fields contents.

Let me know if that makes sense!

Regards,

1 Like

Thanks Ben, just used and worked fine.

1 Like

Thanks, @ben1, that’s great news. I ended up working around this issue by creating a Firebase function to front the API I needed to call. Not so bad since I’ll need another Firebase functions too, but I’ll keep this option in mind.