API Module Customer searchCustomerRequest
From Openprovider API documentation
(Difference between revisions)
												
			
		|  (→Module Customer > Search) | |||
| (16 intermediate revisions not shown) | |||
| Line 13: | Line 13: | ||
| |'''Input''' | |'''Input''' | ||
| | | | | ||
| - | *limit | + | *[[API Format Limit|limit]] (''default value: 100, maximum value: 1000'') | 
| - | *offset | + | *[[API Format Offset|offset]] (''default value: 0'') | 
| *emailPattern | *emailPattern | ||
| *lastNamePattern | *lastNamePattern | ||
| *companyNamePattern | *companyNamePattern | ||
| - | *withAdditionalData | + | *withAdditionalData (''default value: 0'') | 
| + | *columns (possible values: id, companyName, firstName, lastName, fullName, prefix, initials, email, handle) | ||
| |- style="vertical-align:top;" | |- style="vertical-align:top;" | ||
| |'''Output''' | |'''Output''' | ||
| |Result set of customer details: | |Result set of customer details: | ||
| - | *handle | + | *[[API Format Handle|handle]] | 
| *companyName | *companyName | ||
| - | *vat | + | *[[API Format vat|vat]] | 
| *[[API Format Name|name]] | *[[API Format Name|name]] | ||
| - | *gender | + | *[[API Format Gender|gender]] | 
| *[[API Format Address|address]] | *[[API Format Address|address]] | ||
| *[[API Format Phone|phone]] | *[[API Format Phone|phone]] | ||
| Line 32: | Line 33: | ||
| *email | *email | ||
| *[[API Format Additional Data Customer|additionalData]] (if withAdditionalData = true) | *[[API Format Additional Data Customer|additionalData]] (if withAdditionalData = true) | ||
| + | *[[API_Format_Extensions_Additional_Data_Customer|extensionAdditionalData]] (if withAdditionalData = true) | ||
| |} | |} | ||
| Line 40: | Line 42: | ||
|    ->setAuth(array('username' => 'username', 'password' => 'password')) |    ->setAuth(array('username' => 'username', 'password' => 'password')) | ||
|    ->setArgs(array( |    ->setArgs(array( | ||
| - |      'offset' =>  | + |      'offset' => 0, | 
|      'limit'  => 25, |      'limit'  => 25, | ||
|      'emailPattern' => '*@openprovider.nl', |      'emailPattern' => '*@openprovider.nl', | ||
| Line 48: | Line 50: | ||
| ===Raw XML=== | ===Raw XML=== | ||
| - | + | ''Please note that newlines and leading spaces are added only for readability. Those whitespaces should be excluded from your XML command before sending it to Openprovider.'' | |
| + |  <?xml version="1.0" encoding="UTF-8"?> | ||
| + |  <openXML> | ||
| + |    <credentials> | ||
| + |      <username>username</username> | ||
| + |      <password>password</password> | ||
| + |    </credentials> | ||
| + |    <searchCustomerRequest> | ||
| + |      <offset>0</offset> | ||
| + |      <limit>100</limit> | ||
| + |      <order>asc</order> | ||
| + |      <orderBy>companyName</orderBy> | ||
| + |      <companyNamePattern>*hosting*</companyNamePattern> | ||
| + |      <withAdditionalData>0</withAdditionalData> | ||
| + |    </searchCustomerRequest> | ||
| + |  </openXML> | ||
| + | |||
| + |  <?xml version="1.0" encoding="UTF-8"?> | ||
| + |  <openXML> | ||
| + |    <reply> | ||
| + |      < code>0</code> | ||
| + |      <desc></desc> | ||
| + |      <data> | ||
| + |        <results> | ||
| + |          <array> | ||
| + |            <item> | ||
| + |              <id>156384</id> | ||
| + |              <companyName>Hosting Unlimited</companyName> | ||
| + |              <name> | ||
| + |                <initials>J.B.</initials> | ||
| + |                <firstName>John</firstName> | ||
| + |                <prefix>van</prefix> | ||
| + |                <lastName>Halen</lastName> | ||
| + |              </name> | ||
| + |              <gender>M</gender> | ||
| + |              <phone> | ||
| + |                <countryCode>+8</countryCode> | ||
| + |                <areaCode>383</areaCode> | ||
| + |                <subscriberNumber>1231212</subscriberNumber> | ||
| + |              </phone> | ||
| + |              <fax> | ||
| + |                <countryCode>+8</countryCode> | ||
| + |                <areaCode>383</areaCode> | ||
| + |                <subscriberNumber>1231213</subscriberNumber> | ||
| + |              </fax> | ||
| + |              <address> | ||
| + |                <street>Main Street</street> | ||
| + |                <number>2</number> | ||
| + |                <zipcode>630060</zipcode> | ||
| + |                <city>Washington</city> | ||
| + |                <country>US</country> | ||
| + |                <suffix>a</suffix> | ||
| + |              </address> | ||
| + |              <email>info@openprovider.nl</email> | ||
| + |              <handle>JH000001-US</handle> | ||
| + |              <comments></comments> | ||
| + |            </item> | ||
| + |          </array> | ||
| + |        </results> | ||
| + |        <total>1</total> | ||
| + |      </data> | ||
| + |    </reply> | ||
| + |  </openXML> | ||
Current revision as of 12:29, 20 May 2020
| Contents | 
Module Customer > Search
| Module | customer | 
| Command name | searchCustomerRequest | 
| Use | Returns a list of customer objects matching search criteria | 
| Input | |
| Output | Result set of customer details: 
 | 
Examples
Using PHP class
$request = new OP_Request;
$request->setCommand('searchCustomerRequest')
 ->setAuth(array('username' => 'username', 'password' => 'password'))
 ->setArgs(array(
   'offset' => 0,
   'limit'  => 25,
   'emailPattern' => '*@openprovider.nl',
   'lastNamePattern' => 'Smith',
   'companyNamePattern' => '*prov*'
 ));
Raw XML
Please note that newlines and leading spaces are added only for readability. Those whitespaces should be excluded from your XML command before sending it to Openprovider.
<?xml version="1.0" encoding="UTF-8"?>
<openXML>
  <credentials>
    <username>username</username>
    <password>password</password>
  </credentials>
  <searchCustomerRequest>
    <offset>0</offset>
    <limit>100</limit>
    <order>asc</order>
    <orderBy>companyName</orderBy>
    <companyNamePattern>*hosting*</companyNamePattern>
    <withAdditionalData>0</withAdditionalData>
  </searchCustomerRequest>
</openXML>
<?xml version="1.0" encoding="UTF-8"?>
<openXML>
  <reply>
    < code>0</code>
    <desc></desc>
    <data>
      <results>
        <array>
          <item>
            <id>156384</id>
            <companyName>Hosting Unlimited</companyName>
            <name>
              <initials>J.B.</initials>
              <firstName>John</firstName>
              <prefix>van</prefix>
              <lastName>Halen</lastName>
            </name>
            <gender>M</gender>
            <phone>
              <countryCode>+8</countryCode>
              <areaCode>383</areaCode>
              <subscriberNumber>1231212</subscriberNumber>
            </phone>
            <fax>
              <countryCode>+8</countryCode>
              <areaCode>383</areaCode>
              <subscriberNumber>1231213</subscriberNumber>
            </fax>
            <address>
              <street>Main Street</street>
              <number>2</number>
              <zipcode>630060</zipcode>
              <city>Washington</city>
              <country>US</country>
              <suffix>a</suffix>
            </address>
            <email>info@openprovider.nl</email>
            <handle>JH000001-US</handle>
            <comments></comments>
          </item>
        </array>
      </results>
      <total>1</total>
    </data>
  </reply>
</openXML>