Limitations of inserting a Hyperlink in SharePoint (SSIS / ODBC)

[gabrielius]

PROBLEM

---

You want to insert or update a Hyperlink into a SharePoint List using the SharePoint Online Connector, but it’s not getting inserted or updated.

As of April 29th, 2024, Microsoft Graph, used by SharePoint Online Connector, does not support inserting or updating a Hyperlink. There is no solution for this, only a workaround. There is a feature request for this functionality; vote for it using these links:

• https://feedbackportal.microsoft.com/feedback/idea/fe010dc4-5f3f-ee11-a81c-6045bdbbbc93
• https://techcommunity.microsoft.com/t5/microsoft-365-developer-platform/allow-to-update-of-sharepoint-listitem-with-hyperlink-field/idi-p/3021504#M506

More information:

• How to update Sharepoint list item hyperlink column - Microsoft Q&A

WORKAROUND

---

Update a SharePoint Hyperlink by using the SharePoint REST API:

• Working with lists and list items with REST | Microsoft Learn

Depending on the technology, use these approaches:

In SSIS

Use REST API Task or Web API Destination (part of ZappySys SSIS PowerPack)

In ODBC

Use JSON Driver or XML Driver (part of ZappySys ODBC PowerPack)