Table of Contents

offer-cube Entwickler Webservice Dokumentation

Zurück zur Webservice Dokumentation Startseite

Basisoperation <module>/list

Diese Action wird von jedem Modul angeboten und liefert eine Liste mit Einträgen für das jeweilige Modul.

Die Anzahl an zurückgegebenen Records wird über den Parameter perpage angegeben.

Die zurückgegebene Liste kann durch Angabe von Filterkriterien eingeschränkt werden. Die Filterkriterien werden im POST Request übergeben.

Die Filterkriterien müssen nur beim 1. Aufruf von list übergeben werden. Beim Holen der Seite 2 (z.B. Paramter p=1) verwendet das System automatisch die zuvor gesetzten Filterkriterien.

GET

https://server/tenant/s/module/list/?sid=sessionID[&output=outputMode][&perpage=(1-500)][&p=page][&o=sortField][&d=sortDirection]

parameter Optional: Standard Beschreibung
output JA: json JSON REST API (json) oder XML REST API (xml)
perpage JA: 12 anzahl an Elemente pro Seite (1-500)
p JA: 0 aktuelle Seite (0=erste Seite)
o JA: unterschiedlich je modul Feld für Sortierung
d JA: 0 aufsteigend (0) oder absteigend (1)

Beispiel:

https://server/tenant/s/offer/list/?sid=9bd3b5f93692e4659632c8585eb35447&perpage=100&p=2&o=startdate&d=0

Holt 100 Angebote (perpage=100) beginnend auf Seite 3 (page=2) sortiert nach Startdatum (o=startdate) in aufsteigender Reihenfolge (d=0)

POST

Per POST Parameter werden die Filterkriterien übergeben.

Der Parametername entspricht hierbei einfach dem Feldnamen (siehe Aktion schema) und der Parameterwert entspricht dem jeweiligen Inhalt, den das Feld haben muss.

Die einzelnen Kriterien werden UND verknüpft (d.h. alle Kriterien müssen zutreffen).

Parameter Beschreibung
<field>=<value> Das angegebene Feld muss dem Wert value entsprechen
<field2>=<value2> Das angegebene Feld muss dem Wert value entsprechen
<field…>=<value…> Das angegebene Feld muss dem Wert value entsprechen

Filter Syntax

Syntaxelement Beschreibung
keines Der angegebene Inhalt muss exakt entsprechen
% Es kann ein beliebiger Inhalt vorkommen
> Nur gültig bei Zahlen: Zahl muss größer sein
>= Nur gültig bei Zahlen: Zahl muss größer gleich sein
< Nur gültig bei Zahlen: Zahl muss kleiner sein
Nur gültig bei Zahlen: Zahl muss kleiner gleich sein
! Nur gültig bei Zahlen: Zahl muss ungleich sein
& Nur gültig bei Zahlen: UND Verknüpfung 2er Bedingungen
| Nur gültig bei Zahlen: ODER Verknüpfung 2er Bedingungen

Bei Datumsfelder kann direkt das Datum im deutschsprachigen Format DD.MM.YYYY angegeben werden. Das System kann hier auch mit Vergleichen (Größer, Kleiner) umgehen.
Alternativ ist auch die Angabe von Unixtimestamps möglich.
Das System erkennt das Datums/Zeitformat automatisch.

ACHTUNG: Groß- und Kleinschreibung wird bei Filterwerten NICHT unterschieden (bei Feldnamen jedoch schon).

Beispiele:

Beispiel Erklärung
lastname=“Mustermann” Nachname muss exakt “Mustermann” sein
lastname=“Muster%” Nachname muss mit “Muster” beginnen
id=“>5” Die ID muss größer 5 sein
id=“>5&<9” Die ID muss größer 5 und kleiner 9 sein
id=“!100” Die ID muss ungleich 100 sein
startdate=“>=1.10.2014&⇐31.12.2014” Das Startdatum muss zwischen 1.10.2014 und 31.12.2014 liegen

Beispiel: JSON Return

https://server/tenant/s/offer/list/?sid=9bd3b5f93692e4659632c8585eb35447&perpage=3&p=0&o=startdate&d=0

Die ersten 3 Angebote (perpage=3) auf der ersten Seite (p=0) sortiert nach Startdatum (o=startdate) aufsteigend (d=0)

{
	"module":"offer",
	"list": [{
		"id":"1",
		"created_user":"1",
		"created_user__id":"1",
		"created_user__created_user":"0",
		"created_user__created_ip":null,
		"created_user__created_date":"0",
		"created_user__modified_user":"1",
		"created_user__modified_ip":"10.1.1.214",
		"created_user__modified_date":"1422778828",
		"created_user__email":"admin@example.com",
		"created_user__tel":"+436641234567",
		"created_user__username":"admin@example.com",
		"created_user__status":"0",
		"created_user__status_inactive_dt":"0",
		"created_user__accesstype":"1024",
		"created_user__firstname":"Chuck",
		"created_user__lastname":"Tester",
		"created_user__title":"",
		"created_user__location_string":null,
		"created_user__location_privacy":"0",
		"created_user__location":"0",
		"created_user__location_street":"",
		"created_user__location_city":"",
		"created_user__location_zip":"0",
		"created_user__location_country":"",
		"created_user__partner":"0",
		"created_ip":"10.1.1.56",
		"created_date":"1373988203",
		"modified_user":"1",
		"modified_user__id":"1",
		"modified_user__created_user":"0",
		"modified_user__created_ip":null,
		"modified_user__created_date":"0",
		"modified_user__modified_user":"1",
		"modified_user__modified_ip":"10.1.1.214",
		"modified_user__modified_date":"1422778828",
		"modified_user__email":"admin@example.com",
		"modified_user__tel":"+436641234567",
		"modified_user__username":"admin@example.com",
		"modified_user__status":"0",
		"modified_user__status_inactive_dt":"0",
		"modified_user__accesstype":"1024",
		"modified_user__firstname":"Chuck",
		"modified_user__lastname":"Tester",
		"modified_user__title":"",
		"modified_user__location_string":null,
		"modified_user__location_privacy":"0",
		"modified_user__location":"0",
		"modified_user__location_street":"",
		"modified_user__location_city":"",
		"modified_user__location_zip":"0",
		"modified_user__location_country":"",
		"modified_user__partner":"0",
		"modified_ip":"10.1.1.56",
		"modified_date":"1375451044",
		"record_status":"0",
		"status":"8",
		"status_change_dt":"0",
		"status_sent":"0",
		"status_custinstructed":"0",
		"status_custinstructed_ip":null,
		"status_custdeclined":"0",
		"status_custdeclined_ip":null,
		"declinereason":"0",
		"reviewdate":"0",
		"sendtype":"0",
		"locked":"1",
		"customer":"3",
		"customer__id":"3",
		"customer__created_user":"1",
		"customer__created_ip":"10.1.1.56",
		"customer__created_date":"1373982851",
		"customer__modified_user":"0",
		"customer__modified_ip":"LOCALEXEC",
		"customer__modified_date":"1433455286",
		"customer__record_status":"0",
		"customer__status":"0",
		"customer__status_change_dt":"0",
		"customer__ctype":"1",
		"customer__lastname":"Seppenberger",
		"customer__firstname":"Franz",
		"customer__title":"1",
		"customer__company":"Franz Seppenberger OG",
		"customer__comboname":"Fa. Franz Seppenberger OG \/ Herr Franz Seppenberger ",
		"customer__comboname2":null,
		"customer__zip":"2320",
		"customer__city":"Rannersdorf",
		"customer__street":"Brauhausstr. 53-55",
		"customer__country":"\u00d6sterreich",
		"customer__email":"og.franz.seppenberger@example.com",
		"customer__phone":"01\/2312313",
		"customer__mobile":"+43 665 2312312",
		"customer__fax":"ffaaxx",
		"customer__web":"www.seppenberger-kg.at",
		"customer__vatno":null,
		"customer__code":null,
		"customer__paymenttype":null,
		"customer__paymentinfo":null,
		"customer__annexoffer":null,
		"customer__annexinvoice":null,
		"customer__discount":"2.5",
		"customer__tax":"0",
		"customer__description":null,
		"customer__istemplate":"0",
		"customer__mainatt":"0",
		"customer__lastcorrespondence":"166",
		"customer__linkurl":null,
		"customer__location":"0",
		"offerpdf":"6",
		"offerpdf__id":"6",
		"offerpdf__created_user":"1",
		"offerpdf__created_ip":"10.1.1.56",
		"offerpdf__created_date":"1375285612",
		"offerpdf__modified_user":"1",
		"offerpdf__modified_ip":"10.1.1.56",
		"offerpdf__modified_date":"1375285612",
		"offerpdf__customer":"0",
		"offerpdf__positiongroup":"0",
		"offerpdf__article":"0",
		"offerpdf__offer":"1",
		"offerpdf__order":"0",
		"offerpdf__invoice":"0",
		"offerpdf__dunning":"0",
		"offerpdf__position":"0",
		"offerpdf__user":"0",
		"offerpdf__inoutexpenses":"0",
		"offerpdf__settings":"",
		"offerpdf__sysevents":"0",
		"offerpdf__direction":"0",
		"offerpdf__type":"3",
		"offerpdf__code":null,
		"offerpdf__sentdate":"0",
		"offerpdf__readdate":"0",
		"offerpdf__filename":"offer-1-1375285612.pdf",
		"offerpdf__tempname":"00000\/6",
		"offerpdf__filetype":"21",
		"offerpdf__summary":null,
		"offerpdf__description":null,
		"offerpdf__token":null,
		"site_name":"Franz Seppenberger",
		"site_lastname":null,
		"site_firstname":null,
		"site_title":"0",
		"site_company":"Franz Seppenberger KG",
		"site_zip":"2320",
		"site_city":"Schwechat",
		"site_street":"Murauerstr. 1",
		"site_country":"\u00d6sterreich",
		"site_email":"franz@seppenberger-kg.at",
		"site_phone":"01\/2312312",
		"site_mobile":"+43 664 2312312",
		"site_fax":"ffaaxx",
		"site_vatno":null,
		"site_discount":"2.5",
		"site_tax":"0",
		"istemplate":"0",
		"parent":"0",
		"parent__id":null,
		"parent__created_user":null,
		"parent__created_ip":null,
		"parent__created_date":null,
		"parent__modified_user":null,
		"parent__modified_ip":null,
		"parent__modified_date":null,
		"parent__record_status":null,
		"parent__status":null,
		"parent__status_change_dt":null,
		"parent__status_sent":null,
		"parent__status_custinstructed":null,
		"parent__status_custinstructed_ip":null,
		"parent__status_custdeclined":null,
		"parent__status_custdeclined_ip":null,
		"parent__declinereason":null,
		"parent__reviewdate":null,
		"parent__sendtype":null,
		"parent__locked":null,
		"parent__customer":null,
		"parent__offerpdf":null,
		"parent__site_name":null,
		"parent__site_lastname":null,
		"parent__site_firstname":null,
		"parent__site_title":null,
		"parent__site_company":null,
		"parent__site_zip":null,
		"parent__site_city":null,
		"parent__site_street":null,
		"parent__site_country":null,
		"parent__site_email":null,
		"parent__site_phone":null,
		"parent__site_mobile":null,
		"parent__site_fax":null,
		"parent__site_vatno":null,
		"parent__site_discount":null,
		"parent__site_tax":null,
		"parent__istemplate":null,
		"parent__parent":null,
		"parent__newversion":null,
		"parent__price":null,
		"parent__description":null,
		"parent__positionsummary":null,
		"parent__reason":null,
		"parent__annotation":null,
		"parent__startdate":null,
		"parent__mainatt":null,
		"parent__linkurl":null,
		"parent__order":null,
		"parent__invoice":null,
		"parent__partner":null,
		"parent__location":null,
		"newversion":"0",
		"newversion__id":null,
		"newversion__created_user":null,
		"newversion__created_ip":null,
		"newversion__created_date":null,
		"newversion__modified_user":null,
		"newversion__modified_ip":null,
		"newversion__modified_date":null,
		"newversion__record_status":null,
		"newversion__status":null,
		"newversion__status_change_dt":null,
		"newversion__status_sent":null,
		"newversion__status_custinstructed":null,
		"newversion__status_custinstructed_ip":null,
		"newversion__status_custdeclined":null,
		"newversion__status_custdeclined_ip":null,
		"newversion__declinereason":null,
		"newversion__reviewdate":null,
		"newversion__sendtype":null,
		"newversion__locked":null,
		"newversion__customer":null,
		"newversion__offerpdf":null,
		"newversion__site_name":null,
		"newversion__site_lastname":null,
		"newversion__site_firstname":null,
		"newversion__site_title":null,
		"newversion__site_company":null,
		"newversion__site_zip":null,
		"newversion__site_city":null,
		"newversion__site_street":null,
		"newversion__site_country":null,
		"newversion__site_email":null,
		"newversion__site_phone":null,
		"newversion__site_mobile":null,
		"newversion__site_fax":null,
		"newversion__site_vatno":null,
		"newversion__site_discount":null,
		"newversion__site_tax":null,
		"newversion__istemplate":null,
		"newversion__parent":null,
		"newversion__newversion":null,
		"newversion__price":null,
		"newversion__description":null,
		"newversion__positionsummary":null,
		"newversion__reason":null,
		"newversion__annotation":null,
		"newversion__startdate":null,
		"newversion__mainatt":null,
		"newversion__linkurl":null,
		"newversion__order":null,
		"newversion__invoice":null,
		"newversion__partner":null,
		"newversion__location":null,
		"price":"605",
		"description":"",
		"positionsummary":null,
		"reason":"Die angebotene WP mit 11kW ist zu klein dimensioniert.",
		"annotation":null,
		"startdate":"0",
		"mainatt":"0",
		"mainatt__id":null,
		"mainatt__created_user":null,
		"mainatt__created_ip":null,
		"mainatt__created_date":null,
		"mainatt__modified_user":null,
		"mainatt__modified_ip":null,
		"mainatt__modified_date":null,
		"mainatt__customer":null,
		"mainatt__positiongroup":null,
		"mainatt__article":null,
		"mainatt__offer":null,
		"mainatt__order":null,
		"mainatt__invoice":null,
		"mainatt__dunning":null,
		"mainatt__position":null,
		"mainatt__user":null,
		"mainatt__inoutexpenses":null,
		"mainatt__settings":null,
		"mainatt__sysevents":null,
		"mainatt__direction":null,
		"mainatt__type":null,
		"mainatt__code":null,
		"mainatt__sentdate":null,
		"mainatt__readdate":null,
		"mainatt__filename":null,
		"mainatt__tempname":null,
		"mainatt__filetype":null,
		"mainatt__summary":null,
		"mainatt__description":null,
		"mainatt__token":null,
		"linkurl":null,
		"order":"0",
		"order__id":null,
		"order__created_user":null,
		"order__created_ip":null,
		"order__created_date":null,
		"order__modified_user":null,
		"order__modified_ip":null,
		"order__modified_date":null,
		"order__record_status":null,
		"order__status":null,
		"order__status_change_dt":null,
		"order__done_dt":null,
		"order__locked":null,
		"order__customer":null,
		"order__orderpdf":null,
		"order__site_name":null,
		"order__site_lastname":null,
		"order__site_firstname":null,
		"order__site_title":null,
		"order__site_company":null,
		"order__site_zip":null,
		"order__site_city":null,
		"order__site_street":null,
		"order__site_country":null,
		"order__site_email":null,
		"order__site_phone":null,
		"order__site_mobile":null,
		"order__site_fax":null,
		"order__site_vatno":null,
		"order__site_discount":null,
		"order__site_tax":null,
		"order__offer":null,
		"order__parent":null,
		"order__newversion":null,
		"order__price":null,
		"order__description":null,
		"order__positionsummary":null,
		"order__annotation":null,
		"order__startdate":null,
		"order__enddate":null,
		"order__contractenddate":null,
		"order__accountingperiod":null,
		"order__accountingfirstdate":null,
		"order__accountingnextdate":null,
		"order__accounting_dayofmonth":null,
		"order__ackrequired":null,
		"order__lastinvoice":null,
		"order__mainatt":null,
		"order__linkurl":null,
		"order__partner":null,
		"order__location":null,
		"invoice":"0",
		"invoice__id":null,
		"invoice__created_user":null,
		"invoice__created_ip":null,
		"invoice__created_date":null,
		"invoice__modified_user":null,
		"invoice__modified_ip":null,
		"invoice__modified_date":null,
		"invoice__record_status":null,
		"invoice__status":null,
		"invoice__status_change_dt":null,
		"invoice__status_sent":null,
		"invoice__duepayment_dt":null,
		"invoice__invoice_dt":null,
		"invoice__sendtype":null,
		"invoice__paid_dt":null,
		"invoice__locked":null,
		"invoice__customer":null,
		"invoice__invoicepdf":null,
		"invoice__site_name":null,
		"invoice__site_lastname":null,
		"invoice__site_firstname":null,
		"invoice__site_title":null,
		"invoice__site_company":null,
		"invoice__site_zip":null,
		"invoice__site_city":null,
		"invoice__site_street":null,
		"invoice__site_country":null,
		"invoice__site_email":null,
		"invoice__site_phone":null,
		"invoice__site_mobile":null,
		"invoice__site_fax":null,
		"invoice__site_vatno":null,
		"invoice__site_discount":null,
		"invoice__site_tax":null,
		"invoice__offer":null,
		"invoice__order":null,
		"invoice__parent":null,
		"invoice__newversion":null,
		"invoice__dunning":null,
		"invoice__price":null,
		"invoice__description":null,
		"invoice__positionsummary":null,
		"invoice__reason":null,
		"invoice__annotation":null,
		"invoice__mainatt":null,
		"invoice__linkurl":null,
		"invoice__partner":null,
		"invoice__location":null,
		"partner":"0",
		"location":"0",
		"_representationname":"o1 Franz Seppenberger (Franz Seppenberger KG)",
		"created_user___representationname":"admin@example.com (Tester, Chuck)",
		"modified_user___representationname":"admin@example.com (Tester, Chuck)",
		"customer___representationname":"Herr Franz Seppenberger (Franz Seppenberger OG)",
		"offerpdf___representationname":"offer-1-1375285612.pdf",
		"parent___representationname":"o  ",
		"newversion___representationname":"o  ",
		"mainatt___representationname":"attachment:",
		"order___representationname":"n  ",
		"invoice___representationname":"r  ",
		"__discount_price_subtract":-15.125,
		"__price_sum":589.875,
		"__price_sum_wtax":589.875
	},{
		"id":"2",
		"created_user":"1",
		"created_user__id":"1",
		"created_user__created_user":"0",
		"created_user__created_ip":null,
		"created_user__created_date":"0",
		"created_user__modified_user":"1",
		"created_user__modified_ip":"10.1.1.214",
		"created_user__modified_date":"1422778828",
		"created_user__email":"admin@example.com",
		"created_user__tel":"+436641234567",
		"created_user__username":"admin@example.com",
		"created_user__status":"0",
		"created_user__status_inactive_dt":"0",
		"created_user__accesstype":"1024",
		"created_user__firstname":"Chuck",
		"created_user__lastname":"Tester",
		"created_user__title":"",
		"created_user__location_string":null,
		"created_user__location_privacy":"0",
		"created_user__location":"0",
		"created_user__location_street":"",
		"created_user__location_city":"",
		"created_user__location_zip":"0",
		"created_user__location_country":"",
		"created_user__partner":"0",
		"created_ip":"10.1.1.56",
		"created_date":"1373989920",
		"modified_user":"1",
		"modified_user__id":"1",
		"modified_user__created_user":"0",
		"modified_user__created_ip":null,
		"modified_user__created_date":"0",
		"modified_user__modified_user":"1",
		"modified_user__modified_ip":"10.1.1.214",
		"modified_user__modified_date":"1422778828",
		"modified_user__email":"admin@example.com",
		"modified_user__tel":"+436641234567",
		"modified_user__username":"admin@example.com",
		"modified_user__status":"0",
		"modified_user__status_inactive_dt":"0",
		"modified_user__accesstype":"1024",
		"modified_user__firstname":"Chuck",
		"modified_user__lastname":"Tester",
		"modified_user__title":"",
		"modified_user__location_string":null,
		"modified_user__location_privacy":"0",
		"modified_user__location":"0",
		"modified_user__location_street":"",
		"modified_user__location_city":"",
		"modified_user__location_zip":"0",
		"modified_user__location_country":"",
		"modified_user__partner":"0",
		"modified_ip":"10.1.1.56",
		"modified_date":"1375963059",
		"record_status":"0",
		"status":"2",
		"status_change_dt":"0",
		"status_sent":"1375963059",
		"status_custinstructed":"0",
		"status_custinstructed_ip":null,
		"status_custdeclined":"0",
		"status_custdeclined_ip":null,
		"declinereason":"0",
		"reviewdate":"1377122400",
		"sendtype":"1",
		"locked":"1",
		"customer":"1",
		"customer__id":"1",
		"customer__created_user":"1",
		"customer__created_ip":"10.1.1.56",
		"customer__created_date":"1373982680",
		"customer__modified_user":"0",
		"customer__modified_ip":"LOCALEXEC",
		"customer__modified_date":"1432724983",
		"customer__record_status":"0",
		"customer__status":"0",
		"customer__status_change_dt":"0",
		"customer__ctype":"0",
		"customer__lastname":"Mustermann",
		"customer__firstname":"Leo",
		"customer__title":"1",
		"customer__company":"Mustermann Idea Consulting GmbH",
		"customer__comboname":"Fa. Mustermann Idea Consulting GmbH \/ Herr Leo Mustermann ",
		"customer__comboname2":null,
		"customer__zip":"2432",
		"customer__city":"Schwadorf",
		"customer__street":"Musterstrasse 3b",
		"customer__country":"\u00d6sterreich",
		"customer__email":"",
		"customer__phone":"01\/4540085",
		"customer__mobile":"",
		"customer__fax":"",
		"customer__web":"",
		"customer__vatno":null,
		"customer__code":null,
		"customer__paymenttype":null,
		"customer__paymentinfo":null,
		"customer__annexoffer":null,
		"customer__annexinvoice":null,
		"customer__discount":"0",
		"customer__tax":"0",
		"customer__description":null,
		"customer__istemplate":"0",
		"customer__mainatt":"0",
		"customer__lastcorrespondence":"161",
		"customer__linkurl":null,
		"customer__salesuser":"0",
		"customer__partner":"0",
		"customer__partnerrevenueshare":"0",
		"customer__location":"0",
		"offerpdf":"41",
		"offerpdf__id":"41",
		"offerpdf__created_user":"1",
		"offerpdf__created_ip":"10.1.1.56",
		"offerpdf__created_date":"1375963059",
		"offerpdf__modified_user":"1",
		"offerpdf__modified_ip":"10.1.1.56",
		"offerpdf__modified_date":"1375963059",
		"offerpdf__customer":"0",
		"offerpdf__positiongroup":"0",
		"offerpdf__article":"0",
		"offerpdf__offer":"2",
		"offerpdf__order":"0",
		"offerpdf__invoice":"0",
		"offerpdf__dunning":"0",
		"offerpdf__position":"0",
		"offerpdf__user":"0",
		"offerpdf__inoutexpenses":"0",
		"offerpdf__settings":"",
		"offerpdf__sysevents":"0",
		"offerpdf__direction":"0",
		"offerpdf__type":"3",
		"offerpdf__code":null,
		"offerpdf__sentdate":"0",
		"offerpdf__readdate":"0",
		"offerpdf__filename":"offer-2-1375963059.pdf",
		"offerpdf__tempname":"00000\/41",
		"offerpdf__filetype":"21",
		"offerpdf__summary":null,
		"offerpdf__description":null,
		"offerpdf__token":"2a943a764108ed053bb63a0029980fd7",
		"site_name":"Herr Leo Mustermann",
		"site_lastname":null,
		"site_firstname":null,
		"site_title":"0",
		"site_company":"",
		"site_zip":"2432",
		"site_city":"Schwadorf",
		"site_street":"Musterstrasse 6",
		"site_country":"\u00d6sterreich",
		"site_email":"leo@Mustermann.at",
		"site_phone":"",
		"site_mobile":"02\/mobil",
		"site_fax":"03\/fax",
		"site_vatno":null,
		"site_discount":"3.5",
		"site_tax":"0",
		"istemplate":"0",
		"parent":"0",
		"parent__id":null,
		"parent__created_user":null,
		"parent__created_ip":null,
		"parent__created_date":null,
		"parent__modified_user":null,
		"parent__modified_ip":null,
		"parent__modified_date":null,
		"parent__record_status":null,
		"parent__status":null,
		"parent__status_change_dt":null,
		"parent__status_sent":null,
		"parent__status_custinstructed":null,
		"parent__status_custinstructed_ip":null,
		"parent__status_custdeclined":null,
		"parent__status_custdeclined_ip":null,
		"parent__declinereason":null,
		"parent__reviewdate":null,
		"parent__sendtype":null,
		"parent__locked":null,
		"parent__customer":null,
		"parent__offerpdf":null,
		"parent__site_name":null,
		"parent__site_lastname":null,
		"parent__site_firstname":null,
		"parent__site_title":null,
		"parent__site_company":null,
		"parent__site_zip":null,
		"parent__site_city":null,
		"parent__site_street":null,
		"parent__site_country":null,
		"parent__site_email":null,
		"parent__site_phone":null,
		"parent__site_mobile":null,
		"parent__site_fax":null,
		"parent__site_vatno":null,
		"parent__site_discount":null,
		"parent__site_tax":null,
		"parent__istemplate":null,
		"parent__parent":null,
		"parent__newversion":null,
		"parent__price":null,
		"parent__description":null,
		"parent__positionsummary":null,
		"parent__reason":null,
		"parent__annotation":null,
		"parent__startdate":null,
		"parent__mainatt":null,
		"parent__linkurl":null,
		"parent__order":null,
		"parent__invoice":null,
		"parent__partner":null,
		"parent__location":null,
		"newversion":"0",
		"newversion__id":null,
		"newversion__created_user":null,
		"newversion__created_ip":null,
		"newversion__created_date":null,
		"newversion__modified_user":null,
		"newversion__modified_ip":null,
		"newversion__modified_date":null,
		"newversion__record_status":null,
		"newversion__status":null,
		"newversion__status_change_dt":null,
		"newversion__status_sent":null,
		"newversion__status_custinstructed":null,
		"newversion__status_custinstructed_ip":null,
		"newversion__status_custdeclined":null,
		"newversion__status_custdeclined_ip":null,
		"newversion__declinereason":null,
		"newversion__reviewdate":null,
		"newversion__sendtype":null,
		"newversion__locked":null,
		"newversion__customer":null,
		"newversion__offerpdf":null,
		"newversion__site_name":null,
		"newversion__site_lastname":null,
		"newversion__site_firstname":null,
		"newversion__site_title":null,
		"newversion__site_company":null,
		"newversion__site_zip":null,
		"newversion__site_city":null,
		"newversion__site_street":null,
		"newversion__site_country":null,
		"newversion__site_email":null,
		"newversion__site_phone":null,
		"newversion__site_mobile":null,
		"newversion__site_fax":null,
		"newversion__site_vatno":null,
		"newversion__site_discount":null,
		"newversion__site_tax":null,
		"newversion__istemplate":null,
		"newversion__parent":null,
		"newversion__newversion":null,
		"newversion__price":null,
		"newversion__description":null,
		"newversion__positionsummary":null,
		"newversion__reason":null,
		"newversion__annotation":null,
		"newversion__startdate":null,
		"newversion__mainatt":null,
		"newversion__linkurl":null,
		"newversion__order":null,
		"newversion__invoice":null,
		"newversion__partner":null,
		"newversion__location":null,
		"price":"0",
		"description":"Komische Sache\r\nN\u00e4chste Zeile\r\nUnd jetzt ganz viel Tex und ganz viel Tex und ganz viel Tex und ganz viel Tex und ganz viel Tex und ganz viel Tex und ganz viel Tex und ganz viel Tex und ganz viel Tex und",
		"positionsummary":null,
		"reason":null,
		"annotation":null,
		"startdate":"0",
		"mainatt":"0",
		"mainatt__id":null,
		"mainatt__created_user":null,
		"mainatt__created_ip":null,
		"mainatt__created_date":null,
		"mainatt__modified_user":null,
		"mainatt__modified_ip":null,
		"mainatt__modified_date":null,
		"mainatt__customer":null,
		"mainatt__positiongroup":null,
		"mainatt__article":null,
		"mainatt__offer":null,
		"mainatt__order":null,
		"mainatt__invoice":null,
		"mainatt__dunning":null,
		"mainatt__position":null,
		"mainatt__user":null,
		"mainatt__inoutexpenses":null,
		"mainatt__settings":null,
		"mainatt__sysevents":null,
		"mainatt__direction":null,
		"mainatt__type":null,
		"mainatt__code":null,
		"mainatt__sentdate":null,
		"mainatt__readdate":null,
		"mainatt__filename":null,
		"mainatt__tempname":null,
		"mainatt__filetype":null,
		"mainatt__summary":null,
		"mainatt__description":null,
		"mainatt__token":null,
		"linkurl":null,
		"order":"0",
		"order__id":null,
		"order__created_user":null,
		"order__created_ip":null,
		"order__created_date":null,
		"order__modified_user":null,
		"order__modified_ip":null,
		"order__modified_date":null,
		"order__record_status":null,
		"order__status":null,
		"order__status_change_dt":null,
		"order__done_dt":null,
		"order__locked":null,
		"order__customer":null,
		"order__orderpdf":null,
		"order__site_name":null,
		"order__site_lastname":null,
		"order__site_firstname":null,
		"order__site_title":null,
		"order__site_company":null,
		"order__site_zip":null,
		"order__site_city":null,
		"order__site_street":null,
		"order__site_country":null,
		"order__site_email":null,
		"order__site_phone":null,
		"order__site_mobile":null,
		"order__site_fax":null,
		"order__site_vatno":null,
		"order__site_discount":null,
		"order__site_tax":null,
		"order__offer":null,
		"order__parent":null,
		"order__newversion":null,
		"order__price":null,
		"order__description":null,
		"order__positionsummary":null,
		"order__annotation":null,
		"order__startdate":null,
		"order__enddate":null,
		"order__contractenddate":null,
		"order__accountingperiod":null,
		"order__accountingfirstdate":null,
		"order__accountingnextdate":null,
		"order__accounting_dayofmonth":null,
		"order__ackrequired":null,
		"order__lastinvoice":null,
		"order__mainatt":null,
		"order__linkurl":null,
		"order__partner":null,
		"order__location":null,
		"invoice":"0",
		"invoice__id":null,
		"invoice__created_user":null,
		"invoice__created_ip":null,
		"invoice__created_date":null,
		"invoice__modified_user":null,
		"invoice__modified_ip":null,
		"invoice__modified_date":null,
		"invoice__record_status":null,
		"invoice__status":null,
		"invoice__status_change_dt":null,
		"invoice__status_sent":null,
		"invoice__duepayment_dt":null,
		"invoice__invoice_dt":null,
		"invoice__sendtype":null,
		"invoice__paid_dt":null,
		"invoice__locked":null,
		"invoice__customer":null,
		"invoice__invoicepdf":null,
		"invoice__site_name":null,
		"invoice__site_lastname":null,
		"invoice__site_firstname":null,
		"invoice__site_title":null,
		"invoice__site_company":null,
		"invoice__site_zip":null,
		"invoice__site_city":null,
		"invoice__site_street":null,
		"invoice__site_country":null,
		"invoice__site_email":null,
		"invoice__site_phone":null,
		"invoice__site_mobile":null,
		"invoice__site_fax":null,
		"invoice__site_vatno":null,
		"invoice__site_discount":null,
		"invoice__site_tax":null,
		"invoice__offer":null,
		"invoice__order":null,
		"invoice__parent":null,
		"invoice__newversion":null,
		"invoice__dunning":null,
		"invoice__price":null,
		"invoice__description":null,
		"invoice__positionsummary":null,
		"invoice__reason":null,
		"invoice__annotation":null,
		"invoice__mainatt":null,
		"invoice__linkurl":null,
		"invoice__partner":null,
		"invoice__location":null,
		"partner":"0",
		"location":"0",
		"_representationname":"o2 Herr Leo Mustermann ",
		"created_user___representationname":"admin@example.com (Tester, Chuck)",
		"modified_user___representationname":"admin@example.com (Tester, Chuck)",
		"customer___representationname":"Herr Leo Mustermann (Mustermann Idea Consulting GmbH)",
		"offerpdf___representationname":"offer-2-1375963059.pdf",
		"parent___representationname":"o  ",
		"newversion___representationname":"o  ",
		"mainatt___representationname":"attachment:",
		"order___representationname":"n  ",
		"invoice___representationname":"r  ",
		"__discount_price_subtract":-0,
		"__price_sum":0,
		"__price_sum_wtax":0
	},{
		"id":"3",
		"created_user":"1",
		"created_user__id":"1",
		"created_user__created_user":"0",
		"created_user__created_ip":null,
		"created_user__created_date":"0",
		"created_user__modified_user":"1",
		"created_user__modified_ip":"10.1.1.214",
		"created_user__modified_date":"1422778828",
		"created_user__email":"admin@example.com",
		"created_user__tel":"+436641234567",
		"created_user__username":"admin@example.com",
		"created_user__status":"0",
		"created_user__status_inactive_dt":"0",
		"created_user__accesstype":"1024",
		"created_user__firstname":"Chuck",
		"created_user__lastname":"Tester",
		"created_user__title":"",
		"created_user__location_string":null,
		"created_user__location_privacy":"0",
		"created_user__location":"0",
		"created_user__location_street":"",
		"created_user__location_city":"",
		"created_user__location_zip":"0",
		"created_user__location_country":"",
		"created_user__partner":"0",
		"created_ip":"10.1.1.56",
		"created_date":"1373990781",
		"modified_user":"1",
		"modified_user__id":"1",
		"modified_user__created_user":"0",
		"modified_user__created_ip":null,
		"modified_user__created_date":"0",
		"modified_user__modified_user":"1",
		"modified_user__modified_ip":"10.1.1.214",
		"modified_user__modified_date":"1422778828",
		"modified_user__email":"admin@example.com",
		"modified_user__tel":"+436641234567",
		"modified_user__username":"admin@example.com",
		"modified_user__status":"0",
		"modified_user__status_inactive_dt":"0",
		"modified_user__accesstype":"1024",
		"modified_user__firstname":"Chuck",
		"modified_user__lastname":"Tester",
		"modified_user__title":"",
		"modified_user__location_string":null,
		"modified_user__location_privacy":"0",
		"modified_user__location":"0",
		"modified_user__location_street":"",
		"modified_user__location_city":"",
		"modified_user__location_zip":"0",
		"modified_user__location_country":"",
		"modified_user__partner":"0",
		"modified_ip":"10.1.1.56",
		"modified_date":"1375451044",
		"record_status":"0",
		"status":"0",
		"status_change_dt":"0",
		"status_sent":"0",
		"status_custinstructed":"0",
		"status_custinstructed_ip":null,
		"status_custdeclined":"0",
		"status_custdeclined_ip":null,
		"declinereason":"0",
		"reviewdate":"0",
		"sendtype":"0",
		"locked":"0",
		"customer":"4",
		"customer__id":"4",
		"customer__created_user":"1",
		"customer__created_ip":"10.1.1.56",
		"customer__created_date":"1373982893",
		"customer__modified_user":"1",
		"customer__modified_ip":"10.1.1.56",
		"customer__modified_date":"1430919850",
		"customer__record_status":"0",
		"customer__status":"0",
		"customer__status_change_dt":"0",
		"customer__ctype":"0",
		"customer__lastname":"Nudlinger",
		"customer__firstname":"Franz",
		"customer__title":"1",
		"customer__company":"Nudelsoup KG",
		"customer__comboname":"Fa. Nudelsoup KG \/ Herr Franz Nudlinger ",
		"customer__comboname2":null,
		"customer__zip":"0",
		"customer__city":"",
		"customer__street":"",
		"customer__country":"",
		"customer__email":"nudelsoup@example.com",
		"customer__phone":"",
		"customer__mobile":"",
		"customer__fax":"",
		"customer__web":"",
		"customer__vatno":null,
		"customer__code":null,
		"customer__paymenttype":null,
		"customer__paymentinfo":null,
		"customer__annexoffer":null,
		"customer__annexinvoice":null,
		"customer__discount":"0",
		"customer__tax":"0",
		"customer__description":null,
		"customer__istemplate":"0",
		"customer__mainatt":"0",
		"customer__lastcorrespondence":"155",
		"customer__linkurl":null,
		"customer__salesuser":"0",
		"customer__partner":"0",
		"customer__partnerrevenueshare":"0",
		"customer__location":"0",
		"offerpdf":"0",
		"offerpdf__id":null,
		"offerpdf__created_user":null,
		"offerpdf__created_ip":null,
		"offerpdf__created_date":null,
		"offerpdf__modified_user":null,
		"offerpdf__modified_ip":null,
		"offerpdf__modified_date":null,
		"offerpdf__customer":null,
		"offerpdf__positiongroup":null,
		"offerpdf__article":null,
		"offerpdf__offer":null,
		"offerpdf__order":null,
		"offerpdf__invoice":null,
		"offerpdf__dunning":null,
		"offerpdf__position":null,
		"offerpdf__user":null,
		"offerpdf__inoutexpenses":null,
		"offerpdf__settings":null,
		"offerpdf__sysevents":null,
		"offerpdf__direction":null,
		"offerpdf__type":null,
		"offerpdf__code":null,
		"offerpdf__sentdate":null,
		"offerpdf__readdate":null,
		"offerpdf__filename":null,
		"offerpdf__tempname":null,
		"offerpdf__filetype":null,
		"offerpdf__summary":null,
		"offerpdf__description":null,
		"offerpdf__token":null,
		"site_name":"",
		"site_lastname":null,
		"site_firstname":null,
		"site_title":"0",
		"site_company":"Nudelsuppen KG",
		"site_zip":"0",
		"site_city":"",
		"site_street":"",
		"site_country":"",
		"site_email":"",
		"site_phone":"call me other",
		"site_mobile":"",
		"site_fax":"",
		"site_vatno":null,
		"site_discount":"0",
		"site_tax":"0",
		"istemplate":"0",
		"parent":"0",
		"parent__id":null,
		"parent__created_user":null,
		"parent__created_ip":null,
		"parent__created_date":null,
		"parent__modified_user":null,
		"parent__modified_ip":null,
		"parent__modified_date":null,
		"parent__record_status":null,
		"parent__status":null,
		"parent__status_change_dt":null,
		"parent__status_sent":null,
		"parent__status_custinstructed":null,
		"parent__status_custinstructed_ip":null,
		"parent__status_custdeclined":null,
		"parent__status_custdeclined_ip":null,
		"parent__declinereason":null,
		"parent__reviewdate":null,
		"parent__sendtype":null,
		"parent__locked":null,
		"parent__customer":null,
		"parent__offerpdf":null,
		"parent__site_name":null,
		"parent__site_lastname":null,
		"parent__site_firstname":null,
		"parent__site_title":null,
		"parent__site_company":null,
		"parent__site_zip":null,
		"parent__site_city":null,
		"parent__site_street":null,
		"parent__site_country":null,
		"parent__site_email":null,
		"parent__site_phone":null,
		"parent__site_mobile":null,
		"parent__site_fax":null,
		"parent__site_vatno":null,
		"parent__site_discount":null,
		"parent__site_tax":null,
		"parent__istemplate":null,
		"parent__parent":null,
		"parent__newversion":null,
		"parent__price":null,
		"parent__description":null,
		"parent__positionsummary":null,
		"parent__reason":null,
		"parent__annotation":null,
		"parent__startdate":null,
		"parent__mainatt":null,
		"parent__linkurl":null,
		"parent__order":null,
		"parent__invoice":null,
		"parent__partner":null,
		"parent__location":null,
		"newversion":"0",
		"newversion__id":null,
		"newversion__created_user":null,
		"newversion__created_ip":null,
		"newversion__created_date":null,
		"newversion__modified_user":null,
		"newversion__modified_ip":null,
		"newversion__modified_date":null,
		"newversion__record_status":null,
		"newversion__status":null,
		"newversion__status_change_dt":null,
		"newversion__status_sent":null,
		"newversion__status_custinstructed":null,
		"newversion__status_custinstructed_ip":null,
		"newversion__status_custdeclined":null,
		"newversion__status_custdeclined_ip":null,
		"newversion__declinereason":null,
		"newversion__reviewdate":null,
		"newversion__sendtype":null,
		"newversion__locked":null,
		"newversion__customer":null,
		"newversion__offerpdf":null,
		"newversion__site_name":null,
		"newversion__site_lastname":null,
		"newversion__site_firstname":null,
		"newversion__site_title":null,
		"newversion__site_company":null,
		"newversion__site_zip":null,
		"newversion__site_city":null,
		"newversion__site_street":null,
		"newversion__site_country":null,
		"newversion__site_email":null,
		"newversion__site_phone":null,
		"newversion__site_mobile":null,
		"newversion__site_fax":null,
		"newversion__site_vatno":null,
		"newversion__site_discount":null,
		"newversion__site_tax":null,
		"newversion__istemplate":null,
		"newversion__parent":null,
		"newversion__newversion":null,
		"newversion__price":null,
		"newversion__description":null,
		"newversion__positionsummary":null,
		"newversion__reason":null,
		"newversion__annotation":null,
		"newversion__startdate":null,
		"newversion__mainatt":null,
		"newversion__linkurl":null,
		"newversion__order":null,
		"newversion__invoice":null,
		"newversion__partner":null,
		"newversion__location":null,
		"price":"3150.35",
		"description":"",
		"positionsummary":null,
		"reason":null,
		"annotation":null,
		"startdate":"0",
		"mainatt":"0",
		"mainatt__id":null,
		"mainatt__created_user":null,
		"mainatt__created_ip":null,
		"mainatt__created_date":null,
		"mainatt__modified_user":null,
		"mainatt__modified_ip":null,
		"mainatt__modified_date":null,
		"mainatt__customer":null,
		"mainatt__positiongroup":null,
		"mainatt__article":null,
		"mainatt__offer":null,
		"mainatt__order":null,
		"mainatt__invoice":null,
		"mainatt__dunning":null,
		"mainatt__position":null,
		"mainatt__user":null,
		"mainatt__inoutexpenses":null,
		"mainatt__settings":null,
		"mainatt__sysevents":null,
		"mainatt__direction":null,
		"mainatt__type":null,
		"mainatt__code":null,
		"mainatt__sentdate":null,
		"mainatt__readdate":null,
		"mainatt__filename":null,
		"mainatt__tempname":null,
		"mainatt__filetype":null,
		"mainatt__summary":null,
		"mainatt__description":null,
		"mainatt__token":null,
		"linkurl":null,
		"order":"0",
		"order__id":null,
		"order__created_user":null,
		"order__created_ip":null,
		"order__created_date":null,
		"order__modified_user":null,
		"order__modified_ip":null,
		"order__modified_date":null,
		"order__record_status":null,
		"order__status":null,
		"order__status_change_dt":null,
		"order__done_dt":null,
		"order__locked":null,
		"order__customer":null,
		"order__orderpdf":null,
		"order__site_name":null,
		"order__site_lastname":null,
		"order__site_firstname":null,
		"order__site_title":null,
		"order__site_company":null,
		"order__site_zip":null,
		"order__site_city":null,
		"order__site_street":null,
		"order__site_country":null,
		"order__site_email":null,
		"order__site_phone":null,
		"order__site_mobile":null,
		"order__site_fax":null,
		"order__site_vatno":null,
		"order__site_discount":null,
		"order__site_tax":null,
		"order__offer":null,
		"order__parent":null,
		"order__newversion":null,
		"order__price":null,
		"order__description":null,
		"order__positionsummary":null,
		"order__annotation":null,
		"order__startdate":null,
		"order__enddate":null,
		"order__contractenddate":null,
		"order__accountingperiod":null,
		"order__accountingfirstdate":null,
		"order__accountingnextdate":null,
		"order__accounting_dayofmonth":null,
		"order__ackrequired":null,
		"order__lastinvoice":null,
		"order__mainatt":null,
		"order__linkurl":null,
		"order__partner":null,
		"order__location":null,
		"invoice":"0",
		"invoice__id":null,
		"invoice__created_user":null,
		"invoice__created_ip":null,
		"invoice__created_date":null,
		"invoice__modified_user":null,
		"invoice__modified_ip":null,
		"invoice__modified_date":null,
		"invoice__record_status":null,
		"invoice__status":null,
		"invoice__status_change_dt":null,
		"invoice__status_sent":null,
		"invoice__duepayment_dt":null,
		"invoice__invoice_dt":null,
		"invoice__sendtype":null,
		"invoice__paid_dt":null,
		"invoice__locked":null,
		"invoice__customer":null,
		"invoice__invoicepdf":null,
		"invoice__site_name":null,
		"invoice__site_lastname":null,
		"invoice__site_firstname":null,
		"invoice__site_title":null,
		"invoice__site_company":null,
		"invoice__site_zip":null,
		"invoice__site_city":null,
		"invoice__site_street":null,
		"invoice__site_country":null,
		"invoice__site_email":null,
		"invoice__site_phone":null,
		"invoice__site_mobile":null,
		"invoice__site_fax":null,
		"invoice__site_vatno":null,
		"invoice__site_discount":null,
		"invoice__site_tax":null,
		"invoice__offer":null,
		"invoice__order":null,
		"invoice__parent":null,
		"invoice__newversion":null,
		"invoice__dunning":null,
		"invoice__price":null,
		"invoice__description":null,
		"invoice__positionsummary":null,
		"invoice__reason":null,
		"invoice__annotation":null,
		"invoice__mainatt":null,
		"invoice__linkurl":null,
		"invoice__partner":null,
		"invoice__location":null,
		"partner":"0",
		"location":"0",
		"_representationname":"o3  Nudelsuppen KG",
		"created_user___representationname":"admin@example.com (Tester, Chuck)",
		"modified_user___representationname":"admin@example.com (Tester, Chuck)",
		"customer___representationname":"Herr Franz Nudlinger (Nudelsoup KG)",
		"offerpdf___representationname":"attachment:",
		"parent___representationname":"o  ",
		"newversion___representationname":"o  ",
		"mainatt___representationname":"attachment:",
		"order___representationname":"n  ",
		"invoice___representationname":"r  ",
		"__discount_price_subtract":-0,
		"__price_sum":3150.35,
		"__price_sum_wtax":3150.35
	}],
	"count":"470",
	"pages":157,
	"page":0,
	"perpage":"3",
	"errormsg":[]
}