# I want to get multiple API data

**URL:** <https://forum.adalo.com/t/i-want-to-get-multiple-api-data/21399>\
**Category:** Get Help\
**Created:** [December 30, 2021, 4:47am UTC](https://forum.adalo.com/t/i-want-to-get-multiple-api-data/21399 "2021-12-30T04:47:43Z")\
**Posts on this page:** 12\
**Page:** 1

<div class="post-metadata">

**Author:** ![Jin](https://avatars.discourse-cdn.com/v4/letter/j/4af34b/32.png) [@Jin](https://forum.adalo.com/u/Jin)\
**Post date:** [December 30, 2021, 4:47am UTC](https://forum.adalo.com/t/i-want-to-get-multiple-api-data/21399/1 "2021-12-30T04:47:43Z")

</div>

Hello!  
I’m Japanese, so I’m sorry if the explanation is difficult to understand

I am getting data from the site through the API.  
However, even though there are multiple data, only one data could be acquired.

It may be difficult to understand, so I will explain it with an image.

—From here, the image is displayed in Japanese.—  
・First of all, I got the API from this site.

> **[Spla2 API](https://spla2.yuu26.com/)**
>
> スプラトゥーン2のステージ情報API

・[https://spla2.yuu26.com/{p1}/{p2}](https://spla2.yuu26.com/%7Bp1%7D/%7Bp2%7D) API use  
p1 → regular , p2 → now

 ![スクリーンショット 2021-12-30 13.32.20](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/2X/9/93b3b13b1a2fff2ad3614e61e70b80be87e641a9.png)

・The following information can be obtained by setting the API.

 ![スクリーンショット 2021-12-30 13.35.58](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/2X/a/a92d8ece0fe824b89d8763963dce6e548c1af9b8.png)  
 ![スクリーンショット 2021-12-30 13.36.09](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/2X/1/1d8c11ce94cf0b8ab333b6150bfc3d2fad7cd1dc.png)

・I would like you to pay attention to [result.maps\_ex.image]

・Show HIDE FULL RESPONSE  
{  
“result”: [  
{  
“rule”: “ナワバリバトル”,  
“rule\_ex”: {  
“key”: “turf\_war”,  
“name”: “ナワバリバトル”,  
“statink”: “nawabari”  
},  
“maps”: [  
“ホテルニューオートロ”,  
“ガンガゼ野外音楽堂”  
],  
“maps\_ex”: [  
{  
“id”: 19,  
“name”: “ホテルニューオートロ”,  
“statink”: “otoro”  
},  
{  
“id”: 2,  
“name”: “ガンガゼ野外音楽堂”,  
“statink”: “gangaze”  
}  
],  
“start”: “2021-12-30T13:00:00”,  
“start\_utc”: “2021-12-30T04:00:00+00:00”,  
“start\_t”: 1640836800,  
“end”: “2021-12-30T15:00:00”,  
“end\_utc”: “2021-12-30T06:00:00+00:00”,  
“end\_t”: 1640844000  
}  
]  
}

・Although there are two “ホテルニューオートロ” and “ガンガゼ野外音楽堂” in maps\_ex\_name, only “ホテルニューオートロ” is acquired as data.

・Is there a way to get and display both “ホテルニューオートロ” and “ガンガゼ野外音楽堂”?

I’m sorry that the explanation is poor and the text is long.

---

<div class="post-metadata">

**Author:** ![theadaloguy](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/theadaloguy/32/8023_2.png) [@theadaloguy](https://forum.adalo.com/u/theadaloguy)\
**Post date:** [December 30, 2021, 4:59am UTC](https://forum.adalo.com/t/i-want-to-get-multiple-api-data/21399/2 "2021-12-30T04:59:31Z")

</div>

I think you are setting this up as a custom action?

I think you need to set this up as an external database collection, then you can use this data in lists etc.

---

<div class="post-metadata">

**Author:** ![Jin](https://avatars.discourse-cdn.com/v4/letter/j/4af34b/32.png) [@Jin](https://forum.adalo.com/u/Jin)\
**Post date:** [December 30, 2021, 7:01am UTC](https://forum.adalo.com/t/i-want-to-get-multiple-api-data/21399/3 "2021-12-30T07:01:00Z")

</div>

thank you for your reply!  
Yes, it is set by a custom action.

Utilization of an external database is essential!  
I’ve never used external data, so could you tell me more about it?  
For example, what does an external database utilize?  
Which site should I refer to, etc.

I’m glad if you could tell me.

---

<div class="post-metadata">

**Author:** ![theadaloguy](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/theadaloguy/32/8023_2.png) [@theadaloguy](https://forum.adalo.com/u/theadaloguy)\
**Post date:** [December 30, 2021, 7:14am UTC](https://forum.adalo.com/t/i-want-to-get-multiple-api-data/21399/4 "2021-12-30T07:14:58Z")

</div>

Hi Jin,

Here are a couple of videos which work with external collections, they should be helpful.

[![](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/3X/3/f/3f08a7ed5f0c926e49ad574cafce8da35980946f.jpeg "Adalo Tutorial: How to Integrate External APIs") ](https://www.youtube.com/watch?v=a9aHpsPJVJ8)

[![](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/3X/a/f/afbc86632001442007cc1405707e16c90de829f9.jpeg "Part 1: Using the Pixabay API to Dynamically Search for Images in Adalo") ](https://www.youtube.com/watch?v=El4TGoLrpqQ)

---

<div class="post-metadata">

**Author:** ![Jin](https://avatars.discourse-cdn.com/v4/letter/j/4af34b/32.png) [@Jin](https://forum.adalo.com/u/Jin)\
**Post date:** [December 30, 2021, 9:42am UTC](https://forum.adalo.com/t/i-want-to-get-multiple-api-data/21399/5 "2021-12-30T09:42:10Z")

</div>

Hello theadaloguy

Thank you!  
I would like to refer to the video!

If so, do you have a recommended external database?

---

<div class="post-metadata">

**Author:** ![theadaloguy](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/theadaloguy/32/8023_2.png) [@theadaloguy](https://forum.adalo.com/u/theadaloguy)\
**Post date:** [December 30, 2021, 10:06am UTC](https://forum.adalo.com/t/i-want-to-get-multiple-api-data/21399/6 "2021-12-30T10:06:03Z")

</div>

Here, your spla2 API is the database. Just the way we are setting up for it is the same way we would use a separate database for the back end, rather than using a custom action .

---

<div class="post-metadata">

**Author:** ![Jin](https://avatars.discourse-cdn.com/v4/letter/j/4af34b/32.png) [@Jin](https://forum.adalo.com/u/Jin)\
**Post date:** [December 30, 2021, 10:59am UTC](https://forum.adalo.com/t/i-want-to-get-multiple-api-data/21399/7 "2021-12-30T10:59:26Z")

</div>

So that’s it!  
I made an image, but I could only get one data.  
Is it right this way?

–I will explain with an image again–

・Create a database with “External Collections”

 ![スクリーンショット 2021-12-30 19.45.17](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/2X/d/d0604ee730c9ff24d33e790cdd44ba06368cce23.png)

・detail

 ![スクリーンショット 2021-12-30 19.47.37](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/2X/4/43ad1e2e3d921d2e2294a9fbde81b806d6ab6974.png)

・Enter only “result” in Get

 ![スクリーンショット 2021-12-30 19.49.14](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/2X/7/7e2e81383612dd5b24526fe6a52e1fe2cb78a009.png)

・It became as follows

 ![スクリーンショット 2021-12-30 19.50.48](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/2X/9/94ef7401a8469c805ca634a69bda16253c358e73.png)

・Paste the database into the “image List”

・Only one result was displayed.  
 ![スクリーンショット 2021-12-30 19.59.09](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/2X/8/8d519bf62eb718cb4c979e4411a8646f7c04cebb.png)

・There are two “maps\_name”.

I’m sorry many times, but I’m new to Adalo, so I’d appreciate it if you could tell me in detail.

---

<div class="post-metadata">

**Author:** ![theadaloguy](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/theadaloguy/32/8023_2.png) [@theadaloguy](https://forum.adalo.com/u/theadaloguy)\
**Post date:** [December 30, 2021, 4:06pm UTC](https://forum.adalo.com/t/i-want-to-get-multiple-api-data/21399/8 "2021-12-30T16:06:12Z")

</div>

Try a second results key maps\_ex

However, certain APIs can’t get all the data to Adalo correctly, this might be one of them.

---

<div class="post-metadata">

**Author:** ![Jin](https://avatars.discourse-cdn.com/v4/letter/j/4af34b/32.png) [@Jin](https://forum.adalo.com/u/Jin)\
**Post date:** [December 31, 2021, 12:20am UTC](https://forum.adalo.com/t/i-want-to-get-multiple-api-data/21399/9 "2021-12-31T00:20:08Z")

</div>

thank you for your reply.

I tried with “maps\_ex”, but only one was displayed with the same result.

 ![スクリーンショット 2021-12-31 9.15.33](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/2X/f/f7397b9af3ceda3188accc6089a08c83657f700b.png)  
 ![スクリーンショット 2021-12-31 9.15.53](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/2X/1/16a1508b45c8fed5534412ed7f3f92d1aa8ec296.png)  
 ![スクリーンショット 2021-12-31 9.16.01](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/2X/d/de1bf368bb643f1308924a60dc11c544079dacf8.png)

Only the first of [海女美術大学] was displayed.

---

<div class="post-metadata">

**Author:** ![theadaloguy](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/theadaloguy/32/8023_2.png) [@theadaloguy](https://forum.adalo.com/u/theadaloguy)\
**Post date:** [December 31, 2021, 6:16am UTC](https://forum.adalo.com/t/i-want-to-get-multiple-api-data/21399/10 "2021-12-31T06:16:16Z")

</div>

It may be impossible to get more than one image from this API. Certain API formats just aren’t compatible with the way Adalo works. Another one I couldn’t get to work was the YouTube API.

---

<div class="post-metadata">

**Author:** ![Jin](https://avatars.discourse-cdn.com/v4/letter/j/4af34b/32.png) [@Jin](https://forum.adalo.com/u/Jin)\
**Post date:** [December 31, 2021, 1:16pm UTC](https://forum.adalo.com/t/i-want-to-get-multiple-api-data/21399/11 "2021-12-31T13:16:01Z")

</div>

Is that so.

thank you!  
Let’s think about another way!

---

<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:** [January 10, 2022, 1:16pm UTC](https://forum.adalo.com/t/i-want-to-get-multiple-api-data/21399/12 "2022-01-10T13:16:32Z")

</div>

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