Sharepoint 2016 BCS from SQL Server

-

Comments

Post a Comment

Popular posts from this blog

Birthday Javascript Sharepoint 2013

-
Below is the code to pull birthdays using REST API search Sharepoint 2013. Create a Refinable Property like RefinableString or Refinabledate according to the requirement. In my case I had to try both and had an issue with Refinabledate since the month was getting appended to the year. Lets say someone has mar 23rd as birthday in User profile property, the date was showing as 01-03-2023. Hence I had to assign it to a string. Since in our environment it was a dd-mmm(no year) format which was a custom profile property, It was showing 23rd-March in my case. Once RefinableString02 was assigned it was showing the same dd-mmm format. For getting the right url you need to have the querytext as * and source id to the people, and select the properties required which is  "Title,RefinableString02,Path". Then fire an ajax query as below with the rest url as below:https://yoursitecollurl/_api/search/query?querytext=%27Refinabledate00%3E%222-7-2000%22%27&sourceid=%27B09A7990-05E
Read more

Multivalue Dropdown Refiner Sharepoint 2013

-
Filter Multivalue dropdown.html <html xmlns:mso="urn:schemas-microsoft-com:office:office" xmlns:msdt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882"> <head> <title>Multi-value Dropdown Refinement Item</title> <!--[if gte mso 9]><xml> <mso:CustomDocumentProperties> <mso:CompatibleManagedProperties msdt:dt="string"></mso:CompatibleManagedProperties> <mso:TemplateHidden msdt:dt="string">0</mso:TemplateHidden> <mso:CompatibleSearchDataTypes msdt:dt="string"></mso:CompatibleSearchDataTypes> <mso:MasterPageDescription msdt:dt="string"></mso:MasterPageDescription> <mso:ContentTypeId msdt:dt="string">0x0101002039C03B61C64EC4A04F5361F385106604</mso:ContentTypeId> <mso:TargetControlType msdt:dt="string">;#Refinement;#</mso:TargetControlType> <mso:HtmlDesignAssociated msdt:dt="string"
Read more

Steps to Call WEB service with JSON Payload from SharePoint Workflow:

-
I have a request from client for calling JSON Ideas :  1.  Call HTTP from Sharepoint Workflow to Get and Post data from a SOAP web API. 2. Create a an event Listner to call each time item create or update methods. 3.  Add an adaptor layer on top of the SOAP service which converts the SOAP response to a JSON response which is returned via the REST interface. Steps to Call WEBservice with JSON Payload from Sharepoint Workflow: 1. Build the JSON payload in workflow. Sharepoint 2013 has new functionality of Build Dictionary which will store a dictionary value which are basically the json objects building for sending to the WSDL. 2. We need to build a WEB API with the service references to the SOAP WSDLs and instantiate the members of the SOAP service reference. We need to instantiate the ServiceManagerClient which gets created when we add a WSDL as service reference. 3. We also need a MVC project with WebAPI in Visual studio. 4. Now we need the call http action in Workflow t
Read more