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”

1 Like

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.

Hi @ben1 , how do you get a logged in user related field available as a magic text?

I can only see two fields, External User Authentication and External User ID, see picture:

My externa collection is with Bubble.

1 Like

Adalo has some videos how to join Beta and set up the external auth - just google it.
However to be sure that you need it what this feature does is to so link external signup and login enpoint and pass the token to Adalo so that your users can be logged in through external endpoints.

In short what you will need:

  • sign up endpoint that singups your users in the external DB that generates a token to be passed to Adalo
  • log in endpoint that logs your users in the external DB that generates a token to be passed to Adalo
  • and of course external user table against which you will verify the above and store all the user data

as this feature is in beta currently I dont think you can map user ID however you Backend can retrieve it form the token so that should be fine to use if you have to end points

To follow up on the other part of questions, all other user related fields can be retrieved based on the token if you add external collection with your user table (however the fields wont be able available automatic but as per any other external collection) - you just need to for example have a list of this collection linked to some screen