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.

relationUpdates

Geeft een lijst met de gegevens van alle relaties die zijn gewijzigd tussen twee datumtijdstippen.

Applicaties

Apps, Webshop-koppelingen, externe applicaties

Aanroep

GET

Parameters

http[s]://<url>:<poort>/odapi/rest/TMethods/relationUpdates/[key]/20200218080000/20200218185900/json

Naam
Type
Omschrijving
key
Tekst
Sessiesleutel
fromDateTime
Datumtijd
Datum/tijdstip (ccyymmddhhnnss[zzz]) vanaf wanneer een relatie is gewijzgd
toDateTime
Datumtijd
Datum/tijdstip (ccyymmddhhnnss[zzz]) tot wanneer een relatie is gewijzgd
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
9042
Ongeldig formaat of inhoud van datum/tijd parameter

Voorbeeld

{

    "data": {

        "relations": [

            {

                "relation": {

                    "number": "26119",

                    "shortName": "van Rems Beeld & Geluid",

                    "vatNumber": "",

                    "domesticVatNumber": "",

                    "cocNumber": "17147697",

                    "homepage": "www.vanrembeeldengeluid.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@vanremsbeeldengeluid.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": "20161026",

                        "signedString": "Woensdag 26 oktober 2016",

                        "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": true,

                        "useEmailAddress": false,

                        "sendToAccountsPayable": true,

                        "sendToInvoiceContact": false,

                        "email": {

                            "address": ""

                        }

                    },

                    "employee": {

                        "name": "Reinoud Berg"

                    },

                    "created": "20161026",

                    "modified": "20191213",

                    "addresses": [

                        {

                            "address": {

                                "owner": "relation",

                                "number": "26119",

                                "id": 1,

                                "index": 1,

                                "externalId": "",

                                "description": "Standaard adres",

                                "type": "office",

                                "name": "Van Rems Beeld & Geluid VOF",

                                "name2": "",

                                "street": "Spegelt 64",

                                "street2": "",

                                "postalCode": "5674 CD",

                                "city": "Zelhem",

                                "state": "",

                                "countryCode": "NL",

                                "countryName": "Nederland",

                                "telephone": "(040) 223 37 90",

                                "speedDial": "",

                                "fax": "(040) 223 37 91",

                                "mobile": "",

                                "speedDialMobile": "",

                                "kix": "5674CD64",

                                "ean": "",

                                "latitude": 51.4640736,

                                "longitude": 5.5339098

                            }

                        },

                        {

                            "address": {

                                "owner": "relation",

                                "number": "26119",

                                "id": 2,

                                "index": 2,

                                "externalId": "",

                                "description": "Factuuradres",

                                "type": "office",

                                "name": "Van Rems Beeld & Geluid VOF",

                                "name2": "",

                                "street": "Spegelt 64",

                                "street2": "",

                                "postalCode": "5674 CD",

                                "city": "Zelhem",

                                "state": "",

                                "countryCode": "NL",

                                "countryName": "Nederland",

                                "telephone": "(040) 223 37 90",

                                "speedDial": "",

                                "fax": "(040) 223 37 91",

                                "mobile": "",

                                "speedDialMobile": "",

                                "kix": "5674CD64",

                                "ean": "",

                                "latitude": 51.4640736,

                                "longitude": 5.5339098

                            }

                        }

                    ],

                    "contacts": [

                        {

                            "contact": {

                                "number": "26119",

                                "id": 1,

                                "index": 1,

                                "name": "Norbert van Rems",

                                "firstName": "Norbert",

                                "prefix": "",

                                "lastName": "van Rems",

                                "gender": "male",

                                "salutation": "",

                                "department": "",

                                "function": "",

                                "characteristic": "",

                                "telephone": "",

                                "privateTelephone": "",

                                "fax": "",

                                "mobile": "(06) 53 77 77 68",

                                "email": {

                                    "address": "robert@vanremsbeeldengeluid.nl",

                                    "alternative": "robertvanrems@gmail.com",

                                    "synchronize": true

                                },

                                "portalApp": {

                                    "active": true,

                                    "administrator": false,

                                    "password": "",

                                    "notes": true,

                                    "emails": false,

                                    "machines": false,

                                    "workOrders": false,

                                    "quotations": false,

                                    "customerOrders": false,

                                    "deliveryNotes": false,

                                    "salesInvoices": true,

                                    "salesPayments": false,

                                    "preliminaryCustomerOrders": false

                                },

                                "active": true,

                                "accountsPayable": true,

                                "mailings": true

                            }

                        },

                        {

                            "contact": {

                                "number": "26119",

                                "id": 2,

                                "index": 2,

                                "name": "Joey Weijtmans",

                                "firstName": "Joey",

                                "prefix": "",

                                "lastName": "Weijtmans",

                                "gender": "male",

                                "salutation": "",

                                "department": "",

                                "function": "",

                                "characteristic": "",

                                "telephone": "",

                                "privateTelephone": "",

                                "fax": "",

                                "mobile": "(06) 43 54 00 44",

                                "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": "26119",

                                "id": 3,

                                "index": 3,

                                "name": "Vincent",

                                "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": "26119",

                                "id": 4,

                                "index": 4,

                                "name": "Kees Reinoldus",

                                "firstName": "Kees",

                                "prefix": "",

                                "lastName": "Reinaldus",

                                "gender": "male",

                                "salutation": "",

                                "department": "",

                                "function": "",

                                "characteristic": "",

                                "telephone": "",

                                "privateTelephone": "",

                                "fax": "",

                                "mobile": "(06) 24 12 26 85",

                                "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": "26119",

                                "id": 5,

                                "index": 5,

                                "name": "Marion Verberne",

                                "firstName": "Marion",

                                "prefix": "",

                                "lastName": "Verberne",

                                "gender": "female",

                                "salutation": "",

                                "department": "",

                                "function": "Boekhouding",

                                "characteristic": "",

                                "telephone": "",

                                "privateTelephone": "",

                                "fax": "",

                                "mobile": "(06) 52 46 36 77",

                                "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": "26119",

                                "id": 6,

                                "index": 6,

                                "name": "Daan (IT Pro ) ",

                                "firstName": "",

                                "prefix": "",

                                "lastName": "",

                                "gender": "male",

                                "salutation": "",

                                "department": "",

                                "function": "",

                                "characteristic": "",

                                "telephone": "(040) 290 69 60",

                                "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": [

                        {

                            "customerCustomerGroup": {

                                "customerGroup": {

                                    "number": "   1",

                                    "code": "",

                                    "description": "Licentie",

                                    "captions": false,

                                    "mainCustomer": {

                                        "number": ""

                                    }

                                },

                                "index": 1,

                                "contact": {

                                    "name": ""

                                }

                            }

                        },

                        {

                            "customerCustomerGroup": {

                                "customerGroup": {

                                    "number": " 215",

                                    "code": "",

                                    "description": "Versie 11.1",

                                    "captions": true,

                                    "mainCustomer": {

                                        "number": ""

                                    }

                                },

                                "index": 2,

                                "contact": {

                                    "name": ""

                                }

                            }

                        },

                        {

                            "customerCustomerGroup": {

                                "customerGroup": {

                                    "number": " 134",

                                    "code": "",

                                    "description": "MySQL",

                                    "captions": true,

                                    "mainCustomer": {

                                        "number": ""

                                    }

                                },

                                "index": 3,

                                "contact": {

                                    "name": ""

                                }

                            }

                        },

                        {

                            "customerCustomerGroup": {

                                "customerGroup": {

                                    "number": " 198",

                                    "code": "",

                                    "description": "Cubesix",

                                    "captions": true,

                                    "mainCustomer": {

                                        "number": "25812"

                                    }

                                },

                                "index": 4,

                                "contact": {

                                    "name": ""

                                }

                            }

                        },

                        {

                            "customerCustomerGroup": {

                                "customerGroup": {

                                    "number": " 205",

                                    "code": "",

                                    "description": "Kerstkaart 2017 (2)",

                                    "captions": false,

                                    "mainCustomer": {

                                        "number": ""

                                    }

                                },

                                "index": 5,

                                "contact": {

                                    "name": ""

                                }

                            }

                        },

                        {

                            "customerCustomerGroup": {

                                "customerGroup": {

                                    "number": " 214",

                                    "code": "",

                                    "description": "Kerstkaart 2018",

                                    "captions": false,

                                    "mainCustomer": {

                                        "number": ""

                                    }

                                },

                                "index": 6,

                                "contact": {

                                    "name": ""

                                }

                            }

                        },

                        {

                            "customerCustomerGroup": {

                                "customerGroup": {

                                    "number": " 140",

                                    "code": "",

                                    "description": "Exact Online",

                                    "captions": true,

                                    "mainCustomer": {

                                        "number": ""

                                    }

                                },

                                "index": 7,

                                "contact": {

                                    "name": ""

                                }

                            }

                        }

                    ],

                    "webshopCustomers": []

                }

            }

        ]

    }

}