Terug naar website
Je bevindt je momenteel in de helpsectie van onze software, met antwoorden op veelgestelde vragen, handleidingen en hulp bij problemen. Voor volledige toegang tot onze nieuwe website, inclusief al onze producten en diensten, kun je hier klikken om naar de hoofdpagina te gaan.

relations

Geeft van alle actieve relaties die zijn ingevoerd in een bepaalde periode de stamgegevens met adressen, contactpersonen, bedrijfssoorten en vrije relatievelden.

Applicaties

Apps, Webshop-koppelingen, externe applicaties

Aanroep

GET

Parameters

http[s]://<url>:<poort>/odapi/rest/TMethods/relations/[key]/20200206/20200219/json

Naam
Type
Omschrijving
key
Tekst
Sessiesleutel
fromDate
Datum
Vanaf invoerdatum (ccyymmdd)
toDate
Datum
Uiterste invoerdatum (ccyymmdd)
format
json | html
Uitvoerformaat

Query parameters

Naam
Type
Omschrijving
fields
0 | 1
Niet/wel de gegevens van de vrije relatievelden meegeven ?
max
Numeriek
Maximale aantal relaties in de lijst
type
Numeriek
Relatietype van de relaties:
 
127 = klant
 
128 = instantie
 
256 = prospect
 
512 = leverancier
 
1024 = wederverkoper
 
2048 = medewerker
 
4096 = overig
 
8192 = lead
 
(Combineer relatietypen door de waarden op te tellen)
webshop
Numeriek
Webshopnummer

Meldingen

Foutcode
Omschrijving
9041
Ongeldig formaat of inhoud van datum parameter

Voorbeeld

{

    "data": {

        "relations": [

            {

                "relation": {

                    "number": "26348",

                    "shortName": "Verhaas product",

                    "vatNumber": "",

                    "domesticVatNumber": "",

                    "cocNumber": "",

                    "homepage": "www.Verhaasproducts.nl",

                    "relationship": {

                        "types": [

                            "prospect"

                        ]

                    },

                    "currency": {

                        "id": 1,

                        "name": "EUR"

                    },

                    "language": {

                        "id": 1,

                        "code": "nl",

                        "name": "Nederlands"

                    },

                    "region": {

                        "id": 0,

                        "name": "geen",

                        "representative": "",

                        "mechanic": ""

                    },

                    "email": {

                        "address": "info@Verhaasproducts.nl",

                        "html": true,

                        "synchronize": true,

                        "folderMask": "",

                        "addressMask": "",

                        "store": true,

                        "mailCategory": {

                            "id": 0,

                            "name": "",

                            "completed": false

                        }

                    },

                    "customerPayments": {

                        "method": "",

                        "period": 14,

                        "paymentCondition": 0,

                        "deferredDiscount": 0

                    },

                    "collectionOrders": {

                        "period": 14,

                        "type": 1,

                        "typeName": "Algemeen",

                        "characteristic": "",

                        "signed": "20200211",

                        "signedString": "Dinsdag 11 februari",

                        "first": true

                    },

                    "priceAgreements": {

                        "apply": true,

                        "synchronize": false

                    },

                    "priceType": {

                        "id": 0,

                        "name": "Verkoopadviesprijs"

                    },

                    "active": true,

                    "customerProductNumers": false,

                    "columnPricesOrders": true,

                    "columnPrices": false,

                    "columnDiscounts": false,

                    "columnDiscountsInvoice": false,

                    "reminders": {

                        "sendByEmail": false,

                        "useEmailAddress": false,

                        "sendToAccountsPayable": true,

                        "sendToInvoiceContact": false,

                        "email": {

                            "address": ""

                        }

                    },

                    "employee": {

                        "name": "Reinoud Berg"

                    },

                    "created": "20200211",

                    "modified": "20200211",

                    "addresses": [

                        {

                            "address": {

                                "owner": "relation",

                                "number": "26348",

                                "id": 1,

                                "index": 1,

                                "externalId": "",

                                "description": "Standaard adres",

                                "type": "office",

                                "name": "Verhaas Products",

                                "name2": "",

                                "street": "Lagevoortsebos 1",

                                "street2": "",

                                "postalCode": "5298 LA",

                                "city": "Liempde",

                                "state": "",

                                "countryCode": "NL",

                                "countryName": "Nederland",

                                "telephone": "(0411) 63 31 04",

                                "speedDial": "",

                                "fax": "",

                                "mobile": "",

                                "speedDialMobile": "",

                                "kix": "5298LA1",

                                "ean": "",

                                "latitude": 51.5584111,

                                "longitude": 5.3393553

                            }

                        },

                        {

                            "address": {

                                "owner": "relation",

                                "number": "26348",

                                "id": 2,

                                "index": 2,

                                "externalId": "",

                                "description": "Factuuradres",

                                "type": "office",

                                "name": "Verhaas Products",

                                "name2": "",

                                "street": "Lagevoortsebos 1",

                                "street2": "",

                                "postalCode": "5298 LA",

                                "city": "Liempde",

                                "state": "",

                                "countryCode": "NL",

                                "countryName": "Nederland",

                                "telephone": "(0411) 63 31 04",

                                "speedDial": "",

                                "fax": "",

                                "mobile": "",

                                "speedDialMobile": "",

                                "kix": "5298LA1",

                                "ean": "",

                                "latitude": 51.5584111,

                                "longitude": 5.3393553

                            }

                        }

                    ],

                    "contacts": [

                        {

                            "contact": {

                                "number": "26348",

                                "id": 1,

                                "index": 1,

                                "name": "Rogier Biekens ",

                                "firstName": "Rogier",

                                "prefix": "",

                                "lastName": "Biekens ",

                                "gender": "male",

                                "salutation": "",

                                "department": "",

                                "function": "",

                                "characteristic": "",

                                "telephone": "",

                                "privateTelephone": "",

                                "fax": "",

                                "mobile": "",

                                "email": {

                                    "address": "",

                                    "alternative": "",

                                    "synchronize": true

                                },

                                "portalApp": {

                                    "active": false,

                                    "administrator": false,

                                    "password": "",

                                    "notes": false,

                                    "emails": false,

                                    "machines": false,

                                    "workOrders": false,

                                    "quotations": false,

                                    "customerOrders": false,

                                    "deliveryNotes": false,

                                    "salesInvoices": false,

                                    "salesPayments": false,

                                    "preliminaryCustomerOrders": false

                                },

                                "active": true,

                                "accountsPayable": false,

                                "mailings": true

                            }

                        }

                    ],

                    "customerCustomerGroups": [],

                    "webshopCustomers": []

                }

            },

            {

                "relation": {

                    "number": "26349",

                    "shortName": "tekno",

                    "vatNumber": "",

                    "domesticVatNumber": "",

                    "cocNumber": "",

                    "homepage": "www.tekno.nl",

                    "relationship": {

                        "types": [

                            "customer"

                        ],

                        "customerDepartments": [

                            {

                                "department": {

                                    "index": 1,

                                    "code": "O",

                                    "name": "Order-Direct"

                                }

                            }

                        ]

                    },

                    "currency": {

                        "id": 1,

                        "name": "EUR"

                    },

                    "language": {

                        "id": 1,

                        "code": "nl",

                        "name": "Nederlands"

                    },

                    "region": {

                        "id": 0,

                        "name": "geen",

                        "representative": "",

                        "mechanic": ""

                    },

                    "email": {

                        "address": "info@tekno.nl",

                        "html": true,

                        "synchronize": true,

                        "folderMask": "",

                        "addressMask": "",

                        "store": true,

                        "mailCategory": {

                            "id": 0,

                            "name": "",

                            "completed": false

                        }

                    },

                    "customerPayments": {

                        "method": "",

                        "period": 14,

                        "paymentCondition": 0,

                        "deferredDiscount": 0

                    },

                    "collectionOrders": {

                        "period": 14,

                        "type": 1,

                        "typeName": "Algemeen",

                        "characteristic": "",

                        "signed": "20200212",

                        "signedString": "Woensdag 12 februari",

                        "first": true

                    },

                    "priceAgreements": {

                        "apply": true,

                        "synchronize": false

                    },

                    "priceType": {

                        "id": 0,

                        "name": "Verkoopadviesprijs"

                    },

                    "active": true,

                    "customerProductNumers": false,

                    "columnPricesOrders": true,

                    "columnPrices": false,

                    "columnDiscounts": false,

                    "columnDiscountsInvoice": false,

                    "reminders": {

                        "sendByEmail": false,

                        "useEmailAddress": false,

                        "sendToAccountsPayable": true,

                        "sendToInvoiceContact": false,

                        "email": {

                            "address": ""

                        }

                    },

                    "employee": {

                        "name": "Johan van de Broek"

                    },

                    "created": "20200212",

                    "modified": "20200212",

                    "addresses": [

                        {

                            "address": {

                                "owner": "relation",

                                "number": "26349",

                                "id": 1,

                                "index": 1,

                                "externalId": "",

                                "description": "Standaard adres",

                                "type": "office",

                                "name": "Tekno",

                                "name2": "",

                                "street": "Coldenhovelaan 8",

                                "street2": "",

                                "postalCode": "2678 PS",

                                "city": "De Lier",

                                "state": "",

                                "countryCode": "NL",

                                "countryName": "Nederland",

                                "telephone": "(0174) 72 56 32",

                                "speedDial": "",

                                "fax": "",

                                "mobile": "",

                                "speedDialMobile": "",

                                "kix": "2678PS8",

                                "ean": "",

                                "latitude": 51.9549709,

                                "longitude": 4.2384368

                            }

                        },

                        {

                            "address": {

                                "owner": "relation",

                                "number": "26349",

                                "id": 2,

                                "index": 2,

                                "externalId": "",

                                "description": "Factuuradres",

                                "type": "office",

                                "name": "Tekno",

                                "name2": "",

                                "street": "Coldenhovelaan 8",

                                "street2": "",

                                "postalCode": "2678 PS",

                                "city": "De Lier",

                                "state": "",

                                "countryCode": "NL",

                                "countryName": "Nederland",

                                "telephone": "(0174) 72 56 32",

                                "speedDial": "",

                                "fax": "",

                                "mobile": "",

                                "speedDialMobile": "",

                                "kix": "2678PS8",

                                "ean": "",

                                "latitude": 51.9549709,

                                "longitude": 4.2384368

                            }

                        }

                    ],

                    "contacts": [

                        {

                            "contact": {

                                "number": "26349",

                                "id": 1,

                                "index": 1,

                                "name": "Marco",

                                "firstName": "",

                                "prefix": "",

                                "lastName": "",

                                "gender": "male",

                                "salutation": "",

                                "department": "",

                                "function": "",

                                "characteristic": "",

                                "telephone": "",

                                "privateTelephone": "",

                                "fax": "",

                                "mobile": "",

                                "email": {

                                    "address": "",

                                    "alternative": "",

                                    "synchronize": true

                                },

                                "portalApp": {

                                    "active": false,

                                    "administrator": false,

                                    "password": "",

                                    "notes": false,

                                    "emails": false,

                                    "machines": false,

                                    "workOrders": false,

                                    "quotations": false,

                                    "customerOrders": false,

                                    "deliveryNotes": false,

                                    "salesInvoices": false,

                                    "salesPayments": false,

                                    "preliminaryCustomerOrders": false

                                },

                                "active": true,

                                "accountsPayable": false,

                                "mailings": true

                            }

                        },

                        {

                            "contact": {

                                "number": "26349",

                                "id": 2,

                                "index": 2,

                                "name": "Michael",

                                "firstName": "",

                                "prefix": "",

                                "lastName": "",

                                "gender": "male",

                                "salutation": "",

                                "department": "",

                                "function": "",

                                "characteristic": "",

                                "telephone": "",

                                "privateTelephone": "",

                                "fax": "",

                                "mobile": "",

                                "email": {

                                    "address": "",

                                    "alternative": "",

                                    "synchronize": true

                                },

                                "portalApp": {

                                    "active": false,

                                    "administrator": false,

                                    "password": "",

                                    "notes": false,

                                    "emails": false,

                                    "machines": false,

                                    "workOrders": false,

                                    "quotations": false,

                                    "customerOrders": false,

                                    "deliveryNotes": false,

                                    "salesInvoices": false,

                                    "salesPayments": false,

                                    "preliminaryCustomerOrders": false

                                },

                                "active": true,

                                "accountsPayable": false,

                                "mailings": true

                            }

                        }

                    ],

                    "customerCustomerGroups": [],

                    "webshopCustomers": []

                }

            }

        ]

    }

}