Solved

Sugarcrm Rest api

Posted on 2014-09-30
1
194 Views
Last Modified: 2016-03-18
I have a MSSQL database that I want to sync with sugarcrm. I want to use the contracts module and send information from there to the MSSQL database. I believe the best way to do this is with rest api. Could someone show me how to get this setup.
0
Comment
Question by:Pat Shortt
1 Comment
 
LVL 25

Accepted Solution

by:
jogos earned 500 total points
ID: 40353928
Here is an article on how to get on from the JSON in SQL
https://www.simple-talk.com/sql/t-sql-programming/consuming-json-strings-in-sql-server/
0

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

832 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question