I want to get multiple API data

[Jin]

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/{p1}/{p2} API use
p1 → regular , p2 → now

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

・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.

[theadaloguy]

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.

[Jin]

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.

[theadaloguy]

Hi Jin,

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

Adalo Tutorial: How to Integrate External APIs

Part 1: Using the Pixabay API to Dynamically Search for Images in Adalo

[Jin]

Hello theadaloguy

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

If so, do you have a recommended external database?

[theadaloguy]

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 .

[Jin]

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”

・detail

・Enter only “result” in Get

・It became as follows

・Paste the database into the “image List”

・Only one result was displayed.

・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.

[theadaloguy]

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.

[Jin]

thank you for your reply.

I tried with “maps_ex”, but only one was displayed with the same result.

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

[theadaloguy]

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.

[Jin]

Is that so.

thank you!
Let’s think about another way!