NAC - Workflow to create .csv file from SharePoint list item

Hi Jochen,

Did you use a call web request action in your o365 solution to create the CSV?  You might be able to replicate it using the same action in Nintex Workflow.

Alternatively, you could create an Excel file using the document generation action: https://help.nintex.com/en-US/nwc/Content/Designer/Actions/GenerateDocument-RepeatDataMSExcel.htm

NB this would create an Excel file rather than a CSV.

If you wanted to store the file in the file system, then you can share the directory with OneDrive/Google Drive/Dropbox etc and use one of those actions to store the file.

Hi ​@Chris_Ben 

yes. with Nintex On-Prem I created the csv file with a WebRequest Action

But how to do this in NAC?

I can use a Web Service Call with “http put”.

But how to deal with the authentication in NAC WebService call?

Yes, I wouldn’t pass credentials like those in the headers so in that case, for more advanced authentication (and a better workflow designer experience), I’d recommend creating an xtension.  Here’s a sample on that has instructions on how to work with SPO which you could modify.

https://gallery.nintex.com/t/sharepoint-online-additional-web-actions

Documentation on Xtensions is here: https://help.nintex.com/en-US/xtensions/

Cheers

Hello ​@Chris_Ben 

sounds a little bit complicated just for creating a csv file

have to think about…

KR Jochen

Yes there’s a bit more involved when creating this Xtension because of the setup you have to do with the Azure app registrations etc.  My first preference would be to create an Excel file using the document generation action if an Excel instead of CSV format is acceptable and if you have sufficient doc gen quota.