Sharepoint 2016 BCS from SQL Server

-

Comments

Post a Comment

Popular posts from this blog

Anniversary Web part SharePoint JavaScript

-
Image
Create a Refinable Property like Refinabledate according to the requirement. Go to site settings > Search schema. In the managed properties, search for refinabledate00(if this is already mapped select an empty one) and map it to the SPS-Anniversary crawled property(by default sharepoint crawls the AD user profile properties with a prefix of SPS-). Run a full crawl for the refinabledate to get all the info generated. To test if refinable property has values run a search query https:// yoursitecollurlhere /_api/search/query?querytext=%27*%27&sourceid=%27B09A7990-05EA-4AF9-81EF-EDFAB16C4E31%27&selectproperties=%27Title,Refinabledate01,Path%27&sortlist=%27Refinabledate01:ascending%27&rowlimit=500 Once you get a set of results as below, you can paste the url into the below code Once you get results for the query, iterate through results with condition according to which dates you want to show the birthdays for. For this you need to get the current date which is in...
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...
Read more