SFTP File Data Transformation

[Saviynt_Savvy]

Hi all,

I am using an SFTP connector to download the . CSV file to 'Data Files' in "File Directory".
Later I am using a . SAV file to import all the .csv data to Saviynt by running the SchemaAccountJob.
I have a column in .csv file with a phone number in the format: +91-984-9xx-3xxx and that value I need to modify as "9849xxxxxx" while importing. So that I'll import the phone number in the required format.

But the issue is, the .csv file contains the ACCOUNTDATA, NOT the USERDATA. So, I can't use any PRE-PROCESSOR/MODIFYUSERDATA JSON in the .sav file for the Data transformation.

Can someone suggest, how this can be achieved.

Thanks & Regards,
Saviynt Savvy

[DixshantValecha]

Hi @Saviynt_Savvy,

We are checking on your request and we will keep you posted.

[DixshantValecha]

Hi @Saviynt_Savvy,

I have provided you with a set of instructions via message. Please proceed with executing those steps and share a snapshot of the logs once completed. Should you require further assistance during the process, do not hesitate to reach out.