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"}}