ConcourseSuite Community Edition

Core Team

PUBLIC PROFILE

Home
Fetch a list of lookup items

Fetch a list of lookup items

Using Centric Tools

// Establish connectivity information
CRMConnection crm = new CRMConnection();
crm.setUrl("http://www.yourorg.com/centric");
crm.setId("www.yourorg.com");
crm.setCode("password");
crm.setClientId(clientId);

//Add Meta Info with fields required
ArrayList meta = new ArrayList();
meta.add("code");
meta.add("description");
crm.setTransactionMeta(meta);

DataRecord lookupIndustryTypes = new DataRecord();
lookupIndustryTypes.setName("lookupIndustryList");
lookupIndustryTypes.setAction(DataRecord.SELECT);
lookupIndustryTypes.addField("tableName", "lookup_industry");
lookupIndustryTypes.addField("uniqueField", "code");
lookupIndustryTypes.addField("property", "code");
lookupIndustryTypes.addField("property", "description");
crm.load(lookupIndustryTypes);

XML

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<app>
  <authentication>
    <id>www.yourorg.com</id>
    <systemId>4</systemId>
    <code>+++ CLIENT'S PASSWORD +++

<clientId>+++ CLIENT ID ALREADY ESTABLISHED +++</clientId>
</authentication>
<transaction id="1">
<meta>
<property>code</property>
<property>description</property>
</meta>
<lookupIndustryList action="select">
<tableName>lookup_industry</tableName>
<uniqueField>code</uniqueField>
<property>code</property>
<property>description</property>
</lookupIndustryList>
</transaction>
</app>
</code>