How to index nested JSON arrays with Azure AI Search?

@Robert Myers Thanks for reaching out to Microsoft Q&A, apologize for any inconvenience caused on this. I am checking with the team internally on this and will update you here Once I hear back from them.

Thanks, appreciate it

Just to add to this, I am finding that generally if I have JSON data which has nested data structures which are detected as ComplexTypeCollection, the data does get indexed with AI Search, but as soon as I try to use the specific index in the chat GPT playground, none of the data is readable.

Hi Robert, The search supports complex types such as nested arrays, if you search for "clothes" it should return Clive (based on your example). One limitation is around highlighting content. I believe it may be some limitation around the chat too. If you check on Azure AI Search directly you may see it's 'filtering' based on the content from the nested array.

I have the same issue, or very similar. I am new to this but I believe my json data is being indexed after a manual import. The index json view shows the fields I selected. However when I then get on to Azure Open AI and add my own data the only Content fields visible/selectable are those un-nested ones. The nested fields are not visible. As such when I chat about the data I get nothing back except when I reference data from the fields I could select. Here's my test data to demonstrate;

{
    "collectiontime": "2024-02-09T15:32:20.8745818+00:00",
    "user": "js",
    "company": "Testing Company PLC",
    "staff": [
      {
        "Location": "UK",
        "Cashiers": [
          {
            "name": "Anne",
            "age": 65
          },
          {
            "name": "Robert",
            "age": 35
          },
          {
            "name": "Jane",
            "count": 18
          }
        ]
      }
    ]
}

Here's the Index (I am new if there's some schoolboy errors!)

Here's the lack of that full Index in Open AI 'Bring Your Own Data'

Missing fields I had indexed like;

• Location
• name
• age