That's great. I didn't realize you could write to S3 with the ZipFile Write snap. As a bonus, is it possible to make the file name today's date? I tried:
's3:///my-data-warehouse-backup@s3.us-west-1.amazonaws.com/' +Date.now().toString().replaceAll(":","_")+'.gz'
but that didn't work, got 'Unsupported protocol or URL syntax error '
Puh! Apologies, that I have not described everything I had tried before posting.
Among others, I had tried parseFloat as well.
I wonder if you have tried it yourself, jolly good. Pipeline is attached
parseFloat($amount.toFixed(2)) will remove the decimal ‘.00’, so this brings nothing.
As a result you would get: 1000 → “1000.00” → 1000
Again I need to add decimals to 1000 to get 1000.00, NOT to “1000.00”
{
"amount" : 1000.00
}
anyone?
thank you.
toDouble_2022_01_12.slp (5.9 KB)
Actually, It will not. I agree with @viktor_n on this one. This is a validation from the pipeline you attached:
Don’t rely on the preview within the snap, check the actual output after validation.
Regards,
Bojan
Arrgh! Indeed, Bojan, you are right. I always forget, that one should not relay on just a half-reliable platform. Also, if runtime presents the result same as validation.
Terribly sorry for that. I suppose, it comes from the habit of using other mature integration tools. I promise to remember that in the future. I must admit, it presents a certain kind of a thrill “Oh goodie! which feature is reliable in this release, my-oh-my!” - very exciting.
Thank you and kind regards.
Output:
[{"amount":1000.00}]
Updated pipeline attached.
toDouble_2022_01_12.slp (8.6 KB)
Can SnapLogic connect using Windows Authentication to SQL Server Select snap? | SnapLogic - Integration Nation - 22194
