Action: Send an HTTP request to SharePoint Endpoint: _api/web/fields/addfield Body: { 'parameters': { '__metadata': { 'type': 'SP.FieldCreationInformation' }, 'FieldTypeKind': 7, 'Title': 'MemberAssociation', 'LookupListId': '3a47bba0-4536-4bed-92b8-3472473f351e', 'LookupFieldName': 'Title' } } Esta acción […]
Action: Send an HTTP request to SharePoint Endpoint: _api/web/fields/adddependentlookupfield(displayname='FIELD NAME', primarylookupfieldid='LOOKUP FIELD ID', showfield='FIELD NAME') Headers: { "Accept": "application/json;odata=verbose", "Content-Type": "application/json;odata=verbose" }
Action: Send an HTTP request to SharePoint Endpoint: _api/web/fields('FIELD_ID') Headers: { "Content-Type": "application/json;odata=verbose", "IF-MATCH": "*", "X-Http-Method": "PATCH" } Body: { '__metadata': { 'type': 'SP.FieldLookup' }, 'Group': 'YOUR GROUP NAME' }
Desde Excel, creamos una nueva Query vacía y insertamos la llamada a la API de SharePoint en la fórmula: = (querytext as text, fields as text, tenanturl as text) as […]
Este fragmento de código nos permite hacer una llamada a un Web Service REST mediante la librería RestSharp. var client = new RestClient("REST_SERVICE_URL"); client.Authenticator = new HttpBasicAuthenticator("USER", "PASSWORD"); var request […]