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.

relationSearch

Geeft een lijst met de gegevens van alle relaties die voldoen aan een omschrijving. Hierbij wordt gezocht op (een gedeelte van) het relatienummer, sorteernaam, naam, adres, postcode, plaatsnaam en landcode van het standaard adres, e-mailadres, telefoonnummer en mobiele nummer. Er wordt ook exact gezocht op het BTW-nummer van de relatie.

Applicaties

Apps, Webshop-koppelingen, externe applicaties

Aanroep

GET

Parameters

http[s]://<url>:<poort>/odapi/rest/TMethods/relationSearch/[key]/Order-Direct B.V./json

Naam
Type
Omschrijving
key
Tekst
Sessiesleutel
text
Tekst
Tekst waarop moet worden gezocht
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

Geen

Voorbeeld

{

    "data": {

        "relations": [

            {

                "relation": {

                    "number": "10001",

                    "shortName": "order-direct",

                    "vatNumber": "NL8202.81.724.B01",

                    "domesticVatNumber": "",

                    "cocNumber": "12047231",

                    "homepage": "www.order-direct.nl",

                    "relationship": {

                        "types": [

                            "customer",

                            "supplier"

                        ],

                        "customerDepartments": [

                            {

                                "department": {

                                    "index": 1,

                                    "code": "O",

                                    "name": "Order-Direct"

                                }

                            }

                        ],

                        "supplierDepartments": [

                            {

                                "department": {

                                    "index": 1,

                                    "code": "O",

                                    "name": "Order-Direct"

                                }

                            }

                        ]

                    },

                    "currency": {

                        "id": 1,

                        "name": "EUR"

                    },

                    "language": {

                        "id": 1,

                        "code": "nl",

                        "name": "Nederlands"

                    },

                    "region": {

                        "id": 6,

                        "name": "Flevoland",

                        "representative": "Marcel Houtakkers",

                        "mechanic": ""

                    },

                    "email": {

                        "address": "info@order-direct.nl",

                        "html": true,

                        "synchronize": false,

                        "folderMask": "<geen map>",

                        "addressMask": "Johan van de Broek;*@order-direct.nl",

                        "store": false,

                        "mailCategory": {

                            "id": 0,

                            "name": "",

                            "completed": false

                        }

                    },

                    "banking": {

                        "name": "Rabobank",

                        "accountNumber": "1040.94.141",

                        "accountHolderName": "",

                        "accountHolderCity": "",

                        "iban": "NL49 RABO 0104 0941 41",

                        "bic": "RABONL2U",

                        "bankLeitZahl": "34957645",

                        "postalBankAccountNumber": ""

                    },

                    "customerPayments": {

                        "method": "",

                        "period": 30,

                        "paymentCondition": 0,

                        "deferredDiscount": 0

                    },

                    "collectionOrders": {

                        "period": 0,

                        "type": 1,

                        "typeName": "Algemeen",

                        "characteristic": "",

                        "signed": "20091101",

                        "signedString": "Zondag 1 november 2009",

                        "first": true

                    },

                    "priceAgreements": {

                        "apply": true,

                        "synchronize": false

                    },

                    "priceType": {

                        "id": 1,

                        "name": "Handelsprijs"

                    },

                    "active": true,

                    "customerProductNumers": true,

                    "columnPricesOrders": true,

                    "columnPrices": true,

                    "columnDiscounts": false,

                    "columnDiscountsInvoice": false,

                    "reminders": {

                        "sendByEmail": true,

                        "useEmailAddress": false,

                        "sendToAccountsPayable": true,

                        "sendToInvoiceContact": false,

                        "email": {

                            "address": ""

                        }

                    },

                    "employee": {

                        "name": "Jan Automatisering"

                    },

                    "created": "20010905",

                    "modified": "20200128",

                    "addresses": [

                        {

                            "address": {

                                "owner": "relation",

                                "number": "10001",

                                "id": 1,

                                "index": 1,

                                "externalId": "60478",

                                "description": "Standaard adres",

                                "type": "office",

                                "name": "Order-Direct B.V.",

                                "name2": "",

                                "street": "Bolderweg 1",

                                "street2": "",

                                "postalCode": "1332 AX",

                                "city": "Almere",

                                "state": "",

                                "countryCode": "NL",

                                "countryName": "Nederland",

                                "telephone": "(037) 241 55 31",

                                "speedDial": "",

                                "fax": "(036) 547 50 99",

                                "mobile": "",

                                "speedDialMobile": "",

                                "kix": "1332AX1",

                                "ean": "",

                                "latitude": 52.40637,

                                "longitude": 5.2565038

                            }

                        },

                        {

                            "address": {

                                "owner": "relation",

                                "number": "10001",

                                "id": 2,

                                "index": 2,

                                "externalId": "60479",

                                "description": "Factuuradres",

                                "type": "office",

                                "name": "Order-Direct B.V.",

                                "name2": "",

                                "street": "Bolderweg 1",

                                "street2": "",

                                "postalCode": "1332 AX",

                                "city": "Almere",

                                "state": "",

                                "countryCode": "NL",

                                "countryName": "Nederland",

                                "telephone": "(037) 241 55 31",

                                "speedDial": "",

                                "fax": "(036) 547 50 99",

                                "mobile": "",

                                "speedDialMobile": "",

                                "kix": "1332AX1",

                                "ean": "",

                                "latitude": 52.40637,

                                "longitude": 5.2565038

                            }

                        },

                        {

                            "address": {

                                "owner": "relation",

                                "number": "10001",

                                "id": 3,

                                "index": 3,

                                "externalId": "60480",

                                "description": "Filiaal Baexem",

                                "type": "office",

                                "name": "Order-Direct",

                                "name2": "",

                                "street": "Geenraderweg 14",

                                "street2": "",

                                "postalCode": "6095 AR",

                                "city": "Baexem",

                                "state": "",

                                "countryCode": "NL",

                                "countryName": "Nederland",

                                "telephone": "(0475) 38 71 87",

                                "speedDial": "004",

                                "fax": "(0475) 38 71 88",

                                "mobile": "",

                                "speedDialMobile": "",

                                "kix": "6095AR14",

                                "ean": "",

                                "latitude": 51.2214244,

                                "longitude": 5.8839719

                            }

                        },

                        {

                            "address": {

                                "owner": "relation",

                                "number": "10001",

                                "id": 4,

                                "index": 4,

                                "externalId": "60481",

                                "description": "Camping Reinoud",

                                "type": "farm",

                                "name": "Camping Twentse ES",

                                "name2": "",

                                "street": "Keppelerdijk 200",

                                "street2": "",

                                "postalCode": "7534 PA",

                                "city": "Enschede",

                                "state": "",

                                "countryCode": "NL",

                                "countryName": "Nederland",

                                "telephone": "",

                                "speedDial": "",

                                "fax": "",

                                "mobile": "",

                                "speedDialMobile": "",

                                "kix": "7534PA200",

                                "ean": "",

                                "latitude": 52.2100677,

                                "longitude": 6.9515023

                            }

                        }

                    ],

                    "contacts": [

                        {

                            "contact": {

                                "number": "10001",

                                "id": 1,

                                "index": 1,

                                "name": "Johan van de Broek",

                                "firstName": "Jan",

                                "prefix": "van den",

                                "lastName": "Brink",

                                "gender": "male",

                                "salutation": "",

                                "department": "Management",

                                "function": "",

                                "characteristic": "",

                                "telephone": "(063) 31 55 79 12",

                                "privateTelephone": "(036) 537 89 61",

                                "fax": "21",

                                "mobile": "(02) 25 75 81 33",

                                "email": {

                                    "address": "johan@direct.com",

                                    "alternative": "",

                                    "synchronize": true

                                },

                                "portalApp": {

                                    "active": true,

                                    "administrator": true,

                                    "password": "",

                                    "notes": true,

                                    "emails": true,

                                    "machines": true,

                                    "workOrders": true,

                                    "quotations": true,

                                    "customerOrders": true,

                                    "deliveryNotes": true,

                                    "salesInvoices": true,

                                    "salesPayments": true,

                                    "preliminaryCustomerOrders": true

                                },

                                "active": true,

                                "accountsPayable": false,

                                "mailings": false

                            }

                        },

                        {

                            "contact": {

                                "number": "10001",

                                "id": 4,

                                "index": 2,

                                "name": "Reinoud Berg",

                                "firstName": "Reinoud",

                                "prefix": "",

                                "lastName": "Borg",

                                "gender": "male",

                                "salutation": "",

                                "department": "Management",

                                "function": "Directeur",

                                "characteristic": "",

                                "telephone": "(036) 547 50 94",

                                "privateTelephone": "",

                                "fax": "24",

                                "mobile": "(05) 21 12 94 31",

                                "email": {

                                    "address": "reinoud@direct.tv",

                                    "alternative": "",

                                    "synchronize": true

                                },

                                "portalApp": {

                                    "active": true,

                                    "administrator": true,

                                    "password": "",

                                    "notes": true,

                                    "emails": true,

                                    "machines": true,

                                    "workOrders": true,

                                    "quotations": true,

                                    "customerOrders": true,

                                    "deliveryNotes": true,

                                    "salesInvoices": true,

                                    "salesPayments": true,

                                    "preliminaryCustomerOrders": true

                                },

                                "active": true,

                                "accountsPayable": false,

                                "mailings": false

                            }

                        },

                        {

                            "contact": {

                                "number": "10001",

                                "id": 15,

                                "index": 3,

                                "name": "Marcel Houtakkers",

                                "firstName": "Marcel",

                                "prefix": "",

                                "lastName": "Houtakkers",

                                "gender": "male",

                                "salutation": "Geachte heer Houtakkers,",

                                "department": "Support",

                                "function": "",

                                "characteristic": "",

                                "telephone": "",

                                "privateTelephone": "",

                                "fax": "23",

                                "mobile": "(06) 31 55 79 12",

                                "email": {

                                    "address": "Marcel@order-direct.nl",

                                    "alternative": "",

                                    "synchronize": true

                                },

                                "portalApp": {

                                    "active": true,

                                    "administrator": true,

                                    "password": "",

                                    "notes": true,

                                    "emails": true,

                                    "machines": true,

                                    "workOrders": true,

                                    "quotations": true,

                                    "customerOrders": true,

                                    "deliveryNotes": true,

                                    "salesInvoices": true,

                                    "salesPayments": true,

                                    "preliminaryCustomerOrders": true

                                },

                                "active": true,

                                "accountsPayable": false,

                                "mailings": false

                            }

                        },

                        {

                            "contact": {

                                "number": "10001",

                                "id": 5,

                                "index": 6,

                                "name": "Esther Berg",

                                "firstName": "",

                                "prefix": "",

                                "lastName": "",

                                "gender": "female",

                                "salutation": "",

                                "department": "Administratie",

                                "function": "",

                                "characteristic": "",

                                "telephone": "1000",

                                "privateTelephone": "",

                                "fax": "",

                                "mobile": "",

                                "email": {

                                    "address": "esther@computer-direct.nl",

                                    "alternative": "",

                                    "synchronize": true

                                },

                                "portalApp": {

                                    "active": true,

                                    "administrator": false,

                                    "password": "",

                                    "notes": true,

                                    "emails": true,

                                    "machines": false,

                                    "workOrders": false,

                                    "quotations": false,

                                    "customerOrders": false,

                                    "deliveryNotes": false,

                                    "salesInvoices": true,

                                    "salesPayments": false,

                                    "preliminaryCustomerOrders": false

                                },

                                "active": true,

                                "accountsPayable": false,

                                "mailings": false

                            }

                        }

                    ],

                    "customerCustomerGroups": [

                        {

                            "customerCustomerGroup": {

                                "customerGroup": {

                                    "number": "   1",

                                    "code": "",

                                    "description": "Licentie",

                                    "captions": false,

                                    "mainCustomer": {

                                        "number": ""

                                    }

                                },

                                "index": 1,

                                "contact": {

                                    "name": ""

                                }

                            }

                        },

                        {

                            "customerCustomerGroup": {

                                "customerGroup": {

                                    "number": "  14",

                                    "code": "",

                                    "description": "Automatisering",

                                    "captions": false,

                                    "mainCustomer": {

                                        "number": ""

                                    }

                                },

                                "index": 2,

                                "contact": {

                                    "name": ""

                                }

                            }

                        },

                        {

                            "customerCustomerGroup": {

                                "customerGroup": {

                                    "number": "  92",

                                    "code": "",

                                    "description": "Order-Direct gebruiker",

                                    "captions": false,

                                    "mainCustomer": {

                                        "number": ""

                                    }

                                },

                                "index": 3,

                                "contact": {

                                    "name": ""

                                }

                            }

                        },

                        {

                            "customerCustomerGroup": {

                                "customerGroup": {

                                    "number": " 222",

                                    "code": "",

                                    "description": "Versie 11.3 (DEV)",

                                    "captions": true,

                                    "mainCustomer": {

                                        "number": ""

                                    }

                                },

                                "index": 4,

                                "contact": {

                                    "name": ""

                                }

                            }

                        },

                        {

                            "customerCustomerGroup": {

                                "customerGroup": {

                                    "number": " 108",

                                    "code": "",

                                    "description": "SnelStart",

                                    "captions": true,

                                    "mainCustomer": {

                                        "number": ""

                                    }

                                },

                                "index": 5,

                                "contact": {

                                    "name": ""

                                }

                            }

                        },

                        {

                            "customerCustomerGroup": {

                                "customerGroup": {

                                    "number": " 134",

                                    "code": "",

                                    "description": "MySQL",

                                    "captions": true,

                                    "mainCustomer": {

                                        "number": ""

                                    }

                                },

                                "index": 6,

                                "contact": {

                                    "name": ""

                                }

                            }

                        },

                        {

                            "customerCustomerGroup": {

                                "customerGroup": {

                                    "number": " 223",

                                    "code": "",

                                    "description": "Portal",

                                    "captions": true,

                                    "mainCustomer": {

                                        "number": ""

                                    }

                                },

                                "index": 7,

                                "contact": {

                                    "name": ""

                                }

                            }

                        },

                        {

                            "customerCustomerGroup": {

                                "customerGroup": {

                                    "number": " 144",

                                    "code": "",

                                    "description": "WEB-applicatie",

                                    "captions": true,

                                    "mainCustomer": {

                                        "number": ""

                                    }

                                },

                                "index": 8,

                                "contact": {

                                    "name": ""

                                }

                            }

                        }

                    ],

                    "webshopCustomers": [

                        {

                            "webshopCustomer": {

                                "number": "10001",

                                "webshop": {

                                    "id": 1,

                                    "name": "Syveon",

                                    "type": "Syveon",

                                    "default": false

                                },

                                "webshopNumber": "98783456734",

                                "name": "Order-Direct BV",

                                "firstName": "",

                                "prefix": "",

                                "lastName": "Order-Direct BV",

                                "gender": "other",

                                "userName": "info@order-direct.nl",

                                "password": "",

                                "welcomeTextId": 0,

                                "userLevelId": 0,

                                "active": true,

                                "hasWebshopContacts": false,

                                "fixedDeliveryAndPayment": false,

                                "deliveryMethodId": 0,

                                "paymentMethodId": 0

                            }

                        },

                        {

                            "webshopCustomer": {

                                "number": "10001",

                                "webshop": {

                                    "id": 2,

                                    "name": "Order-Direct Live shop",

                                    "type": "CMSpecialist",

                                    "default": true

                                },

                                "webshopNumber": "29350",

                                "name": "Order-Direct",

                                "firstName": "",

                                "prefix": "",

                                "lastName": "Order-Direct",

                                "gender": "other",

                                "userName": "Reinoud",

                                "password": "",

                                "welcomeTextId": 0,

                                "userLevelId": 0,

                                "active": true,

                                "hasWebshopContacts": false,

                                "fixedDeliveryAndPayment": false,

                                "deliveryMethodId": 0,

                                "paymentMethodId": 0

                            }

                        },

                        {

                            "webshopCustomer": {

                                "number": "10001",

                                "webshop": {

                                    "id": 3,

                                    "name": "Testshop tbv. Jopa",

                                    "type": "Agora",

                                    "default": false

                                },

                                "webshopNumber": "66876457",

                                "name": "Order-Direct BV",

                                "firstName": "",

                                "prefix": "",

                                "lastName": "Order-Direct BV",

                                "gender": "other",

                                "userName": "johan@direct.com",

                                "password": "",

                                "welcomeTextId": -1,

                                "userLevelId": -1,

                                "active": true,

                                "hasWebshopContacts": false,

                                "fixedDeliveryAndPayment": false,

                                "deliveryMethodId": 0,

                                "paymentMethodId": 0

                            }

                        }

                    ]

                }

            }

        ]

    }

}