1.Note: change the Dbconfig file in publish file -->xmlfiles folder 2. url localhost place replace with IP address. 3. Please provide companyCode , User_Name and Password in Web.Config 4. Execute the create table query in the database. The query is shared in the text file in the folder with File Name as "Create External Table Query.txt" Bajaj ============ URL: http://localhost/ShubhamIntegration/FocusService.svc/Bajaj Shubham ============ URL: http://localhost/ShubhamIntegration/FocusService.svc/ShubhamCRM Request ------- { "CustomerCode": "Swasthik Enterprises - SKP", "ItemCode": "8.0 TRB DRY PURPLE DAZZLE", "RMANo": "2080701203809395" } Response -------- { "responseMessage": "Valid Serial Number", "responseStatus": "0" } Error Response: --------------- { "responseMessage": "Invalid Serial Number", "responseStatus": "-1" }