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

My expectation is return one value of Academic_level per academic_Record_wid

viktor_n's avatar
viktor_n
Contributor II
4 years ago

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