Skip to main content
  • EN

Hi,

 

I am attempting to ingest Microsoft Project Online data into our on-prem MMSQL Warehouse. I have found that the only (?) way to get the api is via SharePoint: https://<xyz>.sharepoint.com/sites/ProjectWebAppTestSite/_api/ProjectData

 

The URL Above lists endpoints for all the sub-components ie: https://<xyz>.sharepoint.com/sites/ProjectWebAppTestSite/_api/ProjectData/aen-US]/Projects

 

I am after recommendations for "simple" one-to-one replication of this data structure in SQL via FME.

 

The SharpointOnline component allows access to the document as an HTML file which I would have to manually parse and furthermore the site (via FME) only lists 5 Items in a document library wheras the main api endpoint via the web browser lists > 20 endpoints for data objects.

The OData connector doesnt seem to work as I believe the feeds are ATOM.

The HTML connector fails to authenticate as we use MFA and even if it did, this would most likely be a nightmare to parse.

The PowerBI client "just works" from a desktop connection so this shouldnt be complicated.

 

Any expertise in this area welcomed.

 

Cheers

 

Hi Chris,

Don't know if you already solved this, but I'm facing the same problem with the OData connector. I also want to ingest the Project-data into our datawarehouse. Trying to find a solution in the community I ran into your post…

Before I started searching here I found out that adding /?$format=json to the URL returns the results in JSON. Unfortunately I'm still not able to retrieve the data with FME, but if you somehow succeeded can you share your solution?

Thanks,

Michiel

Reply


Community Stats

30,162
Posts
114,484
Replies
37,809
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.