Creating Metadata for the Adapter for SharePoint
Create Synonym for the Adapter for SharePoint creates the metadata used for sending SharePoint API requests and displaying the data returned.
Create Metadata for the Adapter for SharePoint
- Procedure
- From the WebFOCUS Reporting Server browser interface Applications page, click Get Data.
- Right-click the configured connection for the Adapter for SharePoint (for example, CON01) and click Show DBMS Objects on the context menu.
The Site(s) for SharePoint Synonym(s) page opens, as shown in the following image.
You can click the arrow to the right of any site in the Drill Down column to open a table of lists for that site, as shown in the following image.
If a site does not display a table of lists, an intermediate tab opens displaying a message. This message warns that no sites were found and prompts you to enter the Site ID. To obtain access to the lists linked to your selected site, you must enter a unique Site ID. This ID should be known in advance and should be submitted to the SharePoint Server, as shown in the following image.
- From the Mode radio group, select Lists or Entities.
- Lists Mode Instructions. If you selected Lists Mode, perform the following steps.
- To create a synonym for a particular SharePoint List, click the Drill Down arrow next to the site.
The List(s) for SharePoint Synonym(s) page opens, as shown in the following image.
- Select the SharePoint List for which metadata is to be created and click Next.
The Create Synonym for SharePoint page opens, as shown in the following image.
- Enter a specific application in the Application field, or click the ellipsis button to the right of the field to select an application in which to store the metadata.
- Select the Validate checkbox if you wish to convert all special characters to underscores and perform a name check to prevent the use of reserved names. (This is accomplished by adding numbers to the names.) This parameter ensures that names adhere to specifications. For more information, see Validation for Special Characters and Reserved Words. When the Validate option is unchecked, only the following characters are converted to underscores: '-'; ' '; ' \'; '/';','; '$'. No checking is performed for names.
- Select the Make unique checkbox if you want to set the scope for field and group names to the entire synonym. This ensures that no duplicate names are used, even in different segments of the synonym. When this option is unchecked, the scope is the segment.
- Click Customize data type mappings to select whether to decompose date formats, assign geographic roles automatically, set the date order, and select the data type mappings for numeric decimal and alphanumeric columns.
- To assign a different synonym name, replace the displayed value.
- Click Add.
The synonym is created in the specified application. The suffix is SHAREPT.
For example, the following synonym was generated for customer_list.
FILENAME=M6ILO, SUFFIX=SHAREPT , $ SEGMENT=FIELDS, SEGTYPE=S0, $ FIELDNAME=FIELDS, ALIAS=fields, USAGE=A1, ACTUAL=A1, ACCESS_PROPERTY=(INTERNAL), PROPERTY=ELEMENT, $ FIELDNAME=SITESID, ALIAS=sitesid, USAGE=A150, ACTUAL=A150, XDEFAULT='xxx.sharepoint.com,f71636ec93,552cf9bb -bad8-4e33-89f5-262f692b852c', REFERENCE=FIELDS, $ FIELDNAME=LISTSID, ALIAS=listsid, USAGE=A150, ACTUAL=A150, XDEFAULT='el555555-b30f-4072-abc8-29bc305bc736', REFERENCE=FIELDS, $ FIELDNAME=ITEMSID, ALIAS=itemsid, USAGE=A150, ACTUAL=A150, XDEFAULT='1', REFERENCE=FIELDS, $FIELDNAME=TITLE, ALIAS=Title, USAGE=A55, ACTUAL=A55, MISSING=ON, REFERENCE=FIELDS, PROPERTY=ELEMENT, $ FIELDNAME=COLUMN2, ALIAS=Column2, USAGE=A55, ACTUAL=A55, MISSING=ON, REFERENCE=FIELDS, PROPERTY=ELEMENT, $ FIELDNAME=COLUMN3, ALIAS=Column3, USAGE=A55, ACTUAL=A55, MISSING=ON, REFERENCE=FIELDS, PROPERTY=ELEMENT, $ FIELDNAME=COLUMN4, ALIAS=Column4, USAGE=A55, ACTUAL=A55, MISSING=ON, REFERENCE=FIELDS, PROPERTY=ELEMENT, $ FIELDNAME=COLUMN5, ALIAS=Column5, USAGE=A55, ACTUAL=A55, MISSING=ON, REFERENCE=FIELDS, PROPERTY=ELEMENT, $ FIELDNAME=COLUMN6, ALIAS=Column6, USAGE=A55, ACTUAL=A55, MISSING=ON, REFERENCE=FIELDS, PROPERTY=ELEMENT, $ FIELDNAME=COLUMN7, ALIAS=Column7, USAGE=A55, ACTUAL=A55, MISSING=ON, REFERENCE=FIELDS, PROPERTY=ELEMENT, $ FIELDNAME=COLUMN8, ALIAS=Column8, USAGE=A55, ACTUAL=A55, MISSING=ON, REFERENCE=FIELDS, PROPERTY=ELEMENT, $ FIELDNAME=COLUMN9, ALIAS=Column9, USAGE=A55, ACTUAL=A55, MISSING=ON, REFERENCE=FIELDS, PROPERTY=ELEMENT, $ FIELDNAME=LINKTITLENOMENU, ALIAS=LinkTitleNoMenu, USAGE=A55, ACTUAL=A55, MISSING=ON, REFERENCE=FIELDS, PROPERTY=ELEMENT, $ FIELDNAME=LINKTITLE, ALIAS=LinkTitle, USAGE=A55, ACTUAL=A55, MISSING=ON, REFERENCE=FIELDS, PROPERTY=ELEMENT, $FIELDNAME=ID, ALIAS=id, USAGE=P32, ACTUAL=A32, MISSING=ON, REFERENCE=FIELDS, PROPERTY=ELEMENT, $ FIELDNAME=CONTENTTYPE, ALIAS=ContentType, USAGE=A55, ACTUAL=A55, MISSING=ON, REFERENCE=FIELDS, PROPERTY=ELEMENT, $ FIELDNAME=MODIFIED, ALIAS=Modified, USAGE=A55, ACTUAL=A55, MISSING=ON, REFERENCE=FIELDS, PROPERTY=ELEMENT, $ FIELDNAME=CREATED, ALIAS=Created, USAGE=A55, ACTUAL=A55, MISSING=ON, REFERENCE=FIELDS, PROPERTY=ELEMENT, $ FIELDNAME=AUTHORLOOKUPID, ALIAS=AuthorLookupId, USAGE=P32, ACTUAL=A32, MISSING=ON, REFERENCE=FIELDS, PROPERTY=ELEMENT, $ FIELDNAME=EDITORLOOKUPID, ALIAS=EditorLookupId, USAGE=P32, ACTUAL=A32, MISSING=ON, REFERENCE=FIELDS, PROPERTY=ELEMENT, $ FIELDNAME=_UIVERSIONSTRING, ALIAS=_UIVersionString, USAGE=P20.3, ACTUAL=A20, MISSING=ON, REFERENCE=FIELDS, PROPERTY=ELEMENT, $ FIELDNAME=ATTACHMENTS, ALIAS=Attachments, USAGE=A55, ACTUAL=A55, MISSING=ON, REFERENCE=FIELDS, PROPERTY=ELEMENT, $ FIELDNAME=EDIT, ALIAS=Edit, USAGE=A55, ACTUAL=A55, MISSING=ON, REFERENCE=FIELDS, PROPERTY=ELEMENT, $ FIELDNAME=ITEMCHILDCOUNT, ALIAS=ItemChildCount, USAGE=P32, ACTUAL=A32, MISSING=ON, REFERENCE=FIELDS, PROPERTY=ELEMENT, $FIELDNAME=FOLDERCHILDCOUNT, ALIAS=FolderChildCount, USAGE=P32, ACTUAL=A32, MISSING=ON, REFERENCE=FIELDS, PROPERTY=ELEMENT, $ FIELDNAME=_COMPLIANCEFLAGS, ALIAS=_ComplianceFlags, USAGE=A55, ACTUAL=A55, MISSING=ON, REFERENCE=FIELDS, PROPERTY=ELEMENT, $ FIELDNAME=_COMPLIANCETAG, ALIAS=_ComplianceTag, USAGE=A55, ACTUAL=A55, MISSING=ON, REFERENCE=FIELDS, PROPERTY=ELEMENT, $ FIELDNAME=_COMPLIANCETAGWRITTENTIME, ALIAS=_ComplianceTagWrittenTime, USAGE=A55, ACTUAL=A55, MISSING=ON, REFERENCE=FIELDS, PROPERTY=ELEMENT, $ FIELDNAME=_COMPLIANCETAGUSERID, ALIAS=_ComplianceTagUserId, USAGE=A55, ACTUAL=A55, MISSING=ON, REFERENCE=FIELDS
- To create a synonym for a particular SharePoint List, click the Drill Down arrow next to the site.
- Entities Mode Instructions. If you selected Entities mode to create a synonym for a particular SharePoint Entity, the Candidate(s) for SharePoint Synonym(s) page opens, as shown in the following image.
- Select an Entity.
For example, to create metadata in order to display all Sites, select sites.
- If the metadata is to be created for the selected Entity, click Next.
If there are additional related Entities required in the metadata for the selected Entity, click the Drill Down arrow next to the selected Entity.
For example, to create metadata to display available SharePoint Lists for a particular Site, click the Drill Down arrow next to Sites.
The Candidate(s) for SharePoint Synonym(s) page opens, as shown in the following image.
- Select the required Entity, for example, lists.
If no additional Drill Downs to related Entities are required, click Next.
The Create Synonym for SharePoint page opens, as shown in the following image.
- Enter a specific application in the Application field, or click the ellipsis button to the right of the field to select an application in which to store the metadata.
- Select the Validate checkbox if you wish to convert all special characters to underscores and perform a name check to prevent the use of reserved names. (This is accomplished by adding numbers to the names.) This parameter ensures that names adhere to specifications. For more information, see Validation for Special Characters and Reserved Words. When the Validate option is unchecked, only the following characters are converted to underscores: '-'; ' '; ' \'; '/';','; '$'. No checking is performed for names.
- Select the Make unique checkbox if you want to set the scope for field and group names to the entire synonym. This ensures that no duplicate names are used, even in different segments of the synonym. When this option is unchecked, the scope is the segment.
- Click Customize data type mappings to select whether to decompose date formats, assign geographic roles automatically, set the date order, and select the data type mappings for numeric decimal and alphanumeric columns.
- To assign a different synonym name, replace the displayed value.
- Click Add.
The synonym is created in the specified application. The suffix is SHAREPT.
Example 1: Generated Synonym for the Sites Entity
The following synonym was generated for the Sites entity.
FILENAME=M6ILO, SUFFIX=SHAREPT , $ SEGMENT=SITES, SEGTYPE=S0, $ FIELDNAME=SITES, ALIAS=value, USAGE=A1, ACTUAL=A1, ACCESS_PROPERTY=(INTERNAL), $ FIELDNAME=ID, ALIAS=id, USAGE=A150, ACTUAL=A150, MISSING=ON, REFERENCE=SITES, $FIELDNAME=CREATEDDATETIME, ALIAS=createdDateTime, USAGE=HYYMDm, ACTUAL=A35, MISSING=ON, REFERENCE=SITES, $ FIELDNAME=DESCRIPTION, ALIAS=description, USAGE=A30, ACTUAL=A30, MISSING=ON, REFERENCE=SITES, $ FIELDNAME=ETAG, ALIAS=eTag, USAGE=A30, ACTUAL=A30, MISSING=ON, REFERENCE=SITES, $ FIELDNAME=LASTMODIFIEDDATETIME, ALIAS=lastModifiedDateTime, USAGE=HYYMDm, ACTUAL=A35, MISSING=ON, REFERENCE=SITES, $FIELDNAME=NAME, ALIAS=name, USAGE=A30, ACTUAL=A30, MISSING=ON, REFERENCE=SITES, $ FIELDNAME=WEBURL, ALIAS=webUrl, USAGE=A30, ACTUAL=A30, MISSING=ON, REFERENCE=SITES, $ FIELDNAME=DISPLAYNAME, ALIAS=displayName, USAGE=A30, ACTUAL=A30, MISSING=ON, REFERENCE=SITES, $ SEGMENT=CREATEDBY, SEGTYPE=U, PARENT=SITES, $ FIELDNAME=CREATEDBY, ALIAS=createdBy, USAGE=A1, ACTUAL=A1, ACCESS_PROPERTY=(INTERNAL), REFERENCE=SITES, $SEGMENT=APPLICATION, SEGTYPE=U, PARENT=CREATEDBY, $ FIELDNAME=APPLICATION, ALIAS=application, USAGE=A1, ACTUAL=A1, ACCESS_PROPERTY=(INTERNAL), REFERENCE=CREATEDBY, $ FIELDNAME=DISPLAYNAME1, ALIAS=displayName, USAGE=A30, ACTUAL=A30, MISSING=ON, REFERENCE=APPLICATION, $ FIELDNAME=ID1, ALIAS=id, USAGE=A30, ACTUAL=A30, MISSING=ON, REFERENCE=APPLICATION, $SEGMENT=DEVICE, SEGTYPE=U, PARENT=CREATEDBY, $ FIELDNAME=DEVICE, ALIAS=device, USAGE=A1, ACTUAL=A1, ACCESS_PROPERTY=(INTERNAL), REFERENCE=CREATEDBY, $ FIELDNAME=DISPLAYNAME2, ALIAS=displayName, USAGE=A30, ACTUAL=A30, MISSING=ON, REFERENCE=DEVICE, $ FIELDNAME=ID2, ALIAS=id, USAGE=A30, ACTUAL=A30, MISSING=ON, REFERENCE=DEVICE, $SEGMENT=USER, SEGTYPE=U, PARENT=CREATEDBY, $ FIELDNAME=USER1, ALIAS=user, USAGE=A1, ACTUAL=A1, ACCESS_PROPERTY=(INTERNAL), REFERENCE=CREATEDBY, $ FIELDNAME=DISPLAYNAME3, ALIAS=displayName, USAGE=A30, ACTUAL=A30, MISSING=ON, REFERENCE=USER1, $ FIELDNAME=ID3, ALIAS=id, USAGE=A30, ACTUAL=A30, MISSING=ON, REFERENCE=USER1, $SEGMENT=LASTMODIFIEDBY, SEGTYPE=U, PARENT=SITES, $ FIELDNAME=LASTMODIFIEDBY, ALIAS=lastModifiedBy, USAGE=A1, ACTUAL=A1, ACCESS_PROPERTY=(INTERNAL), REFERENCE=SITES, $ SEGMENT=APPLICATION1, SEGTYPE=U, PARENT=LASTMODIFIEDBY, $ FIELDNAME=APPLICATION1, ALIAS=application, USAGE=A1, ACTUAL=A1, ACCESS_PROPERTY=(INTERNAL), REFERENCE=LASTMODIFIEDBY, $ FIELDNAME=DISPLAYNAME4, ALIAS=displayName, USAGE=A30, ACTUAL=A30, MISSING=ON, REFERENCE=APPLICATION1, $ FIELDNAME=ID4, ALIAS=id, USAGE=A30, ACTUAL=A30, MISSING=ON, REFERENCE=APPLICATION1, $SEGMENT=DEVICE1, SEGTYPE=U, PARENT=LASTMODIFIEDBY, $ FIELDNAME=DEVICE1, ALIAS=device, USAGE=A1, ACTUAL=A1, ACCESS_PROPERTY=(INTERNAL), REFERENCE=LASTMODIFIEDBY, $ FIELDNAME=DISPLAYNAME5, ALIAS=displayName, USAGE=A30, ACTUAL=A30, MISSING=ON, REFERENCE=DEVICE1, $ FIELDNAME=ID5, ALIAS=id, USAGE=A30, ACTUAL=A30, MISSING=ON, REFERENCE=DEVICE1, $SEGMENT=USER1, SEGTYPE=U, PARENT=LASTMODIFIEDBY, $ FIELDNAME=USER2, ALIAS=user, USAGE=A1, ACTUAL=A1, ACCESS_PROPERTY=(INTERNAL), REFERENCE=LASTMODIFIEDBY, $ FIELDNAME=DISPLAYNAME6, ALIAS=displayName, USAGE=A30, ACTUAL=A30, MISSING=ON, REFERENCE=USER2, $ FIELDNAME=ID6, ALIAS=id, USAGE=A30, ACTUAL=A30, MISSING=ON, REFERENCE=USER2, $SEGMENT=PARENTREFERENCE, SEGTYPE=U, PARENT=SITES, $ FIELDNAME=PARENTREFERENCE, ALIAS=parentReference, USAGE=A1, ACTUAL=A1, ACCESS_PROPERTY=(INTERNAL), REFERENCE=SITES, $ FIELDNAME=DRIVEID, ALIAS=driveId, USAGE=A30, ACTUAL=A30, MISSING=ON, REFERENCE=PARENTREFERENCE, $ FIELDNAME=DRIVETYPE, ALIAS=driveType, USAGE=A30, ACTUAL=A30, MISSING=ON, REFERENCE=PARENTREFERENCE, $ FIELDNAME=ID7, ALIAS=id, USAGE=A30, ACTUAL=A30, MISSING=ON, REFERENCE=PARENTREFERENCE, $ FIELDNAME=NAME1, ALIAS=name, USAGE=A30, ACTUAL=A30, MISSING=ON, REFERENCE=PARENTREFERENCE, $ FIELDNAME=PATH, ALIAS=path, USAGE=A30, ACTUAL=A30, MISSING=ON, REFERENCE=PARENTREFERENCE, $ FIELDNAME=SHAREID, ALIAS=shareId, USAGE=A30, ACTUAL=A30, MISSING=ON, REFERENCE=PARENTREFERENCE, $ FIELDNAME=SITEID, ALIAS=siteId, USAGE=A30, ACTUAL=A30, MISSING=ON, REFERENCE=PARENTREFERENCE, $SEGMENT=SHAREPOINTIDS, SEGTYPE=U, PARENT=PARENTREFERENCE, $ FIELDNAME=SHAREPOINTIDS, ALIAS=sharepointIds, USAGE=A1, ACTUAL=A1, ACCESS_PROPERTY=(INTERNAL), REFERENCE=PARENTREFERENCE, $ FIELDNAME=LISTID, ALIAS=listId, USAGE=A30, ACTUAL=A30, MISSING=ON, REFERENCE=SHAREPOINTIDS, $ FIELDNAME=LISTITEMID, ALIAS=listItemId, USAGE=A30, ACTUAL=A30, MISSING=ON, REFERENCE=SHAREPOINTIDS, $ FIELDNAME=LISTITEMUNIQUEID, ALIAS=listItemUniqueId, USAGE=A30, ACTUAL=A30, MISSING=ON, REFERENCE=SHAREPOINTIDS, $ FIELDNAME=SITEID1, ALIAS=siteId, USAGE=A30, ACTUAL=A30, MISSING=ON, REFERENCE=SHAREPOINTIDS, $FIELDNAME=SITEURL, ALIAS=siteUrl, USAGE=A30, ACTUAL=A30, MISSING=ON, REFERENCE=SHAREPOINTIDS, $ FIELDNAME=TENANTID, ALIAS=tenantId, USAGE=A30, ACTUAL=A30, MISSING=ON, REFERENCE=SHAREPOINTIDS, $ FIELDNAME=WEBID, ALIAS=webId, USAGE=A30, ACTUAL=A30, MISSING=ON, REFERENCE=SHAREPOINTIDS, $ SEGMENT=ERROR, SEGTYPE=U, PARENT=SITES, $ FIELDNAME=ERROR, ALIAS=error, USAGE=A1, ACTUAL=A1, ACCESS_PROPERTY=(INTERNAL), REFERENCE=SITES, $ FIELDNAME=CODE, ALIAS=code, USAGE=A30, ACTUAL=A30, MISSING=ON, REFERENCE=ERROR, $ FIELDNAME=MESSAGE, ALIAS=message, USAGE=A30, ACTUAL=A30, MISSING=ON, REFERENCE=ERROR, $ FIELDNAME=TARGET, ALIAS=target, USAGE=A30, ACTUAL=A30, MISSING=ON, REFERENCE=ERROR, $SEGMENT=DETAILS, SEGTYPE=S0, PARENT=ERROR, $ FIELDNAME=DETAILS, ALIAS=details, USAGE=A1, ACTUAL=A1, ACCESS_PROPERTY=(INTERNAL), REFERENCE=ERROR, $ FIELDNAME=CODE1, ALIAS=code, USAGE=A30, ACTUAL=A30, MISSING=ON, REFERENCE=DETAILS, $ FIELDNAME=MESSAGE1, ALIAS=message, USAGE=A30, ACTUAL=A30, MISSING=ON, REFERENCE=DETAILS, $ FIELDNAME=TARGET1, ALIAS=target, USAGE=A30, ACTUAL=A30, MISSING=ON, REFERENCE=DETAILS, $SEGMENT=INNERERROR, SEGTYPE=U, PARENT=ERROR, $ FIELDNAME=INNERERROR, ALIAS=innerError, USAGE=A1, ACTUAL=A1, ACCESS_PROPERTY=(INTERNAL), REFERENCE=ERROR, $ FIELDNAME=CODE2, ALIAS=code, USAGE=A30, ACTUAL=A30, MISSING=ON, REFERENCE=INNERERROR, $ FIELDNAME=MESSAGE2, ALIAS=message, USAGE=A30, ACTUAL=A30, MISSING=ON, REFERENCE=INNERERROR, $ FIELDNAME=TARGET2, ALIAS=target, USAGE=A30, ACTUAL=A30, MISSING=ON, REFERENCE=INNERERROR, $SEGMENT=ROOT, SEGTYPE=U, PARENT=SITES, $ FIELDNAME=ROOT, ALIAS=root, USAGE=A1, ACTUAL=A1, ACCESS_PROPERTY=(INTERNAL), REFERENCE=SITES, $ SEGMENT=SHAREPOINTIDS1, SEGTYPE=U, PARENT=SITES, $ FIELDNAME=SHAREPOINTIDS1, ALIAS=sharepointIds, USAGE=A1, ACTUAL=A1, ACCESS_PROPERTY=(INTERNAL), REFERENCE=SITES, $ FIELDNAME=LISTID1, ALIAS=listId, USAGE=A30, ACTUAL=A30, MISSING=ON, REFERENCE=SHAREPOINTIDS1, $ FIELDNAME=LISTITEMID1, ALIAS=listItemId, USAGE=A30, ACTUAL=A30, MISSING=ON, REFERENCE=SHAREPOINTIDS1, $ FIELDNAME=LISTITEMUNIQUEID1, ALIAS=listItemUniqueId, USAGE=A30, ACTUAL=A30, MISSING=ON, REFERENCE=SHAREPOINTIDS1, $ FIELDNAME=SITEID2, ALIAS=siteId, USAGE=A30, ACTUAL=A30, MISSING=ON, REFERENCE=SHAREPOINTIDS1, $ FIELDNAME=SITEURL1, ALIAS=siteUrl, USAGE=A30, ACTUAL=A30, MISSING=ON, REFERENCE=SHAREPOINTIDS1, $FIELDNAME=TENANTID1, ALIAS=tenantId, USAGE=A30, ACTUAL=A30, MISSING=ON, REFERENCE=SHAREPOINTIDS1, $ FIELDNAME=WEBID1, ALIAS=webId, USAGE=A30, ACTUAL=A30, MISSING=ON, REFERENCE=SHAREPOINTIDS1, $ SEGMENT=SITECOLLECTION, SEGTYPE=U, PARENT=SITES, $ FIELDNAME=SITECOLLECTION, ALIAS=siteCollection, USAGE=A1, ACTUAL=A1, ACCESS_PROPERTY=(INTERNAL), REFERENCE=SITES, $ FIELDNAME=DATALOCATIONCODE, ALIAS=dataLocationCode, USAGE=A30, ACTUAL=A30, MISSING=ON, REFERENCE=SITECOLLECTION, $ FIELDNAME=HOSTNAME, ALIAS=hostname, USAGE=A30, ACTUAL=A30, MISSING=ON, REFERENCE=SITECOLLECTION, $SEGMENT=ROOT1, SEGTYPE=U, PARENT=SITECOLLECTION, $ FIELDNAME=ROOT1, ALIAS=root, USAGE=A1, ACTUAL=A1, ACCESS_PROPERTY=(INTERNAL), REFERENCE=SITECOLLECTION, $Example 2: Generated Synonym for the Lists Entity
In order for Sample Data to use this metadata to display available SharePoint Lists for a particular Site, either XDEFAULT containing the ID for the Site must be added to the SITEID field definition, or the Site ID must be entered when prompted by the Sample Data input.
In order for a report to use this metadata to display available SharePoint Lists for a particular Site, where an XDEFAULT attribute is not defined, the ID for the Site must be sent in the report using a WHERE or IF statement. For example:
WHERE SITEID EQ 'xxx.sharepoint.com,f71636ec93,552cf9bb-bad8-4e33-89f5-262f692b852c';
FILENAME=M6ILO, SUFFIX=SHAREPT , $ SEGMENT=LISTS, SEGTYPE=S0, $ FIELDNAME=LISTS, ALIAS=value, USAGE=A1, ACTUAL=A1, ACCESS_PROPERTY=(INTERNAL), $ FIELDNAME=SITEID, ALIAS=siteid, USAGE=A150, ACTUAL=A150, REFERENCE=LISTS, XDEFAULT='xxx.sharepoint.com,f71636ec93,552cf9bb- bad8-4e33-89f5-262f692b852c', $ FIELDNAME=ID, ALIAS=id, USAGE=A150, ACTUAL=A150, MISSING=ON, REFERENCE=LISTS, $ FIELDNAME=CREATEDDATETIME, ALIAS=createdDateTime, USAGE=HYYMDm, ACTUAL=A35, MISSING=ON, REFERENCE=LISTS, $ FIELDNAME=DESCRIPTION, ALIAS=description, USAGE=A150, ACTUAL=A150, MISSING=ON, REFERENCE=LISTS, $ FIELDNAME=ETAG, ALIAS=eTag, USAGE=A30, ACTUAL=A30, MISSING=ON, REFERENCE=LISTS, $FIELDNAME=LASTMODIFIEDDATETIME, ALIAS=lastModifiedDateTime, USAGE=HYYMDm, ACTUAL=A35, MISSING=ON, REFERENCE=LISTS, $ FIELDNAME=NAME, ALIAS=name, USAGE=A30, ACTUAL=A30, MISSING=ON, REFERENCE=LISTS, $ FIELDNAME=WEBURL, ALIAS=webUrl, USAGE=A30, ACTUAL=A30, MISSING=ON, REFERENCE=LISTS, $ FIELDNAME=DISPLAYNAME, ALIAS=displayName, USAGE=A150, ACTUAL=A150, MISSING=ON, REFERENCE=LISTS, $SEGMENT=CREATEDBY, SEGTYPE=U, PARENT=LISTS, $ FIELDNAME=CREATEDBY, ALIAS=createdBy, USAGE=A1, ACTUAL=A1, ACCESS_PROPERTY=(INTERNAL), REFERENCE=LISTS, $ SEGMENT=APPLICATION, SEGTYPE=U, PARENT=CREATEDBY, $ FIELDNAME=APPLICATION, ALIAS=application, USAGE=A1, ACTUAL=A1, ACCESS_PROPERTY=(INTERNAL), REFERENCE=CREATEDBY, $ FIELDNAME=DISPLAYNAME1, ALIAS=displayName, USAGE=A30, ACTUAL=A30, MISSING=ON, REFERENCE=APPLICATION, $ FIELDNAME=ID1, ALIAS=id, USAGE=A30, ACTUAL=A30, MISSING=ON, REFERENCE=APPLICATION, $SEGMENT=DEVICE, SEGTYPE=U, PARENT=CREATEDBY, $ FIELDNAME=DEVICE, ALIAS=device, USAGE=A1, ACTUAL=A1, ACCESS_PROPERTY=(INTERNAL), REFERENCE=CREATEDBY, $ FIELDNAME=DISPLAYNAME2, ALIAS=displayName, USAGE=A30, ACTUAL=A30, MISSING=ON, REFERENCE=DEVICE, $ FIELDNAME=ID2, ALIAS=id, USAGE=A30, ACTUAL=A30, MISSING=ON, REFERENCE=DEVICE, $ SEGMENT=USER, SEGTYPE=U, PARENT=CREATEDBY, $ FIELDNAME=USER1, ALIAS=user, USAGE=A1, ACTUAL=A1, ACCESS_PROPERTY=(INTERNAL), REFERENCE=CREATEDBY, $ FIELDNAME=DISPLAYNAME3, ALIAS=displayName, USAGE=A30, ACTUAL=A30, MISSING=ON, REFERENCE=USER1, $ FIELDNAME=ID3, ALIAS=id, USAGE=A30, ACTUAL=A30, MISSING=ON, REFERENCE=USER1, $SEGMENT=LASTMODIFIEDBY, SEGTYPE=U, PARENT=LISTS, $ FIELDNAME=LASTMODIFIEDBY, ALIAS=lastModifiedBy, USAGE=A1, ACTUAL=A1, ACCESS_PROPERTY=(INTERNAL), REFERENCE=LISTS, $ SEGMENT=APPLICATION1, SEGTYPE=U, PARENT=LASTMODIFIEDBY, $ FIELDNAME=APPLICATION1, ALIAS=application, USAGE=A1, ACTUAL=A1, ACCESS_PROPERTY=(INTERNAL), REFERENCE=LASTMODIFIEDBY, $ FIELDNAME=DISPLAYNAME4, ALIAS=displayName, USAGE=A30, ACTUAL=A30, MISSING=ON, REFERENCE=APPLICATION1, $ FIELDNAME=ID4, ALIAS=id, USAGE=A30, ACTUAL=A30, MISSING=ON, REFERENCE=APPLICATION1, $SEGMENT=DEVICE1, SEGTYPE=U, PARENT=LASTMODIFIEDBY, $ FIELDNAME=DEVICE1, ALIAS=device, USAGE=A1, ACTUAL=A1, ACCESS_PROPERTY=(INTERNAL), REFERENCE=LASTMODIFIEDBY, $ FIELDNAME=DISPLAYNAME5, ALIAS=displayName, USAGE=A30, ACTUAL=A30, MISSING=ON, REFERENCE=DEVICE1, $ FIELDNAME=ID5, ALIAS=id, USAGE=A30, ACTUAL=A30, MISSING=ON, REFERENCE=DEVICE1, $ SEGMENT=USER1, SEGTYPE=U, PARENT=LASTMODIFIEDBY, $ FIELDNAME=USER2, ALIAS=user, USAGE=A1, ACTUAL=A1, ACCESS_PROPERTY=(INTERNAL), REFERENCE=LASTMODIFIEDBY, $ FIELDNAME=DISPLAYNAME6, ALIAS=displayName, USAGE=A30, ACTUAL=A30, MISSING=ON, REFERENCE=USER2, $ FIELDNAME=ID6, ALIAS=id, USAGE=A30, ACTUAL=A30, MISSING=ON, REFERENCE=USER2, $SEGMENT=PARENTREFERENCE, SEGTYPE=U, PARENT=LISTS, $ FIELDNAME=PARENTREFERENCE, ALIAS=parentReference, USAGE=A1, ACTUAL=A1, ACCESS_PROPERTY=(INTERNAL), REFERENCE=LISTS, $ FIELDNAME=DRIVEID, ALIAS=driveId, USAGE=A30, ACTUAL=A30, MISSING=ON, REFERENCE=PARENTREFERENCE, $ FIELDNAME=DRIVETYPE, ALIAS=driveType, USAGE=A30, ACTUAL=A30, MISSING=ON, REFERENCE=PARENTREFERENCE, $ FIELDNAME=ID7, ALIAS=id, USAGE=A30, ACTUAL=A30, MISSING=ON, REFERENCE=PARENTREFERENCE, $ FIELDNAME=NAME1, ALIAS=name, USAGE=A150, ACTUAL=A150, MISSING=ON, REFERENCE=PARENTREFERENCE, $ FIELDNAME=PATH, ALIAS=path, USAGE=A30, ACTUAL=A30, MISSING=ON, REFERENCE=PARENTREFERENCE, $ FIELDNAME=SHAREID, ALIAS=shareId, USAGE=A30, ACTUAL=A30, MISSING=ON, REFERENCE=PARENTREFERENCE, $ FIELDNAME=SITEID1, ALIAS=siteId, USAGE=A150, ACTUAL=A150, MISSING=ON, REFERENCE=PARENTREFERENCE, $SEGMENT=SHAREPOINTIDS, SEGTYPE=U, PARENT=PARENTREFERENCE, $ FIELDNAME=SHAREPOINTIDS, ALIAS=sharepointIds, USAGE=A1, ACTUAL=A1, ACCESS_PROPERTY=(INTERNAL), REFERENCE=PARENTREFERENCE, $ FIELDNAME=LISTID, ALIAS=listId, USAGE=A30, ACTUAL=A30, MISSING=ON, REFERENCE=SHAREPOINTIDS, $ FIELDNAME=LISTITEMID, ALIAS=listItemId, USAGE=A30, ACTUAL=A30, MISSING=ON, REFERENCE=SHAREPOINTIDS, $ FIELDNAME=LISTITEMUNIQUEID, ALIAS=listItemUniqueId, USAGE=A30, ACTUAL=A30, MISSING=ON, REFERENCE=SHAREPOINTIDS, $ FIELDNAME=SITEID2, ALIAS=siteId, USAGE=A30, ACTUAL=A30, MISSING=ON, REFERENCE=SHAREPOINTIDS, $ FIELDNAME=SITEURL, ALIAS=siteUrl, USAGE=A30, ACTUAL=A30, MISSING=ON, REFERENCE=SHAREPOINTIDS, $ FIELDNAME=TENANTID, ALIAS=tenantId, USAGE=A30, ACTUAL=A30, MISSING=ON, REFERENCE=SHAREPOINTIDS, $ FIELDNAME=WEBID, ALIAS=webId, USAGE=A30, ACTUAL=A30, MISSING=ON, REFERENCE=SHAREPOINTIDS, $SEGMENT=LIST, SEGTYPE=U, PARENT=LISTS, $ FIELDNAME=LIST, ALIAS=list, USAGE=A1, ACTUAL=A1, ACCESS_PROPERTY=(INTERNAL), REFERENCE=LISTS, $ FIELDNAME=CONTENTTYPESENABLED, ALIAS=contentTypesEnabled, USAGE=A5, ACTUAL=A5, MISSING=ON, REFERENCE=LIST, $ FIELDNAME=HIDDEN, ALIAS=hidden, USAGE=A5, ACTUAL=A5, MISSING=ON, REFERENCE=LIST, $ FIELDNAME=TEMPLATE, ALIAS=template, USAGE=A30, ACTUAL=A30, MISSING=ON, REFERENCE=LIST, $SEGMENT=SHAREPOINTIDS1, SEGTYPE=U, PARENT=LISTS, $ FIELDNAME=SHAREPOINTIDS1, ALIAS=sharepointIds, USAGE=A1, ACTUAL=A1, ACCESS_PROPERTY=(INTERNAL), REFERENCE=LISTS, $ FIELDNAME=LISTID1, ALIAS=listId, USAGE=A30, ACTUAL=A30, MISSING=ON, REFERENCE=SHAREPOINTIDS1, $ FIELDNAME=LISTITEMID1, ALIAS=listItemId, USAGE=A30, ACTUAL=A30, MISSING=ON, REFERENCE=SHAREPOINTIDS1, $ FIELDNAME=LISTITEMUNIQUEID1, ALIAS=listItemUniqueId, USAGE=A30, ACTUAL=A30, MISSING=ON, REFERENCE=SHAREPOINTIDS1, $ FIELDNAME=SITEID3, ALIAS=siteId, USAGE=A30, ACTUAL=A30, MISSING=ON, REFERENCE=SHAREPOINTIDS1, $ FIELDNAME=SITEURL1, ALIAS=siteUrl, USAGE=A30, ACTUAL=A30, MISSING=ON, REFERENCE=SHAREPOINTIDS1, $ FIELDNAME=TENANTID1, ALIAS=tenantId, USAGE=A30, ACTUAL=A30, MISSING=ON, REFERENCE=SHAREPOINTIDS1, $ FIELDNAME=WEBID1, ALIAS=webId, USAGE=A30, ACTUAL=A30, MISSING=ON, REFERENCE=SHAREPOINTIDS1, $SEGMENT=SYSTEM, SEGTYPE=U, PARENT=LISTS, $ FIELDNAME=SYSTEM, ALIAS=system, USAGE=A1, ACTUAL=A1, ACCESS_PROPERTY=(INTERNAL), REFERENCE=LISTS, $
- Select an Entity.