Simple Event-based PQL question

[bjoern__koth]

Hi guys,

I am finally diving a little deeper into writing PQL audiences and have a beginner question.

Let's say I want to create an audience that includes anyone who has seen at least one web page view.

{
  "name": "People with page views",
  "profileInstanceId": "ups",
  "description": "People who have seen the website i.e., have created at least one page view event",
  "type": "SegmentDefinition",
  "expression": {
    "type": "PQL",
    "format": "pql/text",
    "value": "exists(event => event.web.webPageDetails.pageViews.value = 1.0)"
  },
  "schema": {
    "name": "XDM ExperienceEvent"
  },
  "labels": [
    "core/C1"
  ]
}

This body gives me an error

* code: "NEBULA-000000-400",
* message: "There is a problem with the input value. Please check your request and try again." 

Any idea what's wrong? Also tried a "==" in the condition with the same result.

[Harveer_SinghGi1]

Hey @bjoern__koth ,

I think the issue is with schema name, can you try "_xdm.context.experienceevent" for this field?

Cheers!

[bjoern__koth]

@Harveer_SinghGi1 

hmm also not really.

{
  "name": "People with page views",
  "profileInstanceId": "ups",
  "description": "People who have seen the website i.e., have created at least one page view event",
  "type": "SegmentDefinition",
  "expression": {
    "type": "PQL",
    "format": "pql/text",
    "value": "exists(event => event.web.webPageDetails.pageViews.value = 1.0)"
  },
  "schema": {
    "name": "_xdm.context.experienceevent"
  },
  "labels": [
    "core/C1"
  ]
}

{
    "type": "https://ns.adobe.com/aep/errors/NEBULA-000000-400",
    "title": "Bad Request",
    "status": 400,
    "instance": "/audiences",
    "request-id": "yhM6CWHP67fCMTcbVTSkzcNjvyqmOSwu",
    "errors": {
        "400": [
            {
                "code": "NEBULA-000000-400",
                "message": "There is a problem with the input value. Please check your request and try again."
            }
        ]
    }
}

[Harveer_SinghGi1]

Hey @bjoern__koth ,

In that case it is most probably related to the expression.value field. Can you try one of these,

"value": "count(web.webpagedetails.pageViews) >= 1" OR

"value": "sum(web.webpagedetails.pageViews.value) >= 1" or

"value": "count(web.webpagedetails.pageViews.value) >= 1"

Cheers!

[bjoern__koth]

Hi @Harveer_SinghGi1 

Nope, all nebula errors xD

By any chance, can you check if any works on your end?

[sreeCharan73]

Hello @bjoern__koth 
this should be the value for PQL/text this is for experienceEvent

"value" : "CHAIN(xEvent, timestamp, [C0: WHAT(web.webPageDetails.pageViews.value = 1.0)])"

for PQL/json

"format": "pql/json",

"value": "{\"nodeType\":\"chain\",\"array\":{\"nodeType\":\"fieldLookup\",\"fieldName\":\"xEvent\",\"object\":{\"nodeType\":\"parameterReference\",\"position\":1}},\"timestampField\":{\"nodeType\":\"lambda\",\"varNames\":[\"v0\"],\"body\":{\"nodeType\":\"fieldLookup\",\"fieldName\":\"timestamp\",\"object\":{\"nodeType\":\"varRef\",\"varName\":\"v0\"}}},\"elements\":[{\"nodeType\":\"element\",\"name\":\"C0\",\"negated\":false,\"what\":{\"nodeType\":\"lambda\",\"varNames\":[\"v0\"],\"body\":{\"nodeType\":\"fnApply\",\"fnName\":\"=\",\"params\":[{\"nodeType\":\"fieldLookup\",\"fieldName\":\"value\",\"object\":{\"nodeType\":\"fieldLookup\",\"fieldName\":\"pageViews\",\"object\":{\"nodeType\":\"fieldLookup\",\"fieldName\":\"webPageDetails\",\"object\":{\"nodeType\":\"fieldLookup\",\"fieldName\":\"web\",\"object\":{\"nodeType\":\"varRef\",\"varName\":\"v0\"}}}}},{\"nodeType\":\"literal\",\"literalType\":\"Double\",\"value\":1.0}]}}}]}"

the conversion from PQL/text to PQL/Json can be done using  API
https://developer.adobe.com/experience-platform-apis/references/segmentation/#operation/convertSegme...


Hope this works

[IamCGK]

Hey @bjoern__koth 

I suggest using this below PQL expression

"value": "exists event from xEvent where (event.web.webPageDetails.pageViews.value = 1.0)"

I tried this and got 200. Although for some unknown reason, I can neither see the audience in UI nor fetch that audience details using get endpoint. I hope it works for you!

Thanks,
Ganesh Kumar C

[Sukrity_Wadhwa]

Hi @bjoern__koth,

Were you able to resolve this query with the help of the provided solutions, or was this something you were able to figure out on your own? Please let us know. If any of the answers were helpful in moving you closer to a resolution, even partially, we encourage you to mark the one that helped the most as the 'Correct Reply.'

Thank you!