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...
SL12345's avatar
SL12345
New Contributor III
2 years ago
Copy LinkReport

Looks good but question .... in my example  - one row has more fields than another row

Is it possible to "connect"/export two  lines into one file but without empty field at the and of shorter row? 

(Mercedes is shorter and CSV formatter creates last empty field) instead of this:
"Mercedes";"6658";"TypeS";"2022";""
"Audi";"5558";"TypeA8";"2022";"Diesel"

get This

"Mercedes";"6658";"TypeS";"2022";
"Audi";"5558";"TypeA8";"2022";"Diesel"

Thank you

 

  • nishant_k9's avatar
    nishant_k9
    New Contributor II
    4 years ago
    Copy LinkReport

    @Spiro_Taleski
    Thank you for the response but the doubt is about what expression should we pass to error pipeline so that it get captured. Like for ruuid we pass pipe.ruuid, for label we pass pipe.label. Similarly for error what expression is to be passed…? Please check the screen shot I have attached just now