Skip to main content
  • EN

Dear FME Community,

 

I am facing a challenge while using the SharePointOnline Connector in FME to load a CSV file directly as an attribute. My objective is to avoid storing this CSV file on any network drive, local drive, or an M365 named account OneDrive folder. Instead, I'd like to process it immediately within the FME workflow.

 

Goal:

My end goal is to convert this attribute—which contains the entire table from the CSV file in text form—into a temporary table or a temporary CSV within FME for further transformation.

 

Version:

I am currently using FME version e2022.2.0.0 (20221103 - Build 22765 - WIN64) ].

 

Problem:

I can successfully load the CSV file as an attribute (see picture), but I am struggling to convert this attribute to a format (temporary table or temporary CSV) that I can then transform further.

SharePointOnlineConnector configuration loading CSV from SharePoint Online 

_contents loaded from sharepoint online .csv 

Questions:

How can I convert an attribute (_contents) containing a full CSV text file into a temporary table or CSV within FME?

 

Are there any transformers or specific settings that can facilitate this operation?

 

Your expert advice and guidance on this issue would be much appreciated. Thank you in advance!

 

I wish there could be a super easy and effortless way to load CSV and Excel files dynamically and directly from SharePoint Online.

 

Best regards,

Reno

You are almost there, add a FeatureReader downstream the SharePointOnlineConnector to read the file. The features will be output from the Generic outputport because the workflow is dynamic. You can expose the attributes using the AttributeExposer, import from FeatureCache.

 

If you whish to do this without having to remove the downloaded files, put a TempPathNameCreator upstream the SharePointOnlineConnector to save the file to a temp directory.

Hi @nielsgerrits ,

 

Thank you so much. I just upgraded to FME Form 2023.1, and I found they make it super easy to load any web files from SharePoint Online using "Select File from Web"!!!

Select File from WebMaybe this feature has been here for a long time...I should have noticed it.

 

I am very thankful for your solution, and it will come handy in the future when I have to convert text based data into a temporary table.

 

BTW, our profile pictures are both from Sesame Street lol 😆

 

Sincerely,

Reno

Learned something new today 🙂 cheers.

Reply


Community Stats

30,366
Posts
115,373
Replies
38,151
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.