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. |
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.
See topic Common Parameters.
Required. CSV contacts file
Optional. CSV contacts file encoding
Type xsd:string.
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"}}