SharePointOnineConnector - Custom columns

For custom columns you'll have to write the metadata manually using the HTTPCaller with authentication set to an MS Graph web connection (that you'll have to configure first).

You'll then want to use the PATCH method on a URL that looks like this:

https://graph.microsoft.com/v1.0/sites/<siteid>/lists/<listid>/items/<listitemid>/fields

The message body should contain a JSON document describing the values you want to set, see: https://docs.microsoft.com/en-us/graph/api/listitem-update?view=graph-rest-1.0&tabs=http

I believe that the SharepointOnlineConnector will let you retrieve these IDs from the output port after uploading the file.

This is for updating "regular" column values, if have managed metadata columns, then that's a fair bit more complex.

For custom columns you'll have to write the metadata manually using the HTTPCaller with authentication set to an MS Graph web connection (that you'll have to configure first).

You'll then want to use the PATCH method on a URL that looks like this:

https://graph.microsoft.com/v1.0/sites/<siteid>/lists/<listid>/items/<listitemid>/fields

The message body should contain a JSON document describing the values you want to set, see: https://docs.microsoft.com/en-us/graph/api/listitem-update?view=graph-rest-1.0&tabs=http

I believe that the SharepointOnlineConnector will let you retrieve these IDs from the output port after uploading the file.

This is for updating "regular" column values, if have managed metadata columns, then that's a fair bit more complex.

Hello @david_r​ ,

I'm trying to follow your hint. Creating a new web connection (Microsoft OneDrive - Graph) with my credentials and building the url with list_id and item_id out from the SharePointOnlineConnector transformer, I always receive the error 'HTTP/1.1 404 Not Found'. Navigating the url that is shown close to the error, I see a response with "code":"InvalidAuthenticationToken" and "message":"Access token is empty".

Any further suggestion?

TIA

Roberto

Hello @david_r​ ,

I'm trying to follow your hint. Creating a new web connection (Microsoft OneDrive - Graph) with my credentials and building the url with list_id and item_id out from the SharePointOnlineConnector transformer, I always receive the error 'HTTP/1.1 404 Not Found'. Navigating the url that is shown close to the error, I see a response with "code":"InvalidAuthenticationToken" and "message":"Access token is empty".

Any further suggestion?

TIA

Roberto