Hello Im being suck to understand how to leverage the GET ONE service when I setup my external collection. My usecase is pretty simple: I have a list of external collection (get all) when user click on one item of that list, he will be redirected to the next screen and I want to call the Get One…

we are in the same situation, i do my api to return all data that i want to show in the get all but this approach may be heavy but I don’t know any better way, by default adalo try the get one method on click of the item so I would like to understand how to optimize

Please read my reply to this thread: [image] Need help with get one method External Collections, Custom Actions & Collections Hey there @FabioAdaloC You have to be able to use a query from the API that you are using to filter the data. Unfortunately, you did not mention …

Hi @Flawless I am in the same boat, I think. I have a nice External Orders collection. I want to load only those orders, from the external collection, into a simple list that meet a value input by the user on a screen. Don’t want users seeing everyone’s orders. I am using a Sheety API for a goo…

@pendermj I’ve never used Sheety before. It appears that you can use “filter” as a query parameter with Sheety API [Screen Shot 2022-08-02 at 12.03.13 PM] [image] Sheety - Making requests Turn any Google Sheet into an API instantly. Power websites, apps, or whatever you like, all fro…

Thanks for responding @Flawless . I have looked at all of Sheety’s examples for filtering but what I want is to be able to filter based on a dynamic value that the user enters into a text box. A value that is also contained in the records of the external collection. I will chase down Sheety and se…

… more precisely, the value of the property would be a variable. Filter phoneNum = variable_phoneNum How to show a variable in adalo.

External Collections & Get One

Get Help External Collections, Custom Actions & Collections

Flawless March 22, 2022, 11:33am 3

Please read my reply to this thread:

Topic		Replies	Views
GET One in external collection External Collections, Custom Actions & Collections	7	1021	November 18, 2022
Filter an external collection list in adalo page External Collections, Custom Actions & Collections	0	425	October 12, 2022
Showing Single Record from the External Collection External Collections, Custom Actions & Collections	23	1021	March 2, 2022
Custom Data in API request? Get Help	22	6445	August 17, 2020
External collection query param works? External Collections, Custom Actions & Collections	5	764	May 31, 2022

External Collections & Get One

Related topics