ConcourseSuite Support

Support
Corporate
PUBLIC PROFILE

Back to topics

Discuss Integration Projects

Data lookup - how?

You need to be logged in to post messages

Data lookup - how?

3/18/2006 6:14 PM EST

We want to sync our web application with Centric CRM. So we want to lookup accounts/contacts within Centric
and issue an update for existing accounts/contacts, or an insert for new ones.

Q1) How do we do the lookup to see if the account exists?

Q2) How do we get the account and/or contact primary keys for any record that was found?

Q3) What are the different XML response ids, and what do the values mean?

Can someone post an example of a lookup and then an update or insert depending on whether a record was found.

Thanks

Below is code that "talks" successfully to Centric but doesn't give us the data we want or expect.

// Establish connectivity information
CRMConnection crm = new CRMConnection();
crm.setUrl("http://www.mydomain.com");
crm.setId("www.mydomain.com");
crm.setCode("xxxxxxxxxxx");
crm.setClientId(1);
crm.setSystemId(4);

// Start a new transaction
crm.setAutoCommit(false);

DataRecord contact = new DataRecord();
contact.setName("account");
contact.setAction(DataRecord.SELECT);
contact.addField("accountNumber", "X12344");
boolean okLoad = crm.load(contact);
System.out.println("load OK? " + okLoad);

boolean result = crm.commit();

System.out.println(crm.getLastResponse());

This is the data I get back (on the console)

load OK? true
<?xml version="1.0" encoding="UTF-8"?>
<aspcfs><response id="2"><status>0</status><errorText/></response></aspcfs>

1. 3/19/2006 7:02 PM EST

Here are some of the threads that discuss the XML HTTP API used to communicate externally with Centric CRM.

Some of the examples describe retrieving a list of records with specific columns and then ids retrieved can be used to update corresponding records.

Hope this helps.

https://www.centriccrm.com/ProjectManagementIssues.do?command=Details&pid=55&iid=1725&cid=61&resetList=true

https://www.centriccrm.com/ProjectManagementIssues.do?command=Details&pid=24&iid=1612&cid=38&resetList=true

https://www.centriccrm.com/ProjectManagementIssues.do?command=Details&pid=55&iid=1816&cid=61&resetList=true

2. 3/20/2006 6:36 PM EST

Thanks for the reply.

Read all those posts (already) but they don't help us much - we really need a complete example of a lookup - insert/update (ideally using java).

Can someone please post an example of a lookup (select) followed by an insert or update depending on whether the lookup succeeded or not.

Thanks.

2 results found