POST ...
...
Authorization: You must be logged in to view this information
...
Parameter | API | Description |
---|---|---|
encoding | all |
File format Possible values: UTF-8 (by default), ISO-8859-1, ...
|
clear_items_not_modified | items | Clear automatically items? Possible values:
By default: false
|
replace_users_association | users |
Replace clients/users associations or add only new clients/users associations? Possible values: 0 or 1
By default: 0
|
POST /api/items?encoding=UTF-8&clear_items_not_modified=true HTTP/1.1
...
data...
POST /api/items HTTP/1.1 Host: account.mydsomanager.com ... Authorization: You must be logged in to view this information ... "item_type";"item_number";"client_code";"item_date_issue";"item_date_due";"item_amount_initial_inc_tax";"item_currency" "FAC";"00000123";"C0001";"2023-02-09";"2023-02-16";"6 580,10";"USD" ...
Columns | Description |
---|---|
client_address_city | Address (City) |
client_address_country | Address (Country) |
client_address_postbox | Address (Post Office Box) |
client_address_state | Address (State / Province) |
client_address_street | Address (Street) |
client_address_street_line2 | Address (Street Line 2) |
client_address_street_line3 | Address (Street Line 3) |
client_address_street_number | Address (n° Street) |
client_address_zip | Address (ZIP (or Postal) Code) |
client_blocked |
Account blocked (Yes / No) Possible values: 0, 1 (by default: 0 <=> No) |
client_blocked_date |
Account blocked / Date Date format: YYYY-MM-DD |
client_business_line | Business line |
client_business_name * | Company / Business name |
client_code * | Company code |
client_comments | Comments |
client_commercial_email | Sales manager associated with the client / Email |
client_commercial_fax | Sales manager associated with the client / Fax |
client_commercial_firstname | Sales manager associated with the client / Firstname |
client_commercial_lastname | Sales manager associated with the client / Lastname |
client_commercial_phone | Sales manager associated with the client / Phone |
client_commercial_phone_cell | Sales manager associated with the client / Mobile phone |
client_credit_limit | Risk / Credit Limit |
client_email | |
client_fax | Fax |
client_group |
Groups List of customer groups separated by commas |
client_guarantee_insurer | Risk / Insurer guarantee |
client_guarantee_insurer_reference | Risk / Insurer reference |
client_guarantee_score | Risk / Score |
client_guarantee_temporary | Risk / Temporary guarantee |
client_guarantee_temporary_date_end | Risk / Temporary guarantee / End date |
client_guarantee_temporary_date_start | Risk / Temporary guarantee / Start date |
client_guarantee_type | Risk / Guarantee type |
client_guarantees_currency | Risk / Guarantees currency |
client_id | Legal ID |
client_order_backlog | Order backlog |
client_others_guarantees | Risk / Other guarantees |
client_payment_mean | Payment mean |
client_payment_term | Payment term |
client_phone | Phone |
client_phone_cell | Mobile phone |
client_siret |
Siret (for French companies) |
client_trading_name | Trading name |
client_unique_key | Unique client identifier |
client_url | Website |
client_vat | VAT Number |
POST /api/clients HTTP/1.1 Host: account.mydsomanager.com ... Authorization: You must be logged in to view this information ... "client_business_name";"client_code";"client_id";"client_address_country" "My company";"C0001";"FR12345678";"France" ...
Columns | Description |
---|---|
client_code * | Company code |
contact_collection |
Contact for collection (Yes / No) Possible values: 0, 1 (by default: 0 <=> No) |
contact_comments | Comments |
contact_email | |
contact_fax | Fax |
contact_firstname | Firstname |
contact_lastname * | Lastname |
contact_phone | Phone |
contact_phone_cell | Mobile phone |
contact_role |
Role Possible values:
|
contact_title | Title (Mr, Mrs ...) |
contact_unique_key | Unique contact identifier |
POST /api/contacts HTTP/1.1 Host: account.mydsomanager.com ... Authorization: You must be logged in to view this information ... "contact_firstname";"contact_lastname";"contact_role";"client_code" "Mike";"Jackson";"other";"C0001" ...
Columns | Description |
---|---|
client_code * | Company code |
user_email | |
user_firstname | Firstname |
user_lastname * | Lastname |
POST /api/users HTTP/1.1 Host: account.mydsomanager.com ... Authorization: You must be logged in to view this information ... "user_firstname";"user_lastname";"client_code" "John";"Roy";"C0001" ...
Field | Description |
---|---|
success | Indicates if the import was done successfully Possible values: true, false
|
error_code | Error code (if there was an error) Possible values: ACCESS_DENIED, CSV_EMPTY, CSV_BAD_SYNTAX, ...
|
error_description | Error message (if there was an error) |
exception_lines | Lines ignored (not defined if no lines ignored) |
nb_client_added | Customers added |
nb_client_modified | Customers updated |
nb_contact_added | Contacts added |
nb_item_added | Items added |
nb_item_modified | Items updated |
nb_user_added | Users added |
nb_user_modified | Users updated |
{ "success": "true", "nb_client_added": 0, "nb_client_modified": 0, "nb_contact_added": 0, "nb_item_added": 5, "nb_item_modified": 2, "nb_user_added": 0, "nb_user_modified": 0, "exception_lines": { "line 3": "Column count doesn't match (defined=8, found=10)", }, }