Does anyone have any experience with pulling files...
# suitescripta
Ava
08/14/2020, 3:21 PMDoes anyone have any experience with pulling files via sftp based on the lastModified value? I'm looking run a scheduled script every day that pulls the files from that day.
Ava
08/14/2020, 3:21 PMWhat I'm currently doing is pulling today's date and formatting is as "yyyy-mm-dd" and parsing the last modified date to match it. The lastmodified is formatted as "2020-08-12T170828.000Z" so I'm doing a regEx - .replace(/T.*?Z/, '')
The problem is that NS is automatically formatting the lastModified as a date so it's changing the format to "Wed Aug 12 2020 100828 GMT-0700 (PDT)".
Ava
08/14/2020, 3:22 PMI've tried using N/format, .format to format it as text but it's still pulling up as a date.
Any advice on how to fix this? Or a more direct way to go about this?
e
erictgrubaugh
08/14/2020, 3:22 PMWhat does your search look like?
a
Ava
08/14/2020, 3:23 PMIt pulls the directory list from connection.list. Here's the array that it pulls.
[{"directory":true,"name":".","size":0,"lastModified":"2020-08-12T17:08:28.000Z"},{"directory":true,"name":"..","size":0,"lastModified":"2020-08-04T18:48:03.000Z"},{"directory":false,"name":"2","size":235,"lastModified":"2020-08-12T17:08:28.000Z"},{"directory":false,"name":"2437_25945212","size":159,"lastModified":"2020-08-04T15:31:25.000Z"},{"directory":false,"name":"3","size":158,"lastModified":"2020-08-12T17:08:28.000Z"}]e
erictgrubaugh
08/14/2020, 3:24 PMOh I see
erictgrubaugh
08/14/2020, 3:24 PMPersonally I'd use
moment.jserictgrubaugh
08/14/2020, 3:25 PMI'd run a
filterlastModifiedmomenterictgrubaugh
08/14/2020, 3:27 PM Copy code
let filesUpdatedToday = theFileData.filter(
file => moment().isSame(moment(file.lastModified), "day")
)a
Ava
08/14/2020, 3:28 PMNice, definitely neater! I'm new to NS here, how would I add the Moment library to the SuiteScript library?
e
erictgrubaugh
08/14/2020, 3:29 PMYou can add third-party libs simply by uploading them to a common place in the file cabinet
erictgrubaugh
08/14/2020, 3:29 PMI generally prefer
/SuiteScripts/lib/erictgrubaugh
08/14/2020, 3:29 PMor a
lib/erictgrubaugh
08/14/2020, 3:30 PMYou can just upload the minified version of it and then include it like any other custom module, provided the library is AMD-compatible.
erictgrubaugh
08/14/2020, 3:30 PM(which moment is)
a
Ava
08/14/2020, 3:35 PMYup, I have a library folder which I'll upload it into. Thank you so much!
30 Views