I had to just close my browser and open in a new one and it appeared.
“Yes, when it’s passed as a parameter to Oracle Procedure Snap it changed to 2022/06/13 11:57:32 > 2022-06-13T12:03:38.000Z.” - this shouldn’t happen.
From the screen I can see that the date is mapped from input(“$p_processing_date”). It is not taken from parameter.
If you try to parse the value from parameter as date back, then you will get the “2022-06-13T12:03:38.000Z”.
So, if you procedure expect the field as date, probably you will need to handle the date conversion and format on procedure level. Otherwise, you can pass the field as string(without parsing back as date), directly from parameter: _p_processing_date
BR,
Spiro Taleski
Actually, it’s passed from parameter only, please see below and I couldn’t understand what do you mean by _p_processing_date and where I have to pass it?
Hi AvaniAnand ,
Do you mean you want to split the nested array based on credit or for debit? Or you always wanne split for debit and credit?
If you want them both I suggest using a copy and then two json splitters for splitting on Credit and Debit. You can add parent keys that you wanne keep. In the attachment is a demo pipeline that does this (first change the name to '.slp' extension and then import it into snaplogic) it does not allow me to upload those file extensions.
Let me know if this helps.
Regards
Jens
Split String by appending a new value after every 3 characters from the end | SnapLogic - Integration Nation - 8146
