Résumé
Manipulation de l'entité Subcontractor (Sous-traitants) en lecture/écriture/suppression via un objet métier depuis une application externe.
Tables
Les tables utilisées sont :
sw_data_customer : Table des tiers
Les tables liées sont :
sw_data_customerextension : Table des indicateurs tiers
sw_data_customeruser : Table des utilisateurs liés aux tiers
Critères d'activation
WHK_Subcontractor est défini dans la gestion des webhooks du studio.
Règles métier
verb: PUT
Le type de tiers est mis par défaut à ‘Subcontractor' (generictype_ID_customerType = ‘CTS’) si non fourni lors d’une création
Fonctionnement
settings parameters
"settings":
{
"getIndicators": "1" // pour le verb GET et LIST permet de retourner les informations des indicateurs suspects
}
verb: GET
resultType: simple
"subcontractor":{
"codesubcontractor":"ST000001",
"name":"CHEZ SOI",
"baseuser_ID":"TENARDIER",
"address1":"33 Avenue du Drapeau",
"address2":"",
"address3":"",
"postalCode":"21000",
"city":"DIJON",
"phoneNumber":"03 90 11 22 33",
"faxNumber":"03 90 11 22 44",
"mobilePhoneNumber":"06 90 11 22 33",
"email":"contact@guichard.com",
"generictype_ID_country":"FR",
"generictype_ID_province":"",
"generictype_ID_civility":"",
"baseculture_ID":"FR-FR",
"branchoffice_ID":"SXB"
}
verb: GET
resultType: extended
"subcontractor":{
"codesubcontractor":"ST000001",
"name":"CHEZ SOI",
"baseuser_ID":"TENARDIER",
"address1":"33 Avenue du Drapeau",
"address2":"",
"address3":"",
"postalCode":"21000",
"city":"DIJON",
"phoneNumber":"03 90 11 22 33",
"faxNumber":"03 90 11 22 44",
"mobilePhoneNumber":"06 90 11 22 33",
"email":"contact@guichard.com",
"generictype_ID_country":"FR",
"generictype_ID_province":"",
"generictype_ID_civility":"",
"baseculture_ID":"FR-FR",
"branchoffice_ID":"SXB",
"deliveryDays":"1A;1B;2A;2B;3A;3B;4A;4B;5A;5B",
"openingDays":"1A;1B;2A;2B;3A;3B;4A;4B;5A;5B",
"siretNumber":"",
"vatIntra":"",
"apeCode":"516K",
"comment":"",
"blocked":"0",
"blockedComment":"",
"message":"",
"vacationStart":"",
"vacationEnd":"",
"gpsLongitude":"5.04372",
"gpsLatitude":"47.33222",
"accountNumber":"S0000001",
"contactName":"",
"currency_ID":"",
"authorizedCredit":"0",
"risk":"1",
"language":"",
"underSurveillance":"",
"workforce":"25",
"subcontractor_ID_paying":"",
"pricecategory_ID":"",
"discountRate":"0",
"website":"https://www.guichard.com",
"legalStatus":"Société Anonyme avec Directoire",
"generictype_ID_brand":"",
"generictype_ID_deliveryMode":"",
"generictype_ID_paymentMean":"",
"generictype_ID_subcontractorFamily":"",
"generictype_ID_subcontractorType": "CTS",
"confirmationEmail":"contact@guichard.com",
"confirmationFax":"03 90 11 22 44",
"generictype_ID_taxCode":"",
"productdepot_ID":"",
"generictype_ID_accountingCategory":"",
"generictype_ID_subcontractorPotential":"B",
"skype":"contact@guichard.com",
"generictype_ID_role":"",
"unused":"0",
"subcontractorgroup_ID":"",
"generictype_ID_referencing":"2",
"generictype_ID_distribution":"SELF",
"generictype_ID_market":"BIG",
"area":"",
"baseuser_ID_favoriteTechnician":"TECH-01",
"emailFormat":"",
"isIndividual":"0",
"facebook":"https://www.facebook.com/guichard/",
"twitter":"https://twitter.com/guichard",>
"youtube":"https://www.youtube.com/watch?v=6jGbnEwQJ54",
"linkedin":"https://www.linkedin.com/company/guichard",
"activity":""
}
verb: GET
resultType: extendedRelated
en complément du résultat pour resultType: extended on aura le détail pour les tables generictype_subcontractorFamily, baseuser, generictype_country, generictype_province, productdepot, generictype_civility, baseculture, baseuser_favoriteTechnician, branchoffice et productdepot
"related":[
{
"generictype_subcontractorFamily":{
"codegenerictype":"CUSTOMER_FAMILY-Est",
"label":"Grand est",
"originalCode":"Est",
"dataType":"CUSTOMER_FAMILY",
"description":"",
"translationKey":"GenType_CUSTOMER_FAMILY-Est",
"generictype_ID_parent":"",
"tag":"",
"orderNumber":""
},
"baseuser":{
"codebaseuser":"25",
"lastName":"MOREL",
"firstName":"Vincent",
"initials":"MV",
"baseusertree_ID":"Région 2",
"productdepot_ID":"Dépôt Vincent MOREL",
"productdepot_ID_current":"",
"email":"vincent@morel.com",
"phoneNumber":"",
"faxNumber":"",
"address1":"",
"address2":"",
"postalCode":"",
"city":"",
"position":"Représentant",
"department":"Commercial",
"structureNav":"1",
"supervisor":"0",
"useMileageRate":"",
"account":"",
"analyticSection":"",
"lastGPSDate":"",
"gpsLongitude":"",
"gpsLatitude":"",
"gpsPrecision":"",
"gpsUpdateDate":"",
"gpsManual":"",
"generictype_ID_country":"",
"generictype_ID_province":"",
"baseculture_ID":"",
"branchoffice_ID":"",
"resourcetype_ID":"",
"teamtype_ID":""
},
"generictype_country": {
"codegenerictype": "COUNTRY-FR",
"label": "FRANCE",
"originalCode": "FR",
"dataType": "COUNTRY",
"description": "",
"translationKey": "GenType_COUNTRY-FR",
"generictype_ID_parent": "",
"tag": "",
"orderNumber": ""
},
"generictype_province": {
"codegenerictype": "",
"label": "",
"originalCode": "",
"dataType": "",
"description": "",
"translationKey": "",
"generictype_ID_parent": "",
"tag": "",
"orderNumber": ""
},
"baseculture": {
"codebaseculture": "FR-FR",
"label": "French - France",
"codelanguage": "FR"
},
"generictype_civility": {
"codegenerictype": "",
"label": "",
"originalCode": "",
"dataType": "",
"description": "",
"translationKey": "",
"generictype_ID_parent": "",
"tag": "",
"orderNumber": ""
},
"baseuser_favoriteTechnician": {
"codebaseuser": "TECH-01",
"lastName": "TECH-01",
"firstName": "Tango",
"initials": "",
"email": "tech01@test.fr",
"phoneNumber": "",
"faxNumber": "",
"address1": "2 Allée de Strasbourg",
"address2": "",
"postalCode": "91300",
"city": "Massy",
"position": "",
"department": "",
"generictype_ID_country": "",
"generictype_ID_province": "",
"baseculture_ID": "FR-FR",
"branchoffice_ID": "Agence-01",
"resourcetype_ID": "",
"supervisor": "",
"useMileageRate": "",
"account": "",
"analyticSection": "",
"productdepot_ID": "",
"lastGPSDate": "",
"gpsLongitude": "2.2922000000000353",
"gpsLatitude": "48.73596000000003",
"fullView": "",
"changeAuthorization": "",
"productdepot_ID_current": "",
"techSyncRule": "0",
"homePage": "",
"teamtype_ID": "",
"customer_ID_subcontractor": "",
"techIsSedentary": ""
},
"branchoffice": {
"codebranchoffice": "SXB",
"name": "Strasbourg",
"address1": "10 Rue de l'Outre",
"address2": "",
"postalCode": "67000",
"city": "Strasbourg",
"generictype_ID_country": "FR",
"phoneNumber": "0388123456",
"faxNumber": "0388123400",
"email": "noreply-weavysxb@divalto.com",
"website": "",
"bankholidayparamheader_ID": "FRANCE-ALSACE-MOSELLE",
"gpsLongitude": "7.7475",
"gpsLatitude": "48.58367",
"baseusergroup_ID": "#SXB-Strasbourg",
"interventionTeamLifetime": "4"
},
"productdepot": {
"codeproductdepot": "",
"label": "",
"vehicle": "",
"main": "",
"vehicleRegistration": "",
"vehicleBrand": "",
"vehicleModel": "",
"automaticReception": ""
}
}]
verb: GET
resultType: simple, extended, extendedRelated
getIndicators: 1
"suspect": {
...
},
"indicators": [{
"codesubcontractorextension": "30000000493",
"subcontractor_ID": "ST000001",
"dataQualityIndicator": "5", /* Indice qualité*/
"turnoverN": "", /* CA N*/
"turnoverN1": "", /* CA N-1*/
"turnoverN2": "", /* CA N-2*/
"lastOrder": "2019-05-17 08:47:47", /* Dernière commande*/
"lastIntervention": "2020-08-17 15:00:00", /* Dernière intervention*/
"openedContract": "0", /* Contrats en cours*/
"openedQuote": "26", /* Devis en cours*/
"openedOpportunity": "0", /* Opportunités en cours*/
"credit": "", /* Encours*/
"generictype_ID_subcontractorpotential": "B", /* Potentiel suspect*/
"lastVisit": "", /* Dernière visite*/
"companyTurnover": "22839140", /* Dernier chiffre d'affaire*/
"companyTurnoverDate": "2018-11-23 00:00:00", /* Date du dernier chiffre d'affaire*/
"generictype_ID_companyTurnoverSlice": "CA 20 à 50 M€", /* Tranche CA*/
"generictype_ID_companyWorkforceSlice": "Effectif 100 à 199", /* Tranche effectif*/
"companyWorkforce": "180", /* Dernier effectif*/
"companyWorkforceDate": "2018-03-30 00:00:00", /* Date du dernier effectif*/
"anonymizationDate": "", /* Date d'anonymisation*/
"openedTask": "0" /* Tâches en cours*/
}]
verb: PUT
{
"subcontractor": {
"codesubcontractor": "ST000001", /* Code globalement unique du suspect (Varchar (255))*/
"name": "CHEZ SOI", /* Nom du prospect (Varchar (255))*/
"address1": "33 Avenue du Drapeau", /* Adresse 1 (Varchar (255))*/
"address2": null, /* Adresse 2 (Varchar (255))*/
"address3": null, /* Adresse 3 (Varchar (255))*/
"postalCode": "21000", /* Code postal (Varchar (16))*/
"city": "DIJON", /* Ville (Varchar (64))*/
"phoneNumber": "03 90 11 22 33", /* N° de téléphone (Varchar (64))*/
"faxNumber": "03 90 11 22 44", /* N° de télécopie (Varchar (64))*/
"mobilePhoneNumber": "06 90 11 22 33", /* N° de portable (Varchar (64))*/
"email": "contact@guichard.com", /* Email (Varchar (255))*/
"website": "<https://www.guichard.com",> /* Site internet (Varchar (255))*/
"siretNumber": null, /* N° siret (Varchar (40))*/
"generictype_ID_subcontractorType": "CUSTOMER_TYPE-CTS", /* Code type de tiers. Mettre CUSTOMER_TYPE-CTS pour un sous-traitant. (ForeignKey () - sw_data_generictype.codegenerictype avec datatype = CUSTOMER_TYPE). Si non transmis, initialisé par défaut à CTP.*/
"generictype_ID_country": "COUNTRY-FR", /* Code pays (ForeignKey () - sw_data_generictype.codegenerictype avec datatype = COUNTRY)*/
"baseuser_ID": "GRO-OUES", /* Code utilisateur (ForeignKey () - sw_data_baseuser.codebaseuser)*/
"deliveryDays": "1A;1B;2A;2B;3A;3B;4A;4B;5A;5B;", /* Jours de livraison (Varchar (255))*/
"openingDays": "1A;1B;2A;2B;3A;3B;4A;4B;5A;5B;", /* Jours d'ouverture (Varchar (255))*/
"comment": "", /* Commentaires (Text (65535))*/
"blocked": "0", /* Sous-traitant bloqué (Valeurs possibles : 0,1) (Bool ())*/
"blockedComment": "", /* Commentaires sous-traitant bloqué (Text (65535))*/
"message": "", /* Message (Text (65535))*/
"vacationStart": "", /* Début des congés (Date ())*/
"vacationEnd": "", /* Fin des congés (Date ())*/
"underSurveillance": "0", /* Prospect sous surveillance (Valeurs possibles : 0,1) (Bool ())*/
"generictype_ID_subcontractorFamily": "CUSTOMER_FAMILY-GROSARTG", /* Code famille sous-traitant (ForeignKey () - sw_data_generictype.codegenerictype avec datatype = CUSTOMER_FAMILY)*/
"generictype_ID_paymentMean": "PAYMENT_MEAN-N30", /* Code mode de règlement (ForeignKey () - sw_data_generictype.codegenerictype avec datatype = PAYMENT_MEAN)*/
"generictype_ID_deliveryMode": "DELIVERY_MODE-CHRO", /* Code mode de livraison (ForeignKey () - sw_data_generictype.codegenerictype avec datatype = DELIVERY_MODE)*/
"pricecategory_ID": "GR", /* Code catégorie tarifaire (ForeignKey () - sw_data_pricecategory.codepricecategory)*/
"discountRate": "0.00", /* Taux de remise (Double ())*/
"authorizedCredit": "0", /* Encours autorisé (Valeurs possibles : 0,1) (Bool ())*/
"apeCode": "516K", /* Code APE (Varchar (64))*/
"vatIntra": null, /* TVA intracommunautaire (Varchar (64))*/
"legalStatus": "Société Anonyme avec Directoire", /* Forme juridique (Varchar (64))*/
"workforce": "23", /* Effectif (Int ())*/
"suspect_ID_paying": null, /* Code suspect payeur (ForeignKey () - sw_data_customer.codecustomer)*/
"generictype_ID_taxCode": "TAX_CUSTOMER-0", /* Code TVA client (ForeignKey () - sw_data_generictype.codegenerictype avec datatype = TAX_CUSTOMER)*/
"risk": "1", /* Risque (Varchar (64))*/
"language": "FR", /* Code langue (ForeignKey () - sw_sys_language.codelanguage)*/
"accountNumber": "S0000001", /* N° de compte principal (Varchar (64))*/
"currency_ID": "EUR", /* Code devise ForeignKey () - sw_data_currency.codecurrency)*/
"generictype_ID_province": null, /* Code province (ForeignKey () - sw_data_generictype.codegenerictype avec datatype = PROVINCE)*/
"generictype_ID_civility": "CIVILITY-SA", /* Code civilité (ForeignKey () - sw_data_generictype.codegenerictype avec datatype = CIVILITY)*/
"suspectgroup_ID": "", /* Code groupe suspect (ForeignKey () - sw_data_customergroup.codecustomergroup)*/
"confirmationFax": "03 90 11 22 44", /* N° de télécopie de confirmation (Varchar (64))*/
"confirmationEmail": "contact@guichard.com", /* Email de confirmation (Varchar (255))*/
"generictype_ID_accountingCategory": "", /* Code catégorie comptable (ForeignKey () - sw_data_generictype.codegenerictype avec datatype = ACCOUNTING_CATEGORY)*/
"generictype_ID_subcontractorPotential": "CUSTOMER_POTENTIAL-B", /* Code potentiel sous-traitant (ForeignKey () - sw_data_generictype.codegenerictype avec datatype = CUSTOMER_POTENTIAL)*/
"generictype_ID_role": "", /* Code rôle (ForeignKey () - sw_data_generictype.codegenerictype avec datatype = ROLE)*/
"unused": "0", /* Sous-traitant inactif (Valeurs possibles : 0,1) (Bool ())*/
"generictype_ID_referencing": "PRODUCT_REFERENCING-NOTSTRICT", /* Code mode de référencement articles (ForeignKey () - sw_data_generictype.codegenerictype avec datatype = PRODUCT_REFERENCING)*/
"generictype_ID_distribution": "DISTRIBUTION-SELF", /* Code type de distribution (ForeignKey () - sw_data_generictype.codegenerictype avec datatype = DISTRIBUTION)*/
"generictype_ID_market": "MARKET-BIG", /* Code type de magasin (ForeignKey () - sw_data_generictype.codegenerictype avec datatype = MARKET)*/
"area": "", /* Superficie (Double ())*/
"baseculture_ID": "FR-FR", /* Code culture (ForeignKey () - sw_data_baseculture.codebaseculture)*/
"baseuser_ID_favoriteTechnician": "TECH-01", /* Code technicien préféré (ForeignKey () - sw_data_baseuser.codebaseuser)*/
"branchoffice_ID": "SXB", /* Code de l'agence de rattachement (ForeignKey () - sw_data_branchoffice.codebranchoffice)*/
"emailFormat": "", /* Format d'email (Varchar (255))*/
"isIndividual": "0", /* Client est un particulier (Valeurs possibles : 0,1) (Bool ())*/
"skype": "contact@guichard.com", /* Skype (Varchar (255))*/
"facebook": "https://www.facebook.com/guichard/", /* Facebook (Varchar (255))*/
"twitter": "https://twitter.com/guichard", /* Twitter (Varchar (255))*/
"youtube": "https://www.youtube.com/watch?v=6jGbnEwQJ54", /* YouTube (Varchar (255))*/
"linkedin": "https://www.linkedin.com/company/guichard", /* LinkedIn(Varchar (255))*/
"activity": "", /* Activité (Text (65535))*/
"internalcodesucontractor": null, /* CodeSubcontractor original de weavy s'il y a eu transcodage (Varchar (255)) */
/* Champs supplémentaires en surcharge DIVINF */
"divinf_t035_ID": "RG", /* Code remise (ForeignKey () - sw_data_divinf_t035.codedivinf_t035)*/
"divinf_t072_ID_promotacod": "", /* Code promotion (ForeignKey () - sw_data_divinf_t072.codedivinf_t072)*/
"divinf_t072_ID_promoremcod": "", /* Code remise promotion (ForeignKey () - sw_data_divinf_t072.codedivinf_t072)*/
"divinf_t001_ID_tafam": "GMS", /* Code famille de tarification (ForeignKey () - sw_data_divinf_t001.codedivinf_t001)*/
"divinf_t001_ID_tafamx": "", /* Code famille de tarification exceptionnelle (ForeignKey () - sw_data_divinf_t001.codedivinf_t001)*/
"divinf_t002_ID_refam": "", /* Code classe de remise (ForeignKey () - sw_data_divinf_t002.codedivinf_t002)*/
"divinf_t002_ID_refamx": "", /* Code classe de remise exceptionnelle (ForeignKey () - sw_data_divinf_t002.codedivinf_t002)*/
"divinf_rem1": "0.00", /* Remise 1 (Double ())*/
"divinf_rem2": "0.00", /* Remise 2 (Double ())*/
"divinf_rem3": "0.00", /* Remise 3 (Double ())*/
"divinf_remtyp1": "2", /* Type de remise 1 (Valeurs possibles : 1 (Cumulé), 2 (Succesif), 3 (Différé PB), 4 (Différé PN)) (Int ())*/
"divinf_remtyp2": "2", /* Type de remise 2 (Valeurs possibles : 1 (Cumulé), 2 (Succesif), 3 (Différé PB), 4 (Différé PN)) (Int ())*/
"divinf_remtyp3": "2", /* Type de remise 3 (Valeurs possibles : 1 (Cumulé), 2 (Succesif), 3 (Différé PB), 4 (Différé PN)) (Int ())*/
"divinf_pricecategory_ID_tarCod": "", /* Code tarif TTC (ForeignKey () - sw_data_pricecategory.codepricecategory)*/
"divinf_dev": "EUR", /* Code devise (Varchar (64))*/
"divinf_rftctrcod": "1", /* Tiers soumis au référencement (Valeurs possibles : 1 (Non), 2 (Oui)) (Int ())*/
},
"subcontractoruser": [
{
"codesubcontractoruser": "S0000001-95", /* Code globalement unique de l'utilisateur lié au sous-traitant (Varchar (255))*/
"subcontractor_ID": "S0000001", /* Code sous-traitant. Optionnel : reprendre le code sous-traitant du bloc json "suspect", si non fourni reprend automatiquement le code suspect(ForeignKey () - sw_data_customer.codecustomer)*/
"baseuser_ID": "95", /* Code utilisateur (ForeignKey () - sw_data_baseuser.codebaseuser)*/
"generictype_ID_category": "CUSTOMERUSER_LINK-1" /* Code catégorie (ForeignKey () - sw_data_generictype.codegenerictype avec datatype = CUSTOMERUSER-LINK)*/
},
{
"codesubcontractoruser": "S0000001-TECH1",
"subcontractor_ID": "S0000001",
"baseuser_ID": "TECH1",
"generictype_ID_category": "CUSTOMERUSER_LINK-2"
}]
}
verb: LIST
resultType: simple, extended reprendre les définitions du GET
"filters:" {
"codeSubcontractor": "value", filter is equal
"name": "value", filter is contains
"codeSubcontractorFamily": "value", filter is equal
"codeCountry": "value", filter is equal
"codeBaseuser": "value", filter is equal
"codeBranchoffice": "value", filter is equal
"email": "value", filter is equal
"emailDomain": "value", filter is endswith (ie "emailDomain": "@domaine.extension")
"siretNumber": "value", filter is equal
"city": "value", filter is startsWith
"notClosedBefore": "value", filter is (closedDate is null OR closedDate > value)
},
"orderBy": "value"
Valeurs possibles pour le tri "orderBy" :
nameAsc : par nom ascendant
verb: DELETE
La suppression d'un sous-traitant (sw_data_customer) va supprimer en cascade les éléments dans la table liée sw_data_customeruser.