Rapid API - "An error occurred when calling Get All"

Get Help External Collections, Custom Actions & Collections
1

Hi - im trying to add an external collection from Rapid API and keep getting the above error even though its showing all the correct results when i run the test??

Link to API docs - Navigating this Documentation

{
“timestamp”: 1722855418,
“datestamp”: “Mon, 05 Aug 2024 12:56:58 +0200”,
“plan”: “BASIC”,
“sun”: {
“sunrise”: 1722828540,
“sunrise_timestamp”: “05:29”,
“sunset”: 1722883320,
“sunset_timestamp”: “20:42”,
“solar_noon”: “13:05”,
“day_length”: “15:13”,
“sun_altitude”: -16.366332856217035,
“sun_distance”: 151786481.450617,
“sun_azimuth”: 328.88632966630155,
“next_solar_eclipse”: {
“timestamp”: 1727887573,
“datestamp”: “Wed, 02 Oct 2024 18:46:13 +0200”,
“type”: “Annular Solar Eclipse”,
“visibility_regions”: “Pacific, s South America ; [Annular: s Chile, s Argentina]”
}
},
“moon”: {
“phase”: 0.023520927165295802,
“phase_name”: “Waxing Crescent”,
“stage”: “waxing”,
“illumination”: “1%”,
“age_days”: 1,
“lunar_cycle”: “2.35%”,
“emoji”: “:waxing_crescent_moon:”,
“zodiac”: {
“sun_sign”: “Leo”,
“moon_sign”: “Leo”
},
“moonrise”: “04:53”,
“moonrise_timestamp”: 1722826380,
“moonset”: “21:12”,
“moonset_timestamp”: 1722885120,
“moon_altitude”: -12.132682459482547,
“moon_distance”: 397991.5042219803,
“moon_azimuth”: 323.8613606426276,
“moon_parallactic_angle”: 22.860118993803535,
“next_lunar_eclipse”: {
“timestamp”: 1726620326,
“datestamp”: “Wed, 18 Sep 2024 02:45:26 +0200”,
“type”: “Partial Lunar Eclipse”,
“visibility_regions”: “Americas, Europe, Africa”
}
},
“moon_phases”: {
“new_moon”: {
“last”: {
“timestamp”: 1722722400,
“datestamp”: “Sun, 04 Aug 2024 00:00:00 +0200”,
“days_ago”: 1
},
“next”: {
“timestamp”: 1725314400,
“datestamp”: “Tue, 03 Sep 2024 00:00:00 +0200”,
“days_ahead”: 28
}
},
“first_quarter”: {
“last”: {
“timestamp”: 1720908000,
“datestamp”: “Sun, 14 Jul 2024 00:00:00 +0200”,
“days_ago”: 22
},
“next”: {
“timestamp”: 1723413600,
“datestamp”: “Mon, 12 Aug 2024 00:00:00 +0200”,
“days_ahead”: 6
}
},
“full_moon”: {
“last”: {
“timestamp”: 1721512800,
“datestamp”: “Sun, 21 Jul 2024 00:00:00 +0200”,
“days_ago”: 15,
“name”: “Buck Moon”,
“description”: “Signifies the growth of new antlers on young deer.”
},
“next”: {
“timestamp”: 1724018400,
“datestamp”: “Mon, 19 Aug 2024 00:00:00 +0200”,
“days_ahead”: 13,
“name”: “Sturgeon Moon”,
“description”: “Marks the time when sturgeon fish are most easily caught.”
}
},
“last_quarter”: {
“last”: {
“timestamp”: 1722117600,
“datestamp”: “Sun, 28 Jul 2024 00:00:00 +0200”,
“days_ago”: 8
},
“next”: {
“timestamp”: 1724623200,
“datestamp”: “Mon, 26 Aug 2024 00:00:00 +0200”,
“days_ahead”: 20
}
}
},
“location”: {
“latitude”: 51.5,
“longitude”: 0
}
}

2

@Heggy_084, in Rapid API which API are you trying and getting issues?

3

Its called ‘Moon Phase’, cheers

4

Since I don’t have a subscription for this API couldn’t test this out. Could you share some screenshots of how you have setup the external collections? What error are you getting from Adalo?

5

AdaloCapture
AdaloCapture989×821 40.5 KB

6

the ‘x-rapidapi-key’ header contains the long API key code as the value

7

after the test what you see? I mean once you click test setup?

8

AdaloCapture
AdaloCapture963×770 50.6 KB

9

since it returns a single response and not a array try this with custom actions. : Custom Actions | Adalo Resources

1 Like
10

ok next question - is there a resource i can follow on using a custom action to update an existing collection?

11

You need to store it right after the custom action because adding a action ( Update, Create, storing it in a input for temporary, storing in another dB with a another custom action ) after the custom action will be able to access it’s results from magic text.

Check the doc last three steps (18,19,20) in, In-Depth section : Custom Actions | Adalo Resources