Api in simple list

HELLO, I am having a problem with editing an external national event API in a simple list. When I create the list and enter the text to fill in it works but I have only one event which is displayed and repeated on several lines. can you tell me how I do to display in the list a different events in each row.

Provide more information about the API, include screenshots of the API results.


There is a space on one of your query parameters.

“facet= =type_prix”

Try removing this.

no unfortunately it doesn’t change a thing. I got an email from the team"Thanks for reaching out and I am sorry you are facing this issue. This is astually due to how that API formats their response. They are sending an Array of Nested Objects, as opposed to an Array of the objects themselves.

This is not something that can be handled with Adalo at this time."

Can you send us the response body json of the API call (when setting it up?)

1 Like

{
“nhits”: 3190,
“parameters”: {
“dataset”: “que-faire-a-paris-”,
“timezone”: “UTC”,
“rows”: 10,
“start”: 0,
“format”: “json”
},
“records”: [
{
“datasetid”: “que-faire-a-paris-”,
“recordid”: “f2495ad8d2e3230a983b450e9225b6bbbd47dc42”,
“fields”: {
“blind”: 0,
“pmr”: 0,
“date_end”: “2021-12-18T16:00:00+00:00”,
“deaf”: 0,
“updated_at”: “2021-09-16T11:52:54+00:00”,
“access_type”: “reservation”,
“occurrences”: “2021-12-18T15:00:00+01:00_2021-12-18T17:00:00+01:00”,
“contact_name”: “Bibliothèque Marguerite Audoux”,
“address_street”: “10 rue Portefoin”,
“id”: “110976”,
“lat_lon”: [
48.863696,
2.359965
],
“category”: “Spectacles → Projection”,
“title”: “Les samedis du documentaire”,
“cover_alt”: “Forbach swing”,
“date_start”: “2021-12-18T14:00:00+00:00”,
“transport”: “3 : Temple (308m)\n3, 11 : Arts et Métiers (316m)”,
“address_name”: “Bibliothèque Marguerite Audoux”,
“contact_phone”: “01 44 78 55 20”,
“description”: “

Dans les trois rues du quartier du Holveg, dit “le trou”, de Forbach, une ribambelle de musiciens (dont Samson Schmitt, Rovelo Merstein et Mike Reinhardt) perpétue avec détermination et panache leur héritage musical manouche auquel ils greffent des influences jazz et soul. Marie Dumora salue une communauté-orchestre qui, par le biais de la musique, s’est construit sa propre mémoire et ses propres héros, à l’instar de Dorado Schmitt (père de Samson), guitariste légendaire admiré par la nouvelle génération.

”,
“tags”: “Musique;Cinéma;Bibliothèques”,
“lead_text”: ““Forbach swing” de Marie Dumora (2019, France, 1h49)\nFestival du réel 2019, Prix du Patrimoine de l’immatériel”,
“cover_url”: “https://cdn.paris.fr/qfap/2020/09/17/74103_Rm9yYmFjaCBzd2luZy5qcGc=.jpg”,
“access_phone”: “0144785520”,
“cover_credit”: “Les Productions Balthazar”,
“address_city”: “Paris”,
“price_type”: “gratuit”,
“cover”: {
“mimetype”: “image/jpeg”,
“format”: “JPEG”,
“color_summary”: [
“rgba(82, 73, 56, 1.00)”,
“rgba(100, 93, 81, 1.00)”,
“rgba(106, 94, 78, 1.00)”
],
“filename”: “74103_Rm9yYmFjaCBzd2luZy5qcGc=.jpg”,
“width”: 768,
“id”: “d3957021b965d0c0c1b01f1d15996262”,
“height”: 320,
“thumbnail”: true
},
“url”: “Les samedis du documentaire – Que Faire à Paris ?”,
“date_description”: “Le samedi 18 décembre 2021
de 15h à 17h
”,
“address_zipcode”: “75003”
},
“geometry”: {
“type”: “Point”,
“coordinates”: [
2.359965,
48.863696
]
},
“record_timestamp”: “2021-09-30T04:00:03.418000+00:00”
},
{
“datasetid”: “que-faire-a-paris-”,
“recordid”: “d8083a55ddd3fdd629b1025c68ddf48c703b6931”,
“fields”: {
“blind”: 0,
“pmr”: 1,
“date_end”: “2021-11-20T20:00:00+00:00”,
“deaf”: 0,
“updated_at”: “2021-09-16T09:13:09+00:00”,
“access_type”: “libre”,
“occurrences”: “2021-11-20T18:00:00+01:00_2021-11-20T21:00:00+01:00”,
“contact_name”: “Médiathèque Hélène Berr”,
“address_street”: “70 rue de Picpus”,
“id”: “120170”,
“lat_lon”: [
48.842598,
2.397432
],
“category”: “Animations → Lecture / Rencontre”,
“title”: “Soirée “les Inattendus” avec l’éditeur Pierre Mainard”,
“cover_alt”: “Les innatendus”,
“date_start”: “2021-11-20T17:00:00+00:00”,
“contact_url”: “Médiathèque Hélène Berr - Ville de Paris”,
“address_name”: “Médiathèque Hélène Berr”,
“contact_phone”: “01 43 45 87 12”,
“description”: "<p class=“MsoNormal” style=“mso-margin-top-alt:auto;mso-margin-bottom-alt:auto”>Porté depuis toujours sur « la diversalité », du poétique au politique et retour, sur les phénomènes de « double conscience » et les altérités internes aux sociétés occidentales – plus particulièrement sur les musiques afro-américaines en tant qu’institution sociale alternative, Alexandre Pierrepont partage son temps entre l’Amérique du Nord et la France. Anthropologue s’attachant à faire communiquer, sur le terrain, à même la vie courante et possiblement populaire où se vivent toutes les aventures, l’univers de la recherche dite scientifique et celui de l’expérimentation socio-musicale, il navigue souvent en haute mer Il se doute de quelque chose. Alors s’emploie à devenir rêveur définitif.

<p class=“MsoNormal” style=“mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;text-align:justify”>Pour la co-errance, la voie royale des progressions logiques ou illogiques, il y a Magic Malik et sa flûte furtive. Magic Malik qui griffonne de la voix, furète et fredonne à la flûte, quand il ne dessine pas des vévés, peut-être, sur les feuilles blanches étalées à ses pieds. L’homme comme un oiseau niche dans les crevasses de quelques rythmes décalés qui se calent peu à peu – la consolidation, la structuration viennent-elles toujours par l’accumulation, par la stratification? Et par les pétales du chant.

<p class=“MsoNormal” style=“mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;text-align:justify”> 

",
“tags”: “Musique;Bibliothèques”,
“contact_mail”: “mediatheque.helene-berr@paris.fr”,
“lead_text”: “Concert-lecture-improvisation à partir du livre :“Frontières du monde habité” d’Alexandre Pierrepont paru chez Pierre Mainard dans le cadre des inattendus avec la participation de Magic Malik”,
“cover_url”: “https://cdn.paris.fr/qfap/2021/07/08/82678_QWxleGFuZGVyIFBpZXJyZXBvbnQtTWFnaWMgTWFsaWsgMS5qcGc=.jpg”,
“contact_facebook”: “Redirecting...”,
“cover_credit”: “Pierre Mainard”,
“address_city”: “Paris”,
“price_type”: “gratuit”,
“cover”: {
“mimetype”: “image/jpeg”,
“format”: “JPEG”,
“color_summary”: [
“rgba(140, 147, 138, 1.00)”,
“rgba(87, 77, 74, 1.00)”,
“rgba(78, 72, 71, 1.00)”
],
“filename”: “82678_QWxleGFuZGVyIFBpZXJyZXBvbnQtTWFnaWMgTWFsaWsgMS5qcGc=.jpg”,
“width”: 1200,
“id”: “ebe25ff27aff38b3a16d7cb22c43ddae”,
“height”: 1720,
“thumbnail”: true
},
“url”: “Soirée "les Inattendus" avec l'éditeur Pierre Mainard – Que Faire à Paris ?”,
“date_description”: “Le samedi 20 novembre 2021
de 18h à 21h
”,
“address_zipcode”: “75012”,
“transport”: “6 : Bel-Air (286m)\n6, 8 : Daumesnil (377m)”
},
“geometry”: {
“type”: “Point”,
“coordinates”: [
2.397432,
48.842598
]

Try this:

Save the collection and make the first property in the collection be the “recordid” instead by clicking and dragging it to the top of the collection’s properties.

3 Likes

Thank you I am very happy It worked perfectly !

2 Likes

@pford I have the same issue here but with the YouTube API… the first result is just duplicated for the relevant number of records. Taking video ID to the top of properties didn’t seem to work. Any ideas?

{
“kind”: “youtube#searchListResponse”,
“etag”: “gVcgJp_kUq0ShYzioQEunstKVDA”,
“nextPageToken”: “CAUQAA”,
“regionCode”: “US”,
“pageInfo”: {
“totalResults”: 39,
“resultsPerPage”: 5
},
“items”: [
{
“kind”: “youtube#searchResult”,
“etag”: “sfMr0zWTJUqT4BZ_tOzUq-DbYDw”,
“id”: {
“kind”: “youtube#video”,
“videoId”: “UFNIfNYpm1E”
},
“snippet”: {
“publishedAt”: “2020-11-29T10:42:29Z”,
“channelId”: “UCLgD7ykgN0OU1ZFtbZI9DAA”,
“title”: “Share to WhatsApp button on Adalo”,
“description”: “In this video, we look at how to share from Adalo to WhatsApp. Reference link: …”,
“thumbnails”: {
“default”: {
“url”: “https://i.ytimg.com/vi/UFNIfNYpm1E/default.jpg”,
“width”: 120,
“height”: 90
},
“medium”: {
“url”: “https://i.ytimg.com/vi/UFNIfNYpm1E/mqdefault.jpg”,
“width”: 320,
“height”: 180
},
“high”: {
“url”: “https://i.ytimg.com/vi/UFNIfNYpm1E/hqdefault.jpg”,
“width”: 480,
“height”: 360
}
},
“channelTitle”: “The Adalo Guy”,
“liveBroadcastContent”: “none”,
“publishTime”: “2020-11-29T10:42:29Z”
}
},
{
“kind”: “youtube#searchResult”,
“etag”: “GhHDu9g4CWqvWTvetf5SSBH9_lU”,
“id”: {
“kind”: “youtube#video”,
“videoId”: “IAKZlF2L3E8”
},
“snippet”: {
“publishedAt”: “2021-02-17T07:50:03Z”,
“channelId”: “UCLgD7ykgN0OU1ZFtbZI9DAA”,
“title”: “Adalo Google Maps Embed API with webview (for PWA)”,
“description”: “UPDATE: not working for Native apps currently so please stick to use for PWA. Using Google Maps Embed API with a webview as an alternative to the Adalo …”,
“thumbnails”: {
“default”: {
“url”: “https://i.ytimg.com/vi/IAKZlF2L3E8/default.jpg”,
“width”: 120,
“height”: 90
},
“medium”: {
“url”: “https://i.ytimg.com/vi/IAKZlF2L3E8/mqdefault.jpg”,
“width”: 320,
“height”: 180
},
“high”: {
“url”: “https://i.ytimg.com/vi/IAKZlF2L3E8/hqdefault.jpg”,
“width”: 480,
“height”: 360
}
},
“channelTitle”: “The Adalo Guy”,
“liveBroadcastContent”: “none”,
“publishTime”: “2021-02-17T07:50:03Z”
}
},
{
“kind”: “youtube#searchResult”,
“etag”: “EokNHjBwXrrV8kRKVLC6No53lnU”,
“id”: {
“kind”: “youtube#channel”,
“channelId”: “UCLgD7ykgN0OU1ZFtbZI9DAA”
},
“snippet”: {
“publishedAt”: “2011-10-24T13:35:52Z”,
“channelId”: “UCLgD7ykgN0OU1ZFtbZI9DAA”,
“title”: “The Adalo Guy”,
“description”: “”,
“thumbnails”: {
“default”: {
“url”: “https://yt3.ggpht.com/ytc/AKedOLSDQxAN1QJJYWb7hZFfGHCVMxnvJBMF46iYAvOUX5A=s88-c-k-c0xffffffff-no-rj-mo
},
“medium”: {
“url”: “https://yt3.ggpht.com/ytc/AKedOLSDQxAN1QJJYWb7hZFfGHCVMxnvJBMF46iYAvOUX5A=s240-c-k-c0xffffffff-no-rj-mo
},
“high”: {
“url”: “https://yt3.ggpht.com/ytc/AKedOLSDQxAN1QJJYWb7hZFfGHCVMxnvJBMF46iYAvOUX5A=s800-c-k-c0xffffffff-no-rj-mo
}
},
“channelTitle”: “The Adalo Guy”,
“liveBroadcastContent”: “none”,
“publishTime”: “2011-10-24T13:35:52Z”
}
},
{
“kind”: “youtube#searchResult”,
“etag”: “wGCDrGRyACDNww_no4gIDmL45ko”,
“id”: {
“kind”: “youtube#video”,
“videoId”: “U1T1V_6ijo4”
},
“snippet”: {
“publishedAt”: “2020-10-18T05:15:20Z”,
“channelId”: “UCLgD7ykgN0OU1ZFtbZI9DAA”,
“title”: “Using QuickChart.io on Adalo to embed custom graphs, charts, progress bars, gauges”,
“description”: “In this video, I show you how to embed a chart from QuickChart.io into your Adalo mobile app very quickly and easily. ============ Support the Channel …”,
“thumbnails”: {
“default”: {
“url”: “https://i.ytimg.com/vi/U1T1V_6ijo4/default.jpg”,
“width”: 120,
“height”: 90
},
“medium”: {
“url”: “https://i.ytimg.com/vi/U1T1V_6ijo4/mqdefault.jpg”,
“width”: 320,
“height”: 180
},
“high”: {
“url”: “https://i.ytimg.com/vi/U1T1V_6ijo4/hqdefault.jpg”,
“width”: 480,
“height”: 360
}
},
“channelTitle”: “The Adalo Guy”,
“liveBroadcastContent”: “none”,
“publishTime”: “2020-10-18T05:15:20Z”
}
},
{
“kind”: “youtube#searchResult”,
“etag”: “-JWQzetbCWt3S9wvCOeSjOb25V0”,
“id”: {
“kind”: “youtube#video”,
“videoId”: “oqIqpi8VKqw”
},
“snippet”: {
“publishedAt”: “2021-05-03T05:57:42Z”,
“channelId”: “UCLgD7ykgN0OU1ZFtbZI9DAA”,
“title”: “Adalo Dropdowns Select & Filter Town / City (Part 1/2)”,
“description”: “This gives a quick outline of how we filter and select town and city data, in a way that doesn’t leave you with a huge list of options in a dropdown. Note: For the …”,
“thumbnails”: {
“default”: {
“url”: “https://i.ytimg.com/vi/oqIqpi8VKqw/default.jpg”,
“width”: 120,
“height”: 90
},
“medium”: {
“url”: “https://i.ytimg.com/vi/oqIqpi8VKqw/mqdefault.jpg”,
“width”: 320,
“height”: 180
},
“high”: {
“url”: “https://i.ytimg.com/vi/oqIqpi8VKqw/hqdefault.jpg”,
“width”: 480,
“height”: 360
}
},
“channelTitle”: “The Adalo Guy”,
“liveBroadcastContent”: “none”,
“publishTime”: “2021-05-03T05:57:42Z”
}
}
]
}

Good catch. I think this is because in this case the id is actually a nested JSON object instead of a top-level key. Can you try using eTag instead? That seems to be a unique value.

@pfordmedia thanks for the response. Etag also doesn’t seem to be working :frowning:

Could you DM me a link to your app real quick so I can try your External Collection? I think we had some other makers using the YouTube API who had the same issue, but I’ve never been able to test it first hand. I’m pretty sure this a limitation of how Adalo currently parses JSON for nested objects.

2 Likes

I have had same issue with News API - it showed only 1 item repeatedly. I think it was caused by the fact returned JSON in “id” field had not unique value - it was always “null”. I have move “publishedat” to top of the list and looks fine now.