Forum Discussion

pmuthusamy's avatar
pmuthusamy
New Contributor
4 years ago

Validation ignores the field in JSON path if the field is null

Hello, We are using snaplogic to extract data from Workday student module to data warehouse, our pipeline is based out custom reports in Workday ( RAAS ) as REST Get. When snaplogic validates initia...
workday
pmuthusamy's avatar
pmuthusamy
New Contributor
4 years ago
Copy LinkReport

My expectation is return one value of Academic_level per academic_Record_wid

  • viktor_n's avatar
    viktor_n
    Contributor II
    4 years ago
    Copy LinkReport

    Hi @pmuthusamy,

    If all Academic_levels in Student_course_regi… are same inside the list, you can get only the first element.
    You just need to replace [*] with [0] inside the expression from above image.

    Regards,
    Viktor