Not able to query the api response using operators using rest apis

Technical Questions
1

I am using my builder data api to consume certain content and I want to apply filtering logics using operators available in querying cheatsheet.

 "results": [
        {
            "lastUpdatedBy": "duRJ2x51AtW3EhyvdP2mUctQDz02",
            "folders": [],
            "data": {
                "productDesc": "Samsung Galaxy M14 5G Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Fusce id velit ut tortor pretium viverra suspendisse. Tincidunt vitae semper quis lectus nulla at volutpat diam. Mi proin sed libero enim sed faucibus turpis in.",
                "image": "https://cdn.builder.io/api/v1/image/assets%2F7953d2f708184128b6bfffe7ceb85eea%2Fcfcab1814365478b89534da3712e3050",
                "price": 12490,
                "ratings": 5,
                "brand": {
                    "@type": "@builder.io/core:Reference",
                    "model": "brands",
                    "id": "9450715f01654f6880ff1a40d0cfeb39",
                    "value": {
                        "lastUpdatedBy": "duRJ2x51AtW3EhyvdP2mUctQDz02",
                        "folders": [],
                        "data": {
                            "brandName": "Samsung"
                        },
                        "modelId": "be1cad381005484e81e3d7dbb85cf0fc",
                        "query": [],
                        "published": "published",
                        "firstPublished": 1709719006799,
                        "testRatio": 1,
                        "lastUpdated": 1709719006806,
                        "createdDate": 1709718998204,
                        "createdBy": "duRJ2x51AtW3EhyvdP2mUctQDz02",
                        "meta": {
                            "kind": "data",
                            "lastPreviewUrl": ""
                        },
                        "variations": {},
                        "name": "Samsung",
                        "id": "9450715f01654f6880ff1a40d0cfeb39",
                        "rev": "wipqv2z9xuc"
                    }
                },
                "productName": "Samsung Galaxy M14 5G"
            },
            "modelId": "bb74cd4163b740218a374ca59fa9cd28",
            "query": [],
            "published": "published",
            "firstPublished": 1706858958271,
            "testRatio": 1,
            "lastUpdated": 1709719248752,
            "createdDate": 1706858586968,
            "createdBy": "duRJ2x51AtW3EhyvdP2mUctQDz02",
            "meta": {
                "lastPreviewUrl": "",
                "kind": "data"
            },
            "variations": {},
            "name": "SamsungM14",
            "id": "2ff357f3ab6648868a576c0fcae97a04",
            "rev": "fqekjfony"
        }]

I am trying to fetch the content whose brand.id matches with the list that we are providing using $in

this is the api that I am using
https://cdn.builder.io/api/v3/content/product-data?apiKey=7953d2f708184128b6bfffe7ceb85eea&includeRefs=true&query.data.brand.id.$in=78e4e79dcbd54d75a5bb1317a6bf0044

but I am getting empty array in results, I can confirm that the brand.id that I am using is correct.

2

Hello @rythm,

You can try the below which seems to be working for us

https://cdn.builder.io/api/v3/content/product-data?apiKey=7953d2f708184128b6bfffe7ceb85eea&includeRefs=true&query.data.brand.id.$in=[‘78e4e79dcbd54d75a5bb1317a6bf0044’]

https://cdn.builder.io/api/v3/content/product-data?apiKey=7953d2f708184128b6bfffe7ceb85eea&includeRefs=true&query.data.brand.id.$in=['78e4e79dcbd54d75a5bb1317a6bf0044']&limit=10

Hope this helps!

3

Thank you so much, you have been a great help, I was facing issues understanding docs for rest apis