Extract csv file from sftp to ServiceNow

[Renu9]

Hi All,

We are having a requirement to export the csv file data using SFTP. A file from a third party will be placing a csv file in SFTP Server , we need to extract it and do some checks and load the needed parameters(fields) into the ServiceNow User table.

Could you please guide me how this can be achieved .?(exporting csv file). csv file contains 15 fields, out of these I need to pick 10 fields (ex: company name, manager name, manager id , etc) into the already existing user record in user table.

Please guide me any approaches.

Thanks in advance!!

[Ankur Bawiskar]

Hi,

Did you try to use sftp data source and fetch the file?

You can also schedule it as per your schedule.

Regards
Ankur

[Renu9]

Hi Ankur, I'm able to fetch it via data source now, once the file is fetched by servicenow I need to pass the data of each third party file field to a field in user table. How can I achieve it could you please guide

[Ankur Bawiskar]

Hi,

you are fetching the file using data source; you can define transform map, field map on that data source and then load the data into user table

I believe that's what you required right?

Regards
Ankur

[Renu9]

Hi Ankur, Yes. For the first time , it's the complete load .But from next time , it is kind of differential load, i also need to create a schedule to run daily at a specified time. So if I create a schedule how can I achieve it. If on today 20/9 I did for the complete load, from tomorrow every day a schedule needs to run based on the filter condition it should pick data which is created for that day alone. And also I need to load few fields of data for the already existing users in ServiceNow and no new users are to be loaded via that data load. This check also should be included. I am very new to this transform maps , requesting help