What to put in the ResultsKey

Get Help External Collections, Custom Actions & Collections
1

Hi, I have an API that produces the following JSON:

{
  "data": {
    "listBars": {
      "items": [
        {
          "id": "c172a87f-d5a6-4e2d-8234-9f30002cd9cc",
          "name": "Café Papeneiland",
          "name_lc": "café papeneiland",
          "address1": "Prinsengracht 2",
          "zip_code": "1015 DV",
          "city": "Amsterdam",
          "city_lc": "amsterdam",
          "phone": "+31206241989",
          "yelp_id": "EwRM48517T3Gdf_butNCkw",
          "image_url": "https://s3-media1.fl.yelpcdn.com/bphoto/_ZScT9jO-6Hm-54ULRpZeg/o.jpg",
          "alias": "café-papeneiland-amsterdam-2"
        }
      ]
    }
  }
}

What do I use as the ResultsKey? I have tried all possible combinations: data, listBars, items, data/listBars/items. I am running out of options as it comes back as an error all the time!

Please help.

BR,

Bas

2

First, as an Amsterdammer myself, I am a huge fan of the café, having been there many times :slight_smile:

Second, let’s try and get to the bottom of this together! Can you send through the details of the API?

The results key of “items” should work here. What error are you getting returned?

3

Well the items key is nested (as in: it is not in the root, but a subitem of ‘data’ and ‘listBars’). I fixed it now by changing the API myself but this might not be possible in the future.