parseCsvContacts

Parses a CSV file of contact data and suggests a probable column mapping for import into the Luminate Online address book.

Client Servlet Server Servlet HTTP Methods Supported Requires Authentication
CRAddressBookAPI None. POST No.

Client API Syntax

https://secure2.convio.net/organization/site/CRAddressBookAPI?method=parseCsvContacts &api_key=value &v=value [ &center_id=value ] [ &error_redirect=value ] [ &redirect=value ] [ &response_format=xml | json ] [ &sign_redirects=value ] [ &source=value ] [ &sub_source=value ] [ &success_redirect=value ] [ &suppress_response_codes=value ] &contacts_upload_file=value [ &file_encoding=value ]

Usage Notes

Given a contacts_upload_file in comma-separated value (CSV) format and an optional file_encoding, this method attempts to parse and return contact information from the file.

Client API Parameters

Common Client Parameters

See topic Common Parameters.

contacts_upload_file

Required. CSV contacts file

file_encoding

Optional. CSV contacts file encoding

Type xsd:string.

Response

See topic HTTP Status Codes.

XML response
<?xml version="1.0" encoding="UTF-8"?>
<parseCsvContactsResponse xsi:schemaLocation="http://convio.com/crm/v1.0 http://service.convio.net/xmlschema/crm.public.v1.xsd" xmlns="http://convio.com/crm/v1.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
  <proposedCharacterEncoding>UTF-8</proposedCharacterEncoding>
  <columnHeaderLabels>
    <columnHeaderLabel>first_name</columnHeaderLabel>
    <columnHeaderLabel>middle_name</columnHeaderLabel>
    <columnHeaderLabel>last_name</columnHeaderLabel>
    <columnHeaderLabel>email</columnHeaderLabel>
    <columnHeaderLabel>phone_number</columnHeaderLabel>
  </columnHeaderLabels>
  <proposedMapping>
    <firstNameColumnIndex>0</firstNameColumnIndex>
    <lastNameColumnIndex>2</lastNameColumnIndex>
    <emailColumnIndex>3</emailColumnIndex>
  </proposedMapping>
  <confidenceLevel>HIGH</confidenceLevel>
  <csvDataRows>
    <csvDataRow>
      <csvValue>John</csvValue>
      <csvValue>Scott</csvValue>
      <csvValue>Smith</csvValue>
      <csvValue>jscott@fakemail.com</csvValue>
      <csvValue>(512) 492-1123</csvValue>
    </csvDataRow>
    <csvDataRow>
      <csvValue>Betsy</csvValue>
      <csvValue xsi:nil="true"/>
      <csvValue xsi:nil="true"/>
      <csvValue>betsy@fakemail.com</csvValue>
      <csvValue>(214) 923-1928</csvValue>
    </csvDataRow>
    <csvDataRow>
      <csvValue>Juan</csvValue>
      <csvValue xsi:nil="true"/>
      <csvValue>Dávila, Jr.</csvValue>
      <csvValue>juan.davila@fakemail.com</csvValue>
      <csvValue xsi:nil="true"/>
    </csvDataRow>
  </csvDataRows>
</parseCsvContactsResponse>

        
JSON response
{"parseCsvContactsResponse":{"csvDataRows":{"csvDataRow":[{"csvValue":["John","Scott","Smith","jscott@fakemail.com","(512) 492-1123"]},{"csvValue":["Betsy",null,null,"betsy@fakemail.com","(214) 923-1928"]},{"csvValue":["Juan",null,"Dávila, Jr.","juan.davila@fakemail.com",null]}]},"proposedMapping":{"lastNameColumnIndex":"2","emailColumnIndex":"3","firstNameColumnIndex":"0"},"columnHeaderLabels":{"columnHeaderLabel":["first_name","middle_name","last_name","email","phone_number"]},"confidenceLevel":"HIGH","proposedCharacterEncoding":"UTF-8"}}

        

Leave a Comment

Nickname
Comment
Enter this word: