ConcourseSuite Support

Support
Corporate
PUBLIC PROFILE

Fetch a list of lookup items

Using Centric Tools

// Establish connectivity information
CRMConnection crm = new CRMConnection();
crm.setUrl("http://www.example.com/crm");
crm.setId("www.example.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.example.com</id>
    <systemId>4</systemId>
    <code>+++ CLIENT'S PASSWORD +++</code>
    <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>

Sign in to add your comment.