Projects (project)

Projects. Domain: Project.


what	`project`
Direction	Output (get), Input (put)
Endpoint	`POST https://login.directo.ee/xmlcore/cap_xml_direct/xmlcore.asp`
Schema (output)	ws_projektid.xsd
Schema (input)	xml_IN_projektid.xsd

Output (get)

Query (get)

Parameter	Description
`token`	interface token (required)
`get`	1
`what`	project
`code`	optional filter
`customer`	optional filter
`supplier`	optional filter
`orderer`	optional filter
`contract`	optional filter
`closed`	optional filter
`ts`	changed-since (for syncing)

XML field	SQL field	Type	Length	UI label	Description
`code`	kood	string	32	Kood
`name`	nimi	string	255	Nimi
`manager`	juht	string	32	Juht
`object`	objekt	string	255	objekt
`type`	proj_tyyp	string	32	Tüüp
`start`	aeg1	dateTime		Algus
`end`	aeg2	dateTime		Lõpp
`customer`	klient_kood	string	32	Kliendi kood
`orderer`	tellija_kood	string	32	Tellija kood
`status`	staatus	string	32	Staatus
`closed`	suletud	int		Suletud	closed = 1, open = 0
`cu`	cu	string	32	Viimane muutja	document last changed by
`createdts`	aeg_loodud	dateTime		Kuupäev millal dokument loodi	document created
`ts`	ts	dateTime		Aeg millal dokumenti viimati muudeti	document last changed

Input (put)

Create: send the document. Modify: requires xd_update=1 and posting the whole document. Default values (ALT.FROM): Mandatory fields.

A confirmed document cannot be modified (response Type=14).

Header

XML field	SQL field	Type	Length	Mandatory	UI label	Description
`code`	kood	string	32	yes	Kood	document number/ID, mandatory; It must be unique for each document and remain same if more than one transaction of the same document is necessary
`name`	nimi	string	255		Nimi
`manager`	juht	string	32		Juht
`members`	liikmed	string	2000		Liikmed
`start`	aeg1	dateTime			Algus
`end`	aeg2	dateTime			Lõpp
`currency`	valuuta	string	32		Valuuta
`master`	master	string	32		Peaprojekt
`customer`	klient_kood	string	32		Kliendi kood	ALT.FROM: using “customerregno”
`customerregno`	klient_regnr	string	50		Kliendi reg.nr
`customername`	klient_nimi	string	200		Kliendi nimi	ALT.FROM: customer
`customercontact`	kl_kontakt	string	100		Kl.kontakt	ALT.FROM: customer
`customercontactphone`	kl_kontakt_telefon	string	64		Kliendi telefon	ALT.FROM: customer
`customercontactemail`	kl_kontakt_email	string	255		Kliendi e-mail	ALT.FROM: customer
`supplier`	hankija_kood	string	32		Hankija kood	ALT.FROM: using “supplierregno”
`supplierregno`	hankija_regnr	string	50		Hankija reg.nr
`suppliername`	hankija_nimi	string	200		Hankija nimi	ALT.FROM: supplier
`suppliercontact`	h_kontakt	string	100		H.kontakt	ALT.FROM: supplier
`suppliercontactphone`	h_kontakt_telefon	string	64		Hankija telefon	ALT.FROM: supplier
`suppliercontactemail`	h_kontakt_email	string	255		Hankija email	ALT.FROM: supplier
`memo`	memo	string	4000		Memo	or infinite (slower)
`memo2`	memo2	string	4000		Memo2	or infinite (slower)
`plannedprofit`	pl_kate	decimal			Plan.kate
`url`	url	string	255		Url
`object`	objekt	string	255		objekt
`customerinventory`	kl_inventar	string	32		Kl. inventar
`type`	proj_tyyp	string	32		Tüüp	ALT.FROM: tr.params
`address1`	aadress1	string	255		Tänav	ALT.FROM: customer
`address2`	aadress2	string	255		Indeks,linn	ALT.FROM: customer
`address3`	aadress3	string	255		Maa	ALT.FROM: customer
`country`	asumaa	string	32		Asumaa	ALT.FROM: customer
`county`	maakond	string	32		Maakond	ALT.FROM: customer
`sraccount`	lskonto	string	32		LS konto
`contract`	leping	int			Leping
`orderer`	tellija_kood	string	32		Tellija kood
`orderername`	tellija_nimi	string	255		Tellija nimi	ALT.FROM: orderer
`orderercontact`	tl_kontakt	string	100		Tl.kontakt	ALT.FROM: orderer
`orderercontactphone`	tl_kontakt_telefon	string	64		Tellija telefon	ALT.FROM: orderer
`orderercontactemail`	tl_kontakt_email	string	255		Tellija email	ALT.FROM: orderer
`ordereraddress1`	tellija_aadress1	string	255		Tellija tänav	ALT.FROM: orderer
`ordereraddress2`	tellija_aadress2	string	255		Tellija Indeks, linn	ALT.FROM: orderer
`ordereraddress3`	tellija_aadress3	string	255		Tellija maa	ALT.FROM: orderer
`orderercountry`	tellija_asumaa	string	32		Tellija asumaa	ALT.FROM: orderer
`orderercounty`	tellija_maakond	string	32		Tellija maakond	ALT.FROM: orderer
`payterm`	tingimus	string	32		Tas.ting	ALT.FROM: customer
`status`	staatus	string	32		staatus	ALT.FROM: tr.params
`closed`	suletud	int			suletud	closed = 1, open = 0
`contractend`	garantii	decimal			Garantii%
`worth`	maksumus	decimal			Maksumus
`costbudget`	summa_kulud	decimal			Kulude eelarve
`customer_vatregno`	klient_kmregnumber	string	32		Kliendikaardil: Km reg nr
`customer_vatzone`	klient_maa	int			Kliendikaardil: Maa	local = 0, EU = 1, export = 2
`customer_type`	klient_tyyp	int	32		Kliendikaardil: Tüüp
`customer_class`	klient_klass	string	32		Kliendikaardil: Klass
`customer_loyaltycard`	klient_kliendikaart	string	100		Kliendikaardil: Kliendikaart

Do not send:

session_id – for internal use at Directo side, do not send this field!

Rows

XML field	SQL field	Type	Length	UI label	Description
`action`	tegevus	string	255	Tegevus	ALT.FROM: item
`start`	algus	dateTime		Algus
`manager`	juht	string	32	Juht
`workers`	tegijad	string	100	Tegijad
`comment`	kommentaar	string	255	Kommentaar
`Preliminiaryend`	oletatav_lopp	dateTime		Oletatav valmimisaeg
`done`	valmis	int		Valmis
`actualend`	tegelik_lopp	dateTime		Tegelik valmimisaeg
`sum`	summa	decimal		Summa
`plannedtime`	aeg_raha1	dateTime		Planeeritud
`actualtime`	aeg_raha2	dateTime		Tegelik
`points`	punktid	decimal		Punktid
`after`	peale	int		Peale
`event`	event	int
`object`	objekt	string	255
`item`	r_artikkel	string	32
`quotation`	pakkumine	int
`costs`	kulud	decimal		Kulud
`worker`	teostaja	string	100	Teostaja
`budget`	eelarve	int
`amount`	rea_kogus	decimal
`invoice`	arve	int
`text1`	tekst1	string	32
`text2`	tekst2	string	32
`constant1`	konstant1	decimal		Konstant1
`constant2`	konstant2	decimal		Konstant2
`rn`	rn	int		Nr	row order number in document 1 - N ALT.FROM: random

Extra fields

XML field	SQL field	Type	Length	UI label
`code`	kood	string	32
`content`	sisu	string	2000	Sisu
`param`	param	string	64	Parameeter

Transport parameters

Configured on the token (interface), not sent in xmldata. PARAMETER 2 = document type.

TYPE	CODE	PARAMETER 1	PARAMETER 2	DESCRIPTION
XML	`xd_status`	(staatus)	PROJECT	Default status

Response

docid = number of the created/updated document. Error codes: Responses and error codes.

<results>
  <Result Type="0" Desc="Created" docid="100001" doctype="PROJECT" submit="Projects"/>
</results>

Directo help

Table of Contents

Projects (project)

Output (get)

Query (get)

Header

Input (put)

Header

Rows

Extra fields

Transport parameters

Response