Forum Discussion

MallikarjunNuli's avatar
MallikarjunNuli
New Contributor
8 years ago

How to read Multiple Sheets from an excel dynamically using Snaplogic

Hi , I have requirement to read a single sheet at a time and load the data in to a table from the same excel file which contains more than 40+ of sheets. Is it possible to do this through Snaplogic...
anubhav_nautiya's avatar
anubhav_nautiya
Contributor
6 years ago
Copy LinkReport

Hi Chris
I tried what you mentioned in your comment, however I dont get the expected result, its not able to distinguish between AM and PM and gives same result for both

$dt = 11/12/2019 11:15:00 PM
expected output is 2019-11-12 23:15:00

anubhav_nautiya's avatar
anubhav_nautiya
Contributor
6 years ago
Copy LinkReport

Hi Chris,
Thanks for your inputs, I was able to achieve this by using the expression below,
Date.parse($dt,‘MM/dd/yyyy h:m:s a’).toLocaleDateTimeString({“format”:“yyyy-MM-dd HH:mm:ss”})

Regards
Anubhav

  • TheDev's avatar
    TheDev
    New Contributor
    2 years ago
    Copy Link

    Thank you, I solved it before the reply and I came to say it's done. I didn't know much about APIs and now I understand that I should've gone through the documentation first to understand how I can handle the data. I solved it by adding a query parameter like in the picture.

     

    Also, thank you for suggesting the training workshop. Have a good weekend!