Nintex Site Workflow to Manipulate SharePoint List Items from CSV file

[anilk]

Hi Nintex Team,

we have a requirement like "We need to Insert and update the SharePoint List data from CSV file (stored in a Shared Drive or SharePoint Folder as a Netwrok drive)".

In detail our requirement is 

1. We have a SharePoint List with some data

2. We get a daily feed at a particualr Interval with Delta data

3. We need a Process (No Powershell script please) or Workflow or Configuration which can read the file and make the List item Insertions . Updations (if existing record).

Is there any Nintex Site Workflow or any solution that can we can leverage for this particualr requirement ?

Your help will be greatly appreciated here.

[kunalpatel]

@anilk .....did you try exploring excel service action?

[anilk]

No Kunal,

By any chance if you have any Links or documentation on the same can you please let me know.

[kunalpatel]

@anilk ....here is the help link - https://help.nintex.com/en-us/nintex2010/help/workflow/RootCategory/Actions/Nintex.Workflow.QueryExc...

Also, when you add an action in your design and if you open the action and then help link, it will open the help info for that particular action.