Forum Discussion

sriiyengar's avatar
sriiyengar
New Contributor II
8 years ago
Solved

Oracle Thin Client Setup Issue

I have been trying to set up Oracle thin Client account on snaplogic without much success. I used the options on the Oracle Account Setup documentation page and used the default JDBC driver class. Pl...
  • bojanvelevski's avatar
    bojanvelevski
    4 years ago

    Hey @matthias.voppichler,

    You can use Pipeline Execute. Add the CSV in a child pipeline, and pass the filename as a parameter, that way you can read the parameter and map it on every line that will come out of the CSV Parser using a Mapper. Files will be read one at a time, parsed, and the filename will be added to the lines accordingly.

    You can even combine Marjan’s solution with pipeline execute and again you’ll have the same desired result.

    Regards,
    Bojan

j_angelevski's avatar
j_angelevski
Contributor III
4 years ago
Copy LinkReport

Hi @aditya.gupta41,

Try with the following expression:

{}.extend(...$.entries().map(val => {[val[0]]: val[1].map(v => {}.extend(...v.entries().map(date => date[0].contains("_DATE") && date[1] == null ? {[date[0]]: "0000-00-00"} : {[date[0]]: date[1]} )))}))

This is assuming you have one or multiple arrays in the root object, assuming the arrays have one or multiple objects. This will iterate over each array find the “_DATE” key/value pair, and if a “_DATE” happens to be null, it will change the original value with the “0000-00-00”, and put back everything into the original format.

  • alchemiz's avatar
    alchemiz
    Contributor III
    3 years ago
    Copy LinkReport

    Hi @FatemaShakir ,

    Good day, have you tried using Postman

    If you can make it work in Postman then try to mimic all the headers and parameters in Postman to rest get/post snaps

    Thanks,
    EmEm