Sign in Register
Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Ras 66 posts 330 karma points
    Dec 21, 2023 @ 15:04
    Ras
    0

    Content delivery API - how to filter on nested properties?

    Hi, I'm using the latest Umbraco v13.0.2 and starting to try out the Content delivery api. Can do simple filtering like:

    /umbraco/delivery/api/v1/content?filter=contentType:event&filter=startDate>:2023-01-01

    But how about if I want to access something deeper in the content? say my event doctype returns this structure:

    "contentType": "event",
    "properties": {
        "someProperty": 123,
        "anotherProperty: {
                "id": 456
            }
    }

    How would I make a filtering query to filter on the someProperty, or the id in anotherProperty? Does this require extending the api?

    Copy Link
  • pbl_dk 150 posts 551 karma points
    Jan 07, 2024 @ 17:32
    pbl_dk
    0

    I have tried 10 different queries like:

     filter=property[postalCode]:8000
 filter=property.postalCode:8000
 filter=postalCode:8000
 filter=properties[postalCode]:8000

    nothing works, seems its not implemented, can't find anything about it in docs either.

    I am going to try to make my own filter method as docs says here: https://docs.umbraco.com/umbraco-cms/reference/content-delivery-api/extension-api-for-querying#custom-filter

    Copy Link
  • Bjarne Fyrstenborg 1286 posts 4060 karma points MVP 8x c-trib
    Jan 08, 2024 @ 07:54
    Bjarne Fyrstenborg
    0

    Did you try v2 of delivery API as the documentation mention? I am not sure it was available in v1?

    I haven't tested it myself though.

    Copy Link
  • Ras 66 posts 330 karma points
    Jan 08, 2024 @ 14:23
    Ras
    0

    Yes, it doesn't work unfortunately. As the indexer indexes based on the guid in the content picker, but the multinode picker returns a comma separated string with all the guids based on the nodes picked, I had to create a method that extracts each guid into its own object and indexes them each by themselves.

    Copy Link
  • pbl_dk 150 posts 551 karma points
    Jan 08, 2024 @ 14:07
    pbl_dk
    0

    Hi Bjarne

    I am not sure I am doing it right, but all of these returns an error:

    &filter=properties[klubID]:K88000
&filter=klubID:K88000
&filter=klubID
&filter=properties.klubID:K8800
&filter=properties[klubID]:K8800

    /api/v2/content?fetch=children:e5502e78-4b12-42d7-b58f-5220c91027b8&filter=properties[klubID]:K8800

    {"type":"Error","title":"Filter option not found","status":400,"detail":"One of the attempted \u0027filter\u0027 options does not exist"}

    Copy Link
  • Busra Sengul 9 posts 112 karma points MVP 4x c-trib
    Jan 26, 2024 @ 14:24
    Busra Sengul
    0

    You need to add a custom filter for your property.

    https://docs.umbraco.com/umbraco-cms/reference/content-delivery-api/extension-api-for-querying#custom-filter

    In terms of getting the pickers' information, I recently did this, and injected IContentService to get the content itself and used the properties to add to the index. then you can retrieve it by

    umbraco/delivery/api/v1/content?filter=customFilter:something

    Hope this make sense :)

    Copy Link

  • This forum is in read-only mode while we transition to the new forum.

    You can continue this topic on the new forum by tapping the "Continue discussion" link below.

Please Sign in or register to post replies