Search Unity

Other SQL Data Explorer - Viewing fields from EVENT_JSON

Discussion in 'Unity Analytics' started by LuftetarMan, May 10, 2022.

  1. LuftetarMan

    LuftetarMan

    Joined:
    Sep 25, 2015
    Posts:
    12
    Hello

    Is that possible to view parameters from my customEvent(Data in EVENT_JSON) in SQL Data Explorer. I think "JSON_VALUE(jsonInfo,'$.info.address[0].town') AS Town" doesnt work there.
     
    LuftetarMan, May 10, 2022
    #1

  2. LuftetarMan

    LuftetarMan

    Joined:
    Sep 25, 2015
    Posts:
    12
    this worked
    json_extract_path_text(EVENT_JSON, 'Name')
     
    LuftetarMan, May 10, 2022
    #2

  3. unity_Ctri

    unity_Ctri

    Unity Technologies

    Joined:
    Oct 20, 2020
    Posts:
    81
    Hey LuftetarMan,

    The easiest way to refer to a custom parameter in the event_json is with the notation 
    EVENT_JSON:parameterName
    - note the parameter name is case sensitive.

    The autocomplete feature in the SQL Data Explorer adds this for you:

    clicking on the auto-complete or pressing the tab key turns the suggestion into text like this:
    upload_2022-5-10_15-48-39.png


    upload_2022-5-10_15-49-20.png

    Hope this helps!
     
    unity_Ctri, May 10, 2022
    #3
    LuftetarMan likes this.