Çevrimiçi Yardım
Automatic import »

How to import your data automatically?

Translate this page to TurkishTurkish ?
Yükleniyor 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 :
how api works

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, ...)

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üLink
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

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

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

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)",
	},
}
			
← Geri dön : Çevrimiçi Yardım » Çeşitli sorular