# External collection - Query parameter not working

**URL:** <https://forum.adalo.com/t/external-collection-query-parameter-not-working/3322>\
**Category:** Get Help\
**Created:** [August 16, 2020, 2:45pm UTC](https://forum.adalo.com/t/external-collection-query-parameter-not-working/3322 "2020-08-16T14:45:22Z")\
**Posts on this page:** 17\
**Page:** 1

<div class="post-metadata">

**Author:** ![iamharims](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/iamharims/32/1874_2.png) [@iamharims](https://forum.adalo.com/u/iamharims)\
**Post date:** [August 16, 2020, 2:45pm UTC](https://forum.adalo.com/t/external-collection-query-parameter-not-working/3322/1 "2020-08-16T14:45:22Z")

</div>

Hello,

@ashley  
@Ben

[Critical issue and an urgent fix needed please or let me know if I am missing anything]

Looks like there is a critical issue in adding query parameter for API end points. While setting up and testing api requests for different query parameters, added query parameter is not showing up in API test screen. So it is blocking in creating parameterised api test collections.

Also if there is an ability to add magic texts while adding query parameters would be a great feature to use external collection with different parameters in run time.

At the moment only one api end point can be configured. So it is not really useful for setting for real projects.

Screenshots are here ( screens are as per flow steps)

[https://drive.google.com/file/d/1MCuKiIpIu6pCT1Tzjl94TqSd4lVeZyHA/view?usp=sharing](https://drive.google.com/file/d/1MCuKiIpIu6pCT1Tzjl94TqSd4lVeZyHA/view?usp=sharing)  
[https://drive.google.com/file/d/1TMtJlgYS9J-M-GdK5UL7hl0H8d-dyFbP/view?usp=sharing](https://drive.google.com/file/d/1TMtJlgYS9J-M-GdK5UL7hl0H8d-dyFbP/view?usp=sharing)  
[https://drive.google.com/file/d/1HndsaLa1RZ9csZW40ydii0qOdDNbT7P7/view?usp=sharing](https://drive.google.com/file/d/1HndsaLa1RZ9csZW40ydii0qOdDNbT7P7/view?usp=sharing)

---

<div class="post-metadata">

**Author:** ![karimoo](https://avatars.discourse-cdn.com/v4/letter/k/ad7895/32.png) [@karimoo](https://forum.adalo.com/u/karimoo)\
**Post date:** [August 16, 2020, 3:44pm UTC](https://forum.adalo.com/t/external-collection-query-parameter-not-working/3322/2 "2020-08-16T15:44:18Z")

</div>

Hi @iamharims, you have to put the query parameters into the filter of a list.  
Here you have Magic Text available. see: [Custom Data in API request? - #18 by karimoo](https://forum.adalo.com/t/custom-data-in-api-request/1983/18) and [Problem with sheetdb and query parameters - #2 by karimoo](https://forum.adalo.com/t/problem-with-sheetdb-and-query-parameters/2772/2)

---

<div class="post-metadata">

**Author:** ![ishantanusrivastava](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/ishantanusrivastava/32/34947_2.png) [@ishantanusrivastava](https://forum.adalo.com/u/ishantanusrivastava)\
**Post date:** [August 16, 2020, 3:45pm UTC](https://forum.adalo.com/t/external-collection-query-parameter-not-working/3322/3 "2020-08-16T15:45:11Z")

</div>

Yes, I agree with the @iamharims that we need the ability to add magic texts while adding query parameters coz 2-3 clients drop their idea due to this.

---

<div class="post-metadata">

**Author:** ![ishantanusrivastava](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/ishantanusrivastava/32/34947_2.png) [@ishantanusrivastava](https://forum.adalo.com/u/ishantanusrivastava)\
**Post date:** [August 16, 2020, 3:46pm UTC](https://forum.adalo.com/t/external-collection-query-parameter-not-working/3322/4 "2020-08-16T15:46:43Z")

</div>

It is needed in case of dynamic API endpoints

---

<div class="post-metadata">

**Author:** ![karimoo](https://avatars.discourse-cdn.com/v4/letter/k/ad7895/32.png) [@karimoo](https://forum.adalo.com/u/karimoo)\
**Post date:** [August 16, 2020, 3:48pm UTC](https://forum.adalo.com/t/external-collection-query-parameter-not-working/3322/5 "2020-08-16T15:48:19Z")

</div>

I see. In this case you need to use Custom actions.

---

<div class="post-metadata">

**Author:** ![karimoo](https://avatars.discourse-cdn.com/v4/letter/k/ad7895/32.png) [@karimoo](https://forum.adalo.com/u/karimoo)\
**Post date:** [August 16, 2020, 3:52pm UTC](https://forum.adalo.com/t/external-collection-query-parameter-not-working/3322/6 "2020-08-16T15:52:58Z")

</div>

See: [Custom Action Outputs are Live!](https://forum.adalo.com/t/custom-action-outputs-are-live/2858)

---

<div class="post-metadata">

**Author:** ![iamharims](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/iamharims/32/1874_2.png) [@iamharims](https://forum.adalo.com/u/iamharims)\
**Post date:** [August 16, 2020, 4:01pm UTC](https://forum.adalo.com/t/external-collection-query-parameter-not-working/3322/7 "2020-08-16T16:01:07Z")

</div>

@karimoo - The issue I am talking about External collection. I think you were pointing me to custom action. Custom action is not logically useful in case external collection and listing collection data based on dynamic queries. Custom action is completely built for different purpose where it is for trigging third party endpoints and so on. [Let us not get confused using custom action to construct external collection business logics. if we try to use work around for main business logics in realtime Apps performance and UX will go toss. So I think surly there is a issue/ missing feature in external collection]

I have tried all the option but no help yet. As i explained in the issue detail, we definitely need fix for this to make use of external collection for dynamic parameters.

I have also discussed this with Adalo training experts and got confirmed that it needs a fix.

Thanks

---

<div class="post-metadata">

**Author:** ![iamharims](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/iamharims/32/1874_2.png) [@iamharims](https://forum.adalo.com/u/iamharims)\
**Post date:** [August 16, 2020, 4:06pm UTC](https://forum.adalo.com/t/external-collection-query-parameter-not-working/3322/8 "2020-08-16T16:06:45Z")

</div>

I completely agree with you @ishantanusrivastava. I hope Adalo will take this issue to get fixed ASAP. I am badly waiting for this as my 3 apps ideas are blocked. 😒

---

<div class="post-metadata">

**Author:** ![karimoo](https://avatars.discourse-cdn.com/v4/letter/k/ad7895/32.png) [@karimoo](https://forum.adalo.com/u/karimoo)\
**Post date:** [August 16, 2020, 4:10pm UTC](https://forum.adalo.com/t/external-collection-query-parameter-not-working/3322/9 "2020-08-16T16:10:09Z")

</div>

@iamharims Just wanted to point what _workarounds_ are available _today_. You may want to support [GraphQL support for external collections | Voters | Adalo](https://ideas.adalo.com/feature-requests/p/graphql-support-for-external-collections) which is basically the request for dynamic endpoints.

---

<div class="post-metadata">

**Author:** ![iamharims](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/iamharims/32/1874_2.png) [@iamharims](https://forum.adalo.com/u/iamharims)\
**Post date:** [August 16, 2020, 4:16pm UTC](https://forum.adalo.com/t/external-collection-query-parameter-not-working/3322/10 "2020-08-16T16:16:39Z")

</div>

ok added a thumbs up.  
I think we should push Adalo definitely to take this issue to get it fixed as heigh priority. It will be a big win for both Adalo and customers ( like me 🙂) to finish and bring our Apps to market ASAP.

---

<div class="post-metadata">

**Author:** ![ishantanusrivastava](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/ishantanusrivastava/32/34947_2.png) [@ishantanusrivastava](https://forum.adalo.com/u/ishantanusrivastava)\
**Post date:** [August 17, 2020, 11:59am UTC](https://forum.adalo.com/t/external-collection-query-parameter-not-working/3322/11 "2020-08-17T11:59:58Z")

</div>

@Ben I think you have to look into this

---

<div class="post-metadata">

**Author:** ![iamharims](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/iamharims/32/1874_2.png) [@iamharims](https://forum.adalo.com/u/iamharims)\
**Post date:** [August 17, 2020, 12:15pm UTC](https://forum.adalo.com/t/external-collection-query-parameter-not-working/3322/12 "2020-08-17T12:15:17Z")

</div>

@ishantanusrivastava - Thanks for following up on this issue. I have been trying external collection feature for different types of APIs. everywhere I see some or the other blockers.

Also, If we are able to link API response to screens/pages it would be good to map selected key values to a parameter on screen. [It should be something like what we have in Custom actions. Something like getting the response and select which data we want and link to them to screen. In this way, we can effectively use API data to display on screens.]

I am happy to available for a call to discuss more use cases.

---

<div class="post-metadata">

**Author:** ![anon78309838](https://avatars.discourse-cdn.com/v4/letter/a/b9bd4f/32.png) [@anon78309838](https://forum.adalo.com/u/anon78309838)\
**Post date:** [August 18, 2020, 12:17pm UTC](https://forum.adalo.com/t/external-collection-query-parameter-not-working/3322/13 "2020-08-18T12:17:45Z")

</div>

> Also, If we are able to link API response to screens/pages it would be good to map selected key values to a parameter on screen. [It should be something like what we have in Custom actions. Something like getting the response and select which data we want and link to them to screen. In this way, we can effectively use API data to display on screens.]

What you describe here is exactly how custom actions work as mentioned above by @karimoo. [Custom Action Outputs are Live!](https://forum.adalo.com/t/custom-action-outputs-are-live/2858)

You are able to setup actions for the responses from API’s in a collection and make use of them where required.

---

<div class="post-metadata">

**Author:** ![iamharims](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/iamharims/32/1874_2.png) [@iamharims](https://forum.adalo.com/u/iamharims)\
**Post date:** [August 18, 2020, 12:58pm UTC](https://forum.adalo.com/t/external-collection-query-parameter-not-working/3322/14 "2020-08-18T12:58:16Z")

</div>

@anon78309838 - Thanks for the reply. I think still what I am expecting is not clear.

The way I am looking to use the API response is, I should be able to display the API data dynamically ( For different query fields ) on app screens when the user visits the page. Think about a public app ( Example, Weather App ) which does not require users to log in. In that case, if I use custom actions and create collections for each user who uses the app to see the weather info of their city, will be a right way to achieve what I am looking for. Please suggest if I am missing anything.

@ishantanusrivastava - Could you please add your points as we discussed.

---

<div class="post-metadata">

**Author:** ![anon78309838](https://avatars.discourse-cdn.com/v4/letter/a/b9bd4f/32.png) [@anon78309838](https://forum.adalo.com/u/anon78309838)\
**Post date:** [August 19, 2020, 11:31am UTC](https://forum.adalo.com/t/external-collection-query-parameter-not-working/3322/15 "2020-08-19T11:31:58Z")

</div>

Looking at the documentation I cannot see the possibility of an “All” for the /country endpoint.

> **[Coronavirus COVID19 API](https://documenter.getpostman.com/view/10808728/SzS8rjbc?version=latest#4b88f773-be9b-484f-b521-bb58dda0315c)**
>
> The Postman Documenter generates and maintains beautiful, live documentation for your collections. Never worry about maintaining API documentation again.

I setup a test for the /countries endpoint which has an “All” array and the test was successful.

 ![image](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/2X/c/c6707edc3507a9047cda58a475ce2a63f1d2419a.png)

I think perhaps your query for this API is not correct or you need to go one step back from that dayone endpoint and then filter down.

---

<div class="post-metadata">

**Author:** ![iamharims](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/iamharims/32/1874_2.png) [@iamharims](https://forum.adalo.com/u/iamharims)\
**Post date:** [August 19, 2020, 11:38am UTC](https://forum.adalo.com/t/external-collection-query-parameter-not-working/3322/16 "2020-08-19T11:38:19Z")

</div>

@anon78309838 - Thanks for your reply. I will have a look and try what you have suggest.

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/system/32/40401_2.png) [@system](https://forum.adalo.com/u/system)\
**Post date:** [August 29, 2020, 11:38am UTC](https://forum.adalo.com/t/external-collection-query-parameter-not-working/3322/17 "2020-08-29T11:38:19Z")

</div>

Closed on August 29, 2020, 11:38am UTC

This topic was automatically closed 10 days after the last reply. New replies are no longer allowed.
