Résumé
Manipulation de l'entité MarketingInbound (Entrants marketing) en lecture/écriture/suppression via un objet métier depuis une application externe.
Tables
Les tables utilisées sont :
sw_data_marketinginbound : Table des entrants marketing
Critères d'activation
WHK_MarketingInbound est défini dans la gestion des webhooks du studio.
Règles métier
verb: PUT
Le statut est mis par défaut à 'Nouveau' (generictype_ID_status = NEW) si non fourni lors d'une création
La date de création est mise par défaut à la date/heure du jour (creationDate) si non fourni lors d'une création
Fonctionnement
verb: GET
resultType: simple
"marketinginbound": {
"codemarketinginbound": "6690000001805",
"generictype_ID_origin": "CHAT",
"label": "Demande échantillons",
"customerName": "ENTREPRISE DIJON GUICHARD",
"generictype_ID_status": "NEW",
"creationDate": "2021-11-26 14:29:51",
"score": ""
}
verb: GET
resultType: extended
"marketinginbound":{
"codemarketinginbound": "6690000001805",
"generictype_ID_origin": "CHAT",
"label": "Demande échantillons",
"customerName": "ENTREPRISE DIJON GUICHARD",
"generictype_ID_status": "NEW",
"creationDate": "2021-11-26 14:29:51",
"score": "",
"generictype_ID_suborigin": "",
"campaign": "Blackweek",
"generictype_ID_civility": "M",
"lastname": "DENEIR",
"firstname": "Jacques",
"email": "jdeneir@nebout.div",
"phoneNumber": "03.04.05.06.07",
"generictype_ID_country": "FR",
"message": "Merci de me fournir un nuancier de couleurs",
"comment": "no comment",
"baseuser_ID_managedBy": "",
"customer_ID": "",
"customercontact_ID": "",
"website": "www.guichard.com"
}
verb: GET
resultType: extendedRelated
en complément du résultat pour resultType: extended on aura le détail pour les tables generictype_origin, generictype_suborigin, generictype_status, generictype_civility, generictype_country, baseuser_managedBy, customer et customercontact
"related": [
{
"generictype_origin":{
"codegenerictype":"MARKETING_INBOUND_ORIGIN-CHAT",
"label":"Chat",
"originalCode":"CHAT",
"dataType":"MARKETING_INBOUND_ORIGIN",
"description":"",
"translationKey":"",
"generictype_ID_parent":"",
"tag":"",
"orderNumber":""
},
"generictype_suborigin":{
"codegenerictype":"",
"label":"Chat",
"originalCode":"",
"dataType":"",
"description":"",
"translationKey":"",
"generictype_ID_parent":"",
"tag":"",
"orderNumber":""
},
"generictype_status":{
"codegenerictype":"MARKETING_INBOUND_STATUS-NEW",
"label":"Nouveau",
"originalCode":"NEW",
"dataType":"MARKETING_INBOUND_STATUS",
"description":"",
"translationKey":"GenType_CIVILITY-M",
"generictype_ID_parent":"",
"tag":"NEW",
"orderNumber":"0"
},
"generictype_civility":{
"codegenerictype":"CIVILITY-M",
"label":"Monsieur",
"originalCode":"M",
"dataType":"CIVILITY",
"description":"",
"translationKey":"GenType_CIVILITY-M",
"generictype_ID_parent":"",
"tag":"",
"orderNumber":""
},
"generictype_country": {
"codegenerictype": "COUNTRY-FR",
"label": "FRANCE",
"originalCode": "FR",
"dataType": "COUNTRY",
"description": "",
"translationKey": "GenType_COUNTRY-FR",
"generictype_ID_parent": "",
"tag": "",
"orderNumber": ""
},
"baseuser_managedBy":{
"codebaseuser": "",
"lastName": "",
"firstName": "",
"initials": "",
"email": "",
"phoneNumber": "",
"faxNumber": "",
"address1": "",
"address2": "",
"postalCode": "",
"city": "",
"position": "",
"department": "",
"generictype_ID_country": "",
"generictype_ID_province": "",
"baseculture_ID": "",
"branchoffice_ID": "",
"resourcetype_ID": "",
"supervisor": "",
"useMileageRate": "",
"account": "",
"analyticSection": "",
"productdepot_ID": "",
"lastGPSDate": "",
"gpsLongitude": "",
"gpsLatitude": "",
"fullView": "",
"changeAuthorization": "",
"productdepot_ID_current": "",
"techSyncRule": "",
"homePage": "",
"teamtype_ID": "",
"customer_ID_subcontractor": ""
},
"customer":{
"codecustomer":"",
"name":"",
"baseuser_ID":"",
"address1":"",
"address2":"",
"address3":"",
"postalCode":"",
"city":"",
"phoneNumber":"",
"faxNumber":"",
"mobilePhoneNumber":"",
"email":"",
"deliveryDays":"",
"openingDays":"",
"siretNumber":"",
"vatIntra":"",
"apeCode":"",
"comment":"",
"blocked":"",
"blockedComment":"",
"message":"",
"vacationStart":"",
"vacationEnd":"",
"gpsLongitude":"",
"gpsLatitude":"",
"gpsPrecision":"",
"gpsUpdateDate":"",
"gpsManual":"",
"accountNumber":"",
"contactName":"",
"currency_ID":"",
"authorizedCredit":"",
"risk":"",
"language":"",
"underSurveillance":"",
"workforce":"25",
"customer_ID_paying":"",
"pricecategory_ID":"",
"discountRate":"",
"website":"",
"legalStatus":"",
"generictype_ID_brand":"",
"generictype_ID_deliveryMode":"",
"generictype_ID_paymentMean":"",
"generictype_ID_country":"",
"generictype_ID_province":"",
"generictype_ID_customerType":"",
"generictype_ID_customerFamily":"",
"confirmationEmail":"",
"confirmationFax":"",
"generictype_ID_taxCode":"",
"productdepot_ID":"",
"generictype_ID_accountingCategory":"",
"generictype_ID_customerPotential":"",
"generictype_ID_civility":"",
"skype":"",
"generictype_ID_role":"",
"unused":"",
"customergroup_ID":"",
"generictype_ID_referencing":"",
"generictype_ID_distribution":"",
"generictype_ID_market":"",
"area":"",
"baseculture_ID":"",
"baseuser_ID_favoriteTechnician":"",
"branchoffice_ID":"",
"emailFormat":"",
"isIndividual":"",
"facebook":"",
"twitter":"",
"youtube":"",
"linkedin":"",
"activity":""
},
"customercontact":{
"codecustomercontact":"",
"customer_ID":"",
"generictype_ID_civility":"",
"lastName":"",
"firstName":"",
"address1":"",
"address2":"",
"address3":"",
"postalCode":"",
"city":"",
"phoneNumber":"",
"faxNumber":"",
"mobilePhoneNumber":"",
"email":"",
"generictype_ID_country":"",
"generictype_ID_province":"",
"baseculture_ID":"",
"gpsLongitude":"",
"gpsLatitude":"",
"description":"",
"generictype_ID_position":"",
"birthday":"",
"mainContact":"",
"generictype_ID_service":"",
"skype":"",
"bouncedEmailDetected":"",
"closedDate":"",
"twitter":"",
"linkedin":""
}
}]
verb: PUT
{
"marketinginbound": {
"codemarketinginbound": "TEST1", /* Code globalement unique de l'entrant marketing (Varchar (255))*/
"creationDate": "2021-11-26", /* Date de création (DateTime ())*/
"generictype_ID_origin": "MARKETING_INBOUND_ORIGIN-CHAT", /* Code origine (ForeignKey () - sw_data_generictype.codegenerictype avec datatype = MARKETING_INBOUND_ORIGIN)*/
"generictype_ID_origin": "", /* Code sous-origine (ForeignKey () - sw_data_generictype.codegenerictype avec datatype = MARKETING_INBOUND_SUBORIGIN)*/
"label": "Demande échantillons", /* Titre (Varchar (255))*/
"campaign": "Blackweek", /* Campagne (Varchar (255))*/
"message": "Merci de me fournir un nuancier de couleurs", /* Message (Text (65535))*/
"score": "", /* Scoring (Int ())*/
"customerName": "ENTREPRISE DIJON GUICHARD", /* Raison sociale (Varchar (255))*/
"website": "www.guichard.com", /* Site web (Varchar (255))*/
"generictype_ID_civility": "CIVILITY-M", /* Code civilité (ForeignKey () - sw_data_generictype.codegenerictype avec datatype = CIVILITY)*/
"lastname": "DENEIR", /* Nom (Varchar (255))*/
"firstname": "Jacques", /* Prénom (Varchar (255))*/
"email": "jrr@divalto.com", /* Email (Varchar (255))*/
"phoneNumber": "03.04.05.06.07", /* N° de téléphone (Varchar (255))*/
"generictype_ID_country": "COUNTRY-FR", /* Code pays (ForeignKey () - sw_data_generictype.codegenerictype avec datatype = COUNTRY)*/
"comment": "no comment", /* Commentaire (Text (65535))*/
"customer_ID": "", /* /* Code tiers (ForeignKey () - sw_data_customer.codecustomer)*/
"customercontact_ID": "" /* Code contact (ForeignKey () - sw_data_customercontact.codecustomercontact)*/
}
}
verb: LIST
resultType: simple, extended reprendre les définitions du GET
"filters:" {
"codeMarketingInbound": "value", filter is equal
"customerName": "value", filter is contains
"label": "value", filter is contains
"campaign": "value", filter is contains
"creationDate": "value", filter is greater or equal to
"creationDateBetween": "value1|value2", filter is between value1 and value2
"codeOrigin": "value", filter is equal
"codeStatus": "value", filter is equal
"score": "value", filter is greater or equal to
},
"orderBy": "value"
Valeurs possibles pour le tri "orderBy" :
creationDateDesc : par date de création descendant
creationDateAsc : par date de création ascendant