Salesforce

SharePoint Troubleshooting (Magic xpi 4.9)

« Go Back

Information

 
Created BySalesforce Service User
Approval Process StatusPublished
Objective
Description

SharePoint Troubleshooting (Magic xpi 4.9)

Q1

Even though the SharePoint resource was successfully validated, I receive an error in the Magic xpi Studio when trying to retrieve the Entities List. Why is this?

A1

This problem can occur if you write the wrong parameter value in the Site field. The Site field parameter’s value should be the section between the server name and the Lists\library_name, or any other non-related Site URL part.

This incorrect configuration points to a sub site only, and not to the site's full “path”.

You can define any SharePoint hierarchy, so you should note where you would like to point to in that hierarchy.

Q2

Why does the Move operation for the Libraries entity throw an error, "Invalid URI: The format of the URI could not be determined"?

A2

One of the reasons for this error could be that the SharePoint connector is using the relative path while calling the Move operation. The SharePoint Move operation works when the full path of the document is provided. The relative path is not supported by the Move operation and will result in an error. To fix this, change the relative path to the absolute path.

Q3

Why does the SharePoint Online component query fail for some Lists when they have more than 5000 records?

A3

The SharePoint Online component query can fail for some Lists or Libraries or folders when they have more than 5000 records such as documents, folders and so on. This is a known behavior of Microsoft SharePoint Online as Microsoft recommends to have the contents in an organized way such that records threshold limit should not exceed 5000.

To overcome the issue, you can try configuring the Index field and use that field as a filter criteria to keep the number of records below 5000.

When you create a filtered view, make sure the first indexed column in the Filter Expression does not exceed the List View threshold. SharePoint selects the first indexed column in a query. Other columns you specify in the view filter may or may not be indexed, but the view does not use those indexes, even if the result of the filtered view returns less than the List View threshold.

You can also move the records from a single Library to multiple Libraries and put the recorders in separate folders or sub folders.

Reference
Attachment 
Attachment