How to import your data automatically?

Translate this page to

Yükleniyor

To use this interface, create a script that will send every night (for example) your file of items, clients and contacts.

This program should send a CSV (file separated by semi-colon in the POST data) using credentials, url and syntax as below :

Login to your account via our API

To log in, use this login and password :

Address / URL :

https://account.mydsomanager.com/api/

You must be logged in to view this information

Example « Headers »

POST ...
...
Authorization: You must be logged in to view this information
...

İçe aktarma seçenekleri

Use these options only if you need them :

Parameter	API	Açıklama
encoding	all	Belge formatı Possible values: UTF-8 (Varsayılan), ISO-8859-1, ...
clear_items_not_modified	items	Clear automatically items? Possible values: true : « STOCK » mode → I import systematically all open items (invoices, credit notes, various operations ... not yet paid and cleared). In this case, if an item is present in an import day 'D' but not anymore in the next one at 'D 1', MY DSO MANAGER will clear it automatically. false : « DELTA » mode → I prefer to make partial imports (not necessarily all open items) and I indicate to MY DSO MANAGER the items which are paid and cleared either by clearing them manually in the statement of account in the customer sheet, or by making imports of items cleared with the field 'Payment date' filled with the date of the clearance of the items. Varsayılan: false
replace_users_association	users	Replace clients/users associations Ya da add only new clients/users associations? Possible values: 0 Ya da 1 Varsayılan: 0

Example « Headers » Ve « Data »

POST /api/items?encoding=UTF-8&clear_items_not_modified=true HTTP/1.1
...

data...

Add and modify your items (invoices, credit notes, ...)

Address / URL : https://account.mydsomanager.com /api/items

Use SSL to secure your connections

Columns syntax of the CSV file :

Sütunlar	Açıklama
client_code *	Şirket kodu
item_amount_initial	İlk miktar KDV hariç
item_amount_initial_inc_tax *	İlk miktar KDV dahil Example / Possible values: 1200 1 200,00 1200.00123 ...
item_amount_remaining	Kalan bakiye KDV hariç
item_amount_remaining_inc_tax	Kalan bakiye KDV dahil
item_business_case	Ticari isim
item_currency	Para birimi Example: EUR, USD, ...
item_date_due *	Vade tarihi Tarih biçimi: YYYY-MM-DD
item_date_issue *	Fatura tarihi Tarih biçimi: YYYY-MM-DD
item_date_order	Sipariş tarihi Tarih biçimi: YYYY-MM-DD
item_date_payment	Ödeme tarihi Tarih biçimi: YYYY-MM-DD
item_erp_type	Kurumsal Kaynak Planlaması öğe türü
item_file_number	Dosya numarası
item_number *	Öğe No.
item_order_number	Sipariş No.
item_sales_administrative	Satış Yönetimi
item_sales_manager	Satış müdürü
item_type *	Öğe türü Possible values: FAC, AVO, RGL, ODI, TRT, DPA
item_unique_key	Tek öğeyi tanımlama

Example « Headers » Ve « 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";"2022-08-16";"2022-08-23";"6 580,10";"USD"
...

Zorunlu sütunlar : client_code + item_type + item_number + item_date_issue + item_date_due + item_amount_initial_inc_tax

Add and modify your customers data

Address / URL : https://account.mydsomanager.com /api/clients

Use SSL to secure your connections

Columns syntax of the CSV file :

Sütunlar	Açıklama
client_address_city	Adres (Şehir)
client_address_country	Adres (Ülke)
client_address_postbox	Adres (Posta kutusu)
client_address_state	Adres (İl / Bölge)
client_address_street	Adres (Sokak)
client_address_street_line2	Adres (Sokak Line 2)
client_address_street_line3	Adres (Sokak Line 3)
client_address_street_number	Adres (n° Sokak)
client_address_zip	Adres (Posta kodu)
client_blocked	Hesap engellendi (Evet / Hayır) Possible values: 0, 1 (Varsayılan: 0 <=> Hayır)
client_blocked_date	Hesap engellendi / Tarih Tarih biçimi: YYYY-MM-DD
client_business_line	İş kolu
client_business_name *	Şirket / Firma unvanı
client_code *	Şirket kodu
client_comments	Yorumlar
client_commercial_email	Müşteriden sorumlu satış uzmanı / E-posta
client_commercial_fax	Müşteriden sorumlu satış uzmanı / Faks
client_commercial_firstname	Müşteriden sorumlu satış uzmanı / Ad
client_commercial_lastname	Müşteriden sorumlu satış uzmanı / Soyad
client_commercial_phone	Müşteriden sorumlu satış uzmanı / Telefon
client_commercial_phone_cell	Müşteriden sorumlu satış uzmanı / Cep telefonu
client_credit_limit	Risk / Kredi limiti
client_email	E-posta
client_fax	Faks
client_group	Gruplar List of customer groups separated by commas
client_guarantee_insurer	Risk / Sigorta
client_guarantee_insurer_reference	Risk / Sigortacı referans numarası
client_guarantee_score	Risk / Puan
client_guarantee_temporary	Risk / Geçici garanti
client_guarantee_temporary_date_end	Risk / Geçici garanti / Bitiş tarihi
client_guarantee_temporary_date_start	Risk / Geçici garanti / Başlangıç tarihi
client_guarantee_type	Risk / Garanti türü
client_guarantees_currency	Risk / Garanti (para) birimi
client_id	Şirket Sicil No
client_order_backlog	Sipariş portfolyosu
client_others_guarantees	Risk / Diğer garantiler
client_payment_mean	Ödeme şekli
client_payment_term	Vade
client_phone	Telefon
client_phone_cell	Cep telefonu
client_siret	Siret (for French companies)
client_trading_name	Ticari unvan
client_unique_key	Unique client identifier
client_url	İnternet sitesi
client_vat	Vergi No

Example « Headers » Ve « Data »

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

Zorunlu sütunlar : client_code + client_business_name

Add contacts to your customers

Address / URL : https://account.mydsomanager.com /api/contacts

Use SSL to secure your connections

Columns syntax of the CSV file :

Sütunlar	Açıklama
client_code *	Şirket kodu
contact_collection	Tahsilat için bağlantıya geç (Evet / Hayır) Possible values: 0, 1 (Varsayılan: 0 <=> Hayır)
contact_comments	Yorumlar
contact_email	E-posta
contact_fax	Faks
contact_firstname	Ad
contact_lastname *	Soyad
contact_phone	Telefon
contact_phone_cell	Cep telefonu
contact_role	Görev Possible values: accounting : Muhasebeci buyer : Müşteri company : Şirket manager : İcra memuru other : Diğer (Varsayılan)
contact_title	Unvan (Sayın ...)
contact_unique_key	Unique contact identifier

Example « Headers » Ve « Data »

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

Zorunlu sütunlar : client_code + contact_lastname

Associate users with your customers

Address / URL : https://account.mydsomanager.com /api/users

Use SSL to secure your connections

Columns syntax of the CSV file :

Sütunlar	Açıklama
client_code *	Şirket kodu
user_email	E-posta
user_firstname	Ad
user_lastname *	Soyad

Example « Headers » Ve « Data »

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

Zorunlu sütunlar : client_code + user_lastname

Return data

After performing the POST of these data MY DSO MANAGER will process immediately and will respond if there was an error or how much data has been added and updated.

This response will be in JSON format and returns the following information :

Alan	Açıklama
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	Müşteri eklendi
nb_client_modified	Müşteri güncellendi
nb_contact_added	Bağlantı eklendi
nb_item_added	öğe eklendi
nb_item_modified	öğe güncellendi
nb_user_added	Users added
nb_user_modified	Users updated

Example « Response »

{
	"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)",
	},
}