Teg KT
- Teg Anmol Singh (Unlicensed)
Topics to be covered -
Whatsapp
Segments Api
Multiple item return.
Whatsapp-
Repo :
https://gitlab.com/eshopbox-team/whatsapp-notifications-webhook-service
Documents:
DataBase:
Staging -
35.200.215.23:3306
wa_staging_user
Boxeshop789
Prod -
35.200.152.248:3306
whatsapp-prod
pAssWt@4761
Documents :
Technical Document || Whatsapp Integration (Gupshup)
Application properties for prod :
ENVIRONMENT = prod
db.dialect = org.hibernate.dialect.MySQLDialect
show.sql = true
dataSourceClassName=com.mysql.jdbc.Driver
dataSource.url = jdbc:mysql://35.200.208.180:3306/eshopbox_wms_production?autoReconnect=true&tcpKeepAlive=true&zeroDateTimeBehavior=convertToNull&useLegacyDatetimeCode=true&serverTimezone=Asia/Kolkata
dataSource.user=inv_engine_user
dataSource.password=gsc912UxpKM64JHE
VERIFY_TOKEN = webhookTest
#integration Engine db
dataSourceClassNameIN=com.mysql.cj.jdbc.Driver
dataSource.urlIN = jdbc:mysql://34.93.213.204:3306/integration_engine_prod?serverTimezone=Asia/Kolkata&zeroDateTimeBehavior=convertToNull
dataSource.userIN=ie_prod_user
dataSource.passwordIN=bzwjBFTGbLLhnMRQ
#whatsapp_database db
dataSourceClassNameWA=com.mysql.cj.jdbc.Driver
dataSource.urlWA=jdbc:mysql://34.93.248.92:3306/whatsapp_notifications_prod_db?serverTimezone=Asia/Kolkata&zeroDateTimeBehavior=convertToNull
dataSource.userWA=whatsapp-prod
dataSource.passwordWA=pAssWt@4761
#POE Notification DB
dataSourceClassNamePoe=com.mysql.cj.jdbc.Driver
dataSource.urlPoe = jdbc:mysql://34.93.248.92:3306/poe_notifications_db_prod?serverTimezone=Asia/Kolkata&zeroDateTimeBehavior=convertToNull
dataSource.userPoe = poe_prod_db_usr
dataSource.passwordPoe = zRd17rSJ9x0F2
serviceName=whatsapp-notifications
ndrResolutionAPIStaging = https://poe-backend-staging.el.r.appspot.com/_ah/api/esb/v2/ndrResolution
ndrResolutionAPIProd = https://poe-backend-prod.el.r.appspot.com/_ah/api/esb/v2/ndrResolution
failedDeliveryTriggerMessageTopic = firstTriggerWhatsAppMessage
dlrStatusAndActionMessages = dlrAndActionWhatsAppStatusMessage
projectId = poe-backend-staging
Curl to trigger or test first msg -
curl --location 'http://localhost:8080/_ah/api/esb/v1/eventListener' \
--header 'Content-Type: application/json' \
--data '{
"message": {
"data": "eyJyZXNvdXJjZSI6InNoaXBtZW50IiwiZXZlbnRUeXBlIjoiUFVUIiwiZXZlbnRTdWJUeXBlIjoiZmFpbGVkX2RlbGl2ZXJ5IiwiYWNjb3VudFNsdWciOiJ2aXRhbWlucGxhbmV0IiwiYWNjb3VudElkIjpudWxsLCJhY3RvciI6IlNZU1RFTSIsInZlcnNpb24iOiJ2MSIsInJlcXVlc3RfZGF0YSI6W10sInJlc3BvbnNlX2RhdGEiOnsiY3VzdG9tZXJPcmRlck51bWJlciI6IjUwMzM3NTIyMzE5OTMiLCJvcmRlclNpdGVJRCI6IiIsInZlbmRvck9yZGVyTnVtYmVyIjoiIzI2MDQiLCJleHRlcm5hbFNoaXBtZW50SUQiOiI1MDMzNzUyMjMxOTkzLTE5NTgtNDQ5NSIsImV4dGVybmFsV2FyZWhvdXNlSUQiOiJFc2hvcGJveF9NdW1iYWlfRkM0IiwiZXh0ZXJuYWxDaGFubmVsSUQiOiJDSDE5NTgiLCJleHRlcm5hbFdtc0NoYW5uZWxOYW1lIjoiSllNIFNVUFBMRU1FTlQgU0NJRU5DRV9WSVRBTUlOUExBTkVUX1hNVU1fNDI2OCIsImV4dGVybmFsX3dtc19jaGFubmVsX2lkIjo0MjY4LCJjaGFubmVsTGFiZWwiOiJKWU0gU3VwcGxlbWVudCBTY2llbmNlIiwiaW50ZWdyYXRpb25UeXBlIjoiNyIsInZlbmRvclBhcnR5SUQiOm51bGwsInBhcnRuZXJfYXMyX2lkIjpudWxsLCJkZWZhdWx0V2FyZWhvdXNlQ29kZSI6IkVzaG9wYm94X011bWJhaV9GQzQiLCJmYWNpbGl0eUxhYmVsIjoiTXVtYmFpIChYTVVNKSIsImZsZXhTdGF0dXMiOiIwIiwiZmFjaWxpdHlUeXBlIjoiYXVwZXJhdG9yIiwib3JkZXJEYXRlIjoiMjAyNC0wOC0zMCAyMjoyODo0OCIsInBvcnRhbF9pZCI6MjcsInBheW1lbnRUeXBlIjoiUmF6b3JwYXkiLCJleHBlY3RlZFNoaXBEYXRlIjoiMjAyNC0wOC0zMSAxMjowMDowMCIsImRpc3BhdGNoQWZ0ZXJEYXRlIjpudWxsLCJleHRlcm5hbE1hbmlmZXN0TnVtYmVyIjpudWxsLCJjaGFubmVsTWFuaWZlc3ROdW1iZXIiOm51bGwsIm9yZGVyX2lkIjo1NTUzMzc0NCwiY2hhbm5lbF9pZCI6MTk1OCwid2FyZWhvdXNlX2lkIjoxMDc2LCJjaGFubmVsX2FjY291bnRfaWQiOjAsImFjY291bnRfaWQiOjM3OSwiY29ubmVjdGlvbklkIjo5NzYsImxvY2F0aW9uSWQiOiI3Mzc4MjI5NjYzMyIsInJlZ2lvbiI6IiIsImlzTWV0cm8iOiIxIiwiaXNTcGVjaWFscGxhY2UiOiIwIiwic2hpcHBpbmdDb25uZWN0aW9uSWQiOjAsInBpY2tsaXN0Q29kZSI6bnVsbCwiaW52b2ljZU51bWJlciI6IklOVlZJVE1KNTM2MiIsImJveFR5cGUiOiJVTktOT1dOIiwiaXNQcmlvcml0eVNoaXBtZW50IjoiMCIsImlzR2lmdCI6IjAiLCJpbnZvaWNlX3VybCI6Imh0dHBzOlwvXC9zdG9yYWdlLmdvb2dsZWFwaXMuY29tXC9pbnZvaWNlZmlsZXMtcHJvZFwvaW52b2ljZVwvNTAzMzc1MjIzMTk5MzE5NTg0NDk1LTE3MjUwMzcxNjQ4NjIucGRmIiwiaW52b2ljZURhdGUiOiIyMDI0LTA4LTMwIDIyOjI5OjIxIiwibGFiZWxfdXJsIjoiaHR0cHM6XC9cL3N0b3JhZ2UuZ29vZ2xlYXBpcy5jb21cL2VzaG9wYm94X3dtc191cGxvYWRzXC9teW50cmFMYWJlbFwvMjAyNDA4MzExMTQxMjYzMzU0NTM4NjQucGRmIiwibGFiZWxzIjoiIiwic2hpcHBpbmdJbmZvIjpbXSwiYm94QWRkaXRpb25hbFJlY29tbWVuZGF0aW9uIjpbXSwiZGltZW5zaW9uX2xlbmd0aCI6IjEzIiwiZGltZW5zaW9uX3dpZHRoIjoiMTMiLCJkaW1lbnNpb25faGVpZ2h0IjoiMTUiLCJ3ZWlnaHQiOiI1ODAiLCJjaGFyZ2VhYmxlV2VpZ2h0IjoiNTgwIiwidHJhY2tpbmdJRCI6IjE3MDQ2MTU3Njg1NTYiLCJ0cmFja2luZ0RvbWFpbiI6IiIsInBhY2thZ2VJRCI6IiIsImJhcmNvZGUiOiIiLCJiYXJjb2RlVHlwZSI6Iml0ZW0iLCJ0YXhBbW91bnQiOjAsInNoaXBDaGFyZ2VBbW91bnQiOjAsImNvdXJpZXJOYW1lIjoiRGVsaGl2ZXJ5IiwiY3BfaWQiOjQsImNyZWF0ZWRfYXQiOiIyMDI0LTA4LTMwIDIyOjI4OjU5IiwidXBkYXRlZF9hdCI6IjIwMjQtMDgtMzEgMTc6MDY6NDYiLCJzdGF0dXMiOiJmYWlsZWRfZGVsaXZlcnkiLCJyZW1hcmtzIjoicmVjaXBpZW50IHdhbnRzIG9wZW4gZGVsaXZlcnkiLCJ3YXJlaG91c2VQaW5jb2RlIjoiNDIxMzAxIiwidGhpcmRQYXJ0eVNoaXBwaW5nIjpmYWxzZSwiY3VzdG9tZXJOYW1lIjoiU2lkZGhhcnRoIEt1bWFyYW4iLCJjdXN0b21lckNvbnRhY3ROdW1iZXIiOiI4MzgzMDAwNzAwIiwiZW1haWwiOiJzaWRkaGFydGgudmtAZ21haWwuY29tIiwiY2hhbm5lbFNsdWciOiJ2aXRhbWlucGxhbmV0MjUiLCJzdGF0dXNfdXBkYXRlZF9hdCI6IjIwMjQtMDktMDYgMjI6Mzk6MDIiLCJzdGF0dXNfbG9nIjp7ImNyZWF0ZWQiOiIyMDI0LTA4LTMwIDIyOjI4OjU5IiwiYWNjZXB0ZWQiOiIyMDI0LTA4LTMwIDIyOjI5OjIwIiwicGlja2VkIjoiMjAyNC0wOC0zMSAwOTozNDo0NSIsInBhY2tlZCI6IjIwMjQtMDgtMzEgMTE6NDE6MjYiLCJkaXNwYXRjaGVkIjoiMjAyNC0wOC0zMSAxNzowNjo0NiIsInBpY2tlZF91cCI6IjIwMjQtMDgtMzEgMTc6MDY6NDciLCJpbnRyYW5zaXQiOiIyMDI0LTA5LTA0IDIyOjQ3OjI4Iiwib3V0X2Zvcl9kZWxpdmVyeSI6IjIwMjQtMDktMDYgMTM6Mjg6MTQiLCJmYWlsZWRfZGVsaXZlcnkiOiIyMDI0LTA5LTA2IDIyOjM5OjAyIiwibmRyX3Jlc29sdXRpb25fc3VibWl0dGVkIjoiMjAyNC0wOS0wNCAyMDo0MDo1NyJ9LCJzdGF0dXNfbG9nX2ZpcnN0X29jY3VycmVuY2UiOnsiZmFpbGVkX2RlbGl2ZXJ5IjoiMjAyNC0wOS0wMyAyMDozODoxNiIsIm91dF9mb3JfZGVsaXZlcnkiOiIyMDI0LTA5LTAzIDEyOjA5OjAwIiwiaW50cmFuc2l0IjoiMjAyNC0wOC0zMSAyMjo0OTo0MSIsIm5kcl9yZXNvbHV0aW9uX3N1Ym1pdHRlZCI6IjIwMjQtMDktMDMgMjA6NDM6MDEiLCJwaWNrZWRfdXAiOiIyMDI0LTA4LTMxIDE3OjA2OjQ3IiwiZGlzcGF0Y2hlZCI6IjIwMjQtMDgtMzEgMTc6MDY6NDYiLCJwYWNrZWQiOiIyMDI0LTA4LTMxIDExOjQxOjI2IiwicGlja2VkIjoiMjAyNC0wOC0zMSAwOTozNDo0NSIsImFjY2VwdGVkIjoiMjAyNC0wOC0zMCAyMjoyOToyMCIsImNyZWF0ZWQiOiIyMDI0LTA4LTMwIDIyOjI4OjU5In0sInN0YXR1c19sb2dfY291bnQiOnsiY3JlYXRlZCI6MSwiYWNjZXB0ZWQiOjEsInBpY2tlZCI6MSwicGFja2VkIjoxLCJkaXNwYXRjaGVkIjoxLCJwaWNrZWRfdXAiOjEsImludHJhbnNpdCI6MjQsIm91dF9mb3JfZGVsaXZlcnkiOjIsImZhaWxlZF9kZWxpdmVyeSI6MiwibmRyX3Jlc29sdXRpb25fc3VibWl0dGVkIjoyfSwic3RhdHVzX2xvZ19pZCI6IjIxNTA3MDk5NSIsIm9yZGVyRXh0ZXJuYWxDcmVhdGVkQXQiOiIyMDI0LTA4LTMwIDIyOjI4OjU1Iiwicmlza1Njb3JlIjoiTG93Iiwicmlza1Njb3JlUmVhc29ucyI6W10sIndlaWdodFByb3RlY3Rpb25TaGllbGRGbGFnIjpmYWxzZSwicGluY29kZVNlcnZpY2VhYmxlUmVtYXJrcyI6IiIsIm9yZGVyQWRkaXRpb25hbEluZm8iOiIiLCJzaGlwcGluZ0FkZHJlc3MiOnsiY3VzdG9tZXJOYW1lIjoiU2lkZGhhcnRoIEt1bWFyYW4iLCJhZGRyZXNzTGluZTEiOiJILTkwNiIsImFkZHJlc3NMaW5lMiI6IkFDQyIsImNpdHkiOiJIeWRlcmFiYWQiLCJzdGF0ZSI6IlRFTEFOR0FOQSIsInBvc3RhbENvZGUiOiI1MDAwMTkiLCJjb3VudHJ5Q29kZSI6IklOIiwiY291bnRyeU5hbWUiOiJJTkRJQSIsImNvbnRhY3RQaG9uZSI6IjgzODMwMDA3MDAiLCJlbWFpbCI6InNpZGRoYXJ0aC52a0BnbWFpbC5jb20ifSwiYmlsbGluZ0FkZHJlc3MiOnsiY3VzdG9tZXJOYW1lIjoiU2lkZGhhcnRoIEt1bWFyYW4iLCJlbWFpbCI6InNpZGRoYXJ0aC52a0BnbWFpbC5jb20iLCJjb250YWN0UGhvbmUiOiI4MzgzMDAwNzAwIn0sIndhcmVob3VzZUFkZHJlc3MiOnsiYWRkcmVzc0xpbmUxIjoiMTlcLzIsIDE5XC8zLCAxOVwvNCwgMTlcLzQsIDE5XC83LCAyNFwvNCAmIDI0XC81IE5SQyBMSU1JVEVEIiwiYWRkcmVzc0xpbmUyIjoiTU9IT05FLCBLQUxZQU4iLCJjaXR5IjoiVGhhbmUiLCJzdGF0ZSI6Ik1haGFyYXNodHJhIiwicG9zdGFsQ29kZSI6IjQyMTMwMSIsImdzdGluIjoiMjdBQUZDQjA0OThSMVpaIn0sInJlY29tbWVuZGVkUGFja2FnZSI6eyJpZCI6MzAxLCJwYWNrYWdlX2lkIjoiVVRYamhjUHM3IiwicGFja2FnZV9jb2RlIjoiVklUMTMxMzE1IiwicGFja2FnZV9kZXNjcmlwdGlvbiI6IlZJVEFNSU4gUExBTkVUIFBMQUlOIEJPWCAgNTAwR00gIDEzIFggMTMgWCAxNC41IENNIiwiYWNjb3VudF9pZCI6Mzc5LCJwYWNrYWdlX3R5cGUiOiJib3giLCJzdGF0dXMiOiJ2ZXJpZmllZCIsInBhY2thZ2VfdmVyaWZpY2F0aW9uIjoiT04iLCJhdmFpbGFiaWxpdHkiOiIxIiwibGVuZ3RoIjoxMywid2lkdGgiOjEzLCJoZWlnaHQiOjE0LjUsInJlamVjdGlvbl9jb2RlcyI6bnVsbCwiZGVhZF93ZWlnaHQiOjg1LCJ2b2x1bWV0cmljX3dlaWdodCI6MC40OTAwOTk5OTk5OTk5OTk5OCwibGVuZ3RoX2ltYWdldXJsIjoiaHR0cHM6XC9cL3N0b3JhZ2UuZ29vZ2xlYXBpcy5jb21cL2VzaG9wYm94X3VwbG9hZHNfcHJvZFwvc2V0dGluZ3NfcGFja2FnaW5nXC9sZWFudGhfNTAwXzI0MDgwMzA3MDcxMDgxMC04Mzc4LmpwZWciLCJ3aWR0aF9pbWFnZXVybCI6Imh0dHBzOlwvXC9zdG9yYWdlLmdvb2dsZWFwaXMuY29tXC9lc2hvcGJveF91cGxvYWRzX3Byb2RcL3NldHRpbmdzX3BhY2thZ2luZ1wvd2VpZ2h0XzUwMF8yNDA4MDMwNzA3MTQ4MTQtNzgzMS5qcGVnIiwiaGVpZ2h0X2ltYWdldXJsIjoiaHR0cHM6XC9cL3N0b3JhZ2UuZ29vZ2xlYXBpcy5jb21cL2VzaG9wYm94X3VwbG9hZHNfcHJvZFwvc2V0dGluZ3NfcGFja2FnaW5nXC81MDBfaGlnaHRfMjQwODAzMDcwNzE3ODE3LTYxMTguanBlZyIsImRlYWRfd2VpZ2h0X2ltYWdldXJsIjoiaHR0cHM6XC9cL3N0b3JhZ2UuZ29vZ2xlYXBpcy5jb21cL2VzaG9wYm94X3VwbG9hZHNfcHJvZFwvc2V0dGluZ3NfcGFja2FnaW5nXC9XaGF0c0FwcF9JbWFnZV8yMDI0MDczMV9hdF8xMi4yNy4wMl9QTV8yNDA4MDMwNzA3Mzg4MzgtNzYzNi5qcGVnIiwiY3JlYXRlZF9hdCI6IjIwMjQtMDctMDMgMTY6MTM6MTMiLCJ1cGRhdGVkX2F0IjoiMjAyNC0wNy0wMyAxNjoxMzoxMyIsInNoaXBtZW50X2FkZGl0aW9uYWxfZGV0YWlsc19pZCI6NjczNzQzLCJ3YXJlaG91c2VSZWNvbW1lbmRlZFBhY2thZ2VJZCI6MCwic2hpcG1lbnRBZGRpdGlvbmFsRGV0YWlsUGFja2FnZSI6eyJzaGlwcGluZ1BhY2thZ2VzIjp7ImRpbWVuc2lvbl9oZWlnaHQiOjE0LjUsInBhY2thZ2VJZCI6IlVUWGpoY1BzNyIsInBhY2thZ2VDb2RlIjoiVklUMTMxMzE1Iiwid2VpZ2h0Ijo1ODAsImRpbWVuc2lvbl93aWR0aCI6MTMsImRpbWVuc2lvbl9sZW5ndGgiOjEzLCJjaGFyZ2VhYmxlV2VpZ2h0Ijo1ODAsIndlaWdodFByb3RlY3Rpb25TaGllbGRGbGFnIjpmYWxzZSwic2hpcHBpbmdNb2RlIjoiRXNob3Bib3ggU3RhbmRhcmQiLCJyZWFzb25Gb3JQYWNrYWdlQ2hhbmdlIjpudWxsLCJ0eXBlIjoiY3VzdG9tIn19fSwiZXNob3Bib3hDb3VyaWVyIjp0cnVlLCJjb3VyaWVyX2FjY291bnQiOiJFU0JfRGVsaGl2ZXJ5X0ZvcndhcmRfNTAwZ19FeHByZXNzIiwic2hpcHBpbmdNb2RlIjoiZXhwcmVzcyIsInRvdGFsSXRlbXNXZWlnaHQiOjQ5NSwicG9ydGFsVXJsIjoiaHR0cHM6XC9cL2VuY3J5cHRlZC10Ym4wLmdzdGF0aWMuY29tXC9pbWFnZXM/cT10Ym46QU5kOUdjU01UVnMwUUFrOHpuMUh5YlZuTVdNS3JYX0Zjb0RkT2pZTHZpZ0hHMzhZNkdTcHhsMm0xeEhBVjdxMUVVeUVnbi1rd3BrJnVzcXA9Q0FVIiwiaWQiOjIzNjQyMDk0LCJvcmRlclRvdGFsIjoyNjEwLCJzdWJUb3RhbCI6MjYxMCwiaXNDT0QiOiIwIiwidHJhY2tfcGF5bG9hZCI6eyJjbGlja1Bvc3RUcmFja0RhdGEiOnsibG9jYXRpb24iOiJIeWRlcmFiYWRfTGluZ2FtcGFsbHlfRCAoVGVsYW5nYW5hKSIsImFkZGl0aW9uYWwiOnsiY291cmllcl9wYXJ0bmVyX2VkZCI6IjIwMjQtMDktMDQiLCJkZXN0aW5hdGlvbl9odWJfaW5zY2FuX3RzIjpudWxsLCJvcmRlcl9pZCI6IjIzNjQyMDk0IiwibGF0ZXN0X3N0YXR1cyI6eyJzdGF0dXMiOiJQZW5kaW5nIiwiY2xpY2twb3N0X3N0YXR1c19kZXNjcmlwdGlvbiI6IkZhaWxlZERlbGl2ZXJ5IiwiY2xpY2twb3N0X3N0YXR1c19idWNrZXQiOjUsInJlZmVyZW5jZV9udW1iZXIiOiIyMzY0MjA5NCIsImNsaWNrcG9zdF9zdGF0dXNfYnVja2V0X2Rlc2NyaXB0aW9uIjoiRmFpbGVkIGRlbGl2ZXJ5IiwicmVtYXJrIjoiUmVjaXBpZW50IHdhbnRzIG9wZW4gZGVsaXZlcnkiLCJ0aW1lc3RhbXAiOiIyMDI0LTA5LTA2VDIyOjM4OjUyWiIsImxvY2F0aW9uIjoiSHlkZXJhYmFkX0xpbmdhbXBhbGx5X0QgKFRlbGFuZ2FuYSkiLCJjbGlja3Bvc3RfY2l0eSI6bnVsbCwiY2xpY2twb3N0X3N0YXR1c19jb2RlIjo5LCJyaWRlcl9uYW1lIjpudWxsLCJyaWRlcl9jb250YWN0IjpudWxsLCJsYXRpdHVkZSI6bnVsbCwibG9uZ2l0dWRlIjpudWxsfSwiaXNfcnZwIjpmYWxzZSwibmRyX3N0YXR1c19jb2RlIjoxMiwibmRyX3N0YXR1c19kZXNjcmlwdGlvbiI6IkN1c3RvbWVyIHdhbnRzIG9wZW4gZGVsaXZlcnkiLCJhY2NvdW50X2NvZGUiOiJFU0JfRGVsaGl2ZXJ5X0ZvcndhcmRfNTAwZ19FeHByZXNzIiwibnByX3N0YXR1c19jb2RlIjpudWxsLCJucHJfc3RhdHVzX2Rlc2NyaXB0aW9uIjpudWxsfSwic3RhdHVzIjoiUGVuZGluZyIsImNsaWNrcG9zdF9jaXR5IjpudWxsLCJjbGlja3Bvc3Rfc3RhdHVzX2NvZGUiOjksImNsaWNrcG9zdF9zdGF0dXNfZGVzY3JpcHRpb24iOiJGYWlsZWREZWxpdmVyeSIsImNwX2lkIjo0LCJyZW1hcmsiOiJSZWNpcGllbnQgd2FudHMgb3BlbiBkZWxpdmVyeSIsImFjY291bnRfY29kZSI6IkVTQl9EZWxoaXZlcnlfRm9yd2FyZF81MDBnX0V4cHJlc3MiLCJ3YXliaWxsIjoiMTcwNDYxNTc2ODU1NiIsInRpbWVzdGFtcCI6IjIwMjQtMDktMDZUMjI6Mzg6NTJaIiwicmlkZXJfbmFtZSI6bnVsbCwicmlkZXJfY29udGFjdCI6bnVsbCwibGF0aXR1ZGUiOm51bGwsImxvbmdpdHVkZSI6bnVsbCwib3RwX2NhbmNlbGxhdGlvbl92ZXJpZmljYXRpb25fZmxhZyI6bnVsbH19LCJhY2NvdW50X3NsdWciOiJ2aXRhbWlucGxhbmV0IiwicGFja2VkX2RhdGUiOiIyMDI0LTA4LTMxIDExOjQxOjI2IiwiaXRlbXNXZWlnaHRQcm90ZWN0aW9uU2hpZWxkRmxhZyI6ZmFsc2UsInByb2R1Y3REaW1lbnNpb25zIjp7Imxlbmd0aCI6MTIuNSwid2lkdGgiOjEyLjUsIndlaWdodCI6NTAwLCJoZWlnaHQiOjEzLjV9LCJpdGVtcyI6W3sib3JkZXJfaXRlbV9pZCI6MzkxODAzMDcsImxpbmVJdGVtU2VxdWVuY2VOdW1iZXIiOjEyNzg2NjQyMjIzMTYxLCJvcmRlckl0ZW1JRCI6IjUwMzM3NTIyMzE5OTMtMzkxODAzMDciLCJpdGVtSUQiOiI0NDQ5NDk1MDM2NzI4OSIsInNrdSI6IjM4U1NLM0g5WkRBIiwiYXNpbiI6IiIsInByb2R1Y3ROYW1lIjoiUFJFIEpZTSBIaWdoIFBlcmZvcm1hbmNlIFByZS1Xb3Jrb3V0ICg2ZyBCQ0FBcyAmIENpdHJ1bGxpbmUgTWFsYXRlLCAyZyBDcmVhdGluZSBIQ0wgJiBCZXRhLUFsYW5pbmUpIiwicXVhbnRpdHkiOjEsIm9yZGVySXRlbUNyZWF0ZWRBdCI6IjIwMjQtMDgtMzAgMjI6Mjg6NTQiLCJjdXN0b21lclByaWNlIjoyNjYwLCJsaW5lSXRlbVRvdGFsIjoyNjEwLCJpbnZvaWNlVG90YWwiOjI2MTAsImNhc2hPbkRlbGl2ZXJ5Q2hhcmdlcyI6MCwiZGlzY291bnQiOjUwLCJ0YXhSYXRlIjowLCJ0YXhBbW91bnQiOjAsImludmVudG9yeUl0ZW1Db2RlIjoiT0QtSUIwMDAzNTEiLCJnaWZ0TWVzc2FnZSI6IiIsImlzR2lmdCI6IjAiLCJnaWZ0TGFiZWxDb250ZW50IjoiIiwibGluZUl0ZW1PcmRlclN0YXR1cyI6IiIsIm9yZGVySXRlbUlEcyI6WyI1MDMzNzUyMjMxOTkzLTM5MTgwMzA3Il0sInByb2R1Y3RJbWFnZVVybCI6Imh0dHBzOlwvXC9jZG4uc2hvcGlmeS5jb21cL3NcL2ZpbGVzXC8xXC8wNTg5XC82Nzc1XC8yNzYxXC9maWxlc1wvUFJFX0pZTV9SMS5wbmc/dj0xNzIwMjUzMjQ4IiwicHJvZHVjdEFkZGl0aW9uYWxJbmZvIjp7InNpemUiOiJUYW5nZXJpbmUiLCJwcm9kdWN0RGV0YWlscyI6eyJ1bml0UHJpY2UiOjM0OTksImhzbkNvZGUiOiIyMTA2MTAiLCJkaW1lbnNpb25IZWlnaHQiOjEzLjUsImRpbWVuc2lvbkxlbmd0aCI6MTIuNSwiZGltZW5zaW9uVW5pdCI6ImNtIiwiZGVzY3JpcHRpb24iOiJKWU0gIFByZSBKWU0gMjAgU2VydmluZ3MgLSBUYW5nZXJpbmUgLSA1MDAgZyIsIndlaWdodCI6NTAwLCJ3ZWlnaHRfZGltZW5zaW9uX3N0YXR1cyI6InVudmVyaWZpZWQiLCJtcnAiOjM0OTksImRpbWVuc2lvbldpZHRoIjoxMi41LCJ0eXBlIjoiQkFTRSIsInZlcnRpY2FsTmFtZSI6Ik51dHJpdGlvbiIsImltYWdlVXJsIjoiaHR0cHM6XC9cL2Nkbi5zaG9waWZ5LmNvbVwvc1wvZmlsZXNcLzFcLzA1ODlcLzY3NzVcLzI3NjFcL2ZpbGVzXC9QUkVfSllNX1IxLnBuZz92dTAwM2QxNzIwMjUzMjQ4IiwiYWNjb3VudFNsdWciOiJ2aXRhbWlucGxhbmV0Iiwic2t1IjoiMTI0MDAwMDAwOTUzOCIsImVzaW4iOiIzOFNTSzNIOVpEQSIsImJyYW5kIjoiSnltIFN1cHBsZW1lbnQgU2NpZW5jZSIsImFkZGl0aW9uYWxOYW1lcyI6eyJlYW4iOiIxMjQwMDAwMDA5NTM4IiwidXBjIjoiMTI0MDAwMDAwOTUzOCIsIm90aGVycyI6WyIxMjQwMDAwMDA5NTM4Il19LCJzdGF0dXMiOiJBQ1RJVkUiLCJ3ZWlnaHRVbml0IjoiZyJ9LCJiYXRjaERldGFpbHMiOnsiZXhwaXJ5RGF0ZSI6Ik1heSAyMiwgMjAyNiwgMTI6MDA6MDAgQU0iLCJ3b3Jrc3BhY2UiOiJ2aXRhbWlucGxhbmV0Iiwic3RvcFNoaXBEYXRlIjoiRmViIDIxLCAyMDI2LCAxMjowMDowMCBBTSIsIml0ZW1zQWRkZWQgYXQiOiJKdWwgNiwgMjAyNCwgMTA6MjA6MTAgQU0iLCJ0aHJlc2hvbGRQZXJpb2QiOjkwLCJiYXRjaGluZ01ldGhvZCI6ImV4cGlyeURhdGUiLCJzY2FubmFibGVJZGVudGlmaWVyIjoiMTI0MDAwMDAwOTUzOCIsImVzaW4iOiIzOFNTSzNIOVpEQSIsImJhdGNoSUQiOiJPRC1CRElEMDAwMDE5IiwiYmF0Y2hpbmdBdmFpbGFiaWxpdHkiOiJFbmFibGVkIiwiaWQiOiI2Njg5MWE1YWYwMDVkNDQ5YTg2MmQ1ZDgifX0sImV4cGVjdGVkRGVsaXZlcnlEYXRlIjoiMjAyNC0wOS0wMyIsInNoaXBwaW5nQ2hhcmdlcyI6MCwicHJvZHVjdFVybCI6bnVsbCwib3JpZ2luYWxPcmRlckl0ZW1JZCI6bnVsbCwiaXNWaXJ0dWFsS2l0IjoiMCIsImNvbXBvbmVudCI6W10sIm9uaG9sZCI6IjAiLCJjYW5jZWxsYXRpb25BZGRpdGlvbmFsUmVhc29uIjoiIiwiY2FuY2VsbGF0aW9uUmVhc29uIjoiIiwiY3VzdG9tZXJPcmRlckl0ZW1JRCI6IiIsInJlY2FsbEJsb2NrZWRJbnZlbnRvcnlVc2VkIjoiIn1dLCJiYWxhbmNlRHVlIjowfSwicHJldmlvdXNfZGF0YSI6W10sInJlc291cmNlX3R5cGUiOiJzaGlwbWVudC51cGRhdGUiLCJhY2NvdW50X3NsdWciOiJ2aXRhbWlucGxhbmV0IiwiY3VzdG9tIjpbXX0="
}
}'
Eshopbox meta account access (Mainly to update/register templates and creating access token) : Mituj, Mayur
Note :Meta Access tokens expire every 2 months
solution - generate new token and update in apps section for eshop account
TriggerMsgAndEventListenerEndPoint → responsible for sending first message from eshopbox to customer
WhatsAppWebhookEndPoint → to process responses from META as well as Customer actions including NDR actions.
Postman collection : https://app.getpostman.com/join-team?invite_code=6be2ce0c419b5f734ef701fb0c74761c&target_code=74a256035f6f74e17ea82c5e46fb61fd
Segments :
Epic : https://auperator.atlassian.net/browse/PLAT-1443
Story : https://auperator.atlassian.net/browse/SHE-3923
Mongo connection string :
mongodb+srv://platform_staging_user:aaSvkZwqa2WSWP36@platform-engine-cluster-yxneo.gcp.mongodb.net/platform_service_staging?retryWrites=true&w=majority
Table- Segments
Repo : https://gitlab.com/eshopbox-team/esb-client-order-return
Frontend - Aman Kumar Singh
Sample curl to create Segments PROD : (API Owner - Muskan Chaudhary)
curl --location 'https://eshop.myeshopbox.com/platform/api/v2/segment' \
--header 'Accept: application/json, text/plain, /' \
--header 'Accept-Language: en-US,en;q=0.9' \
--header 'Authorization: Bearer eyJhbGciOiJSUzI1NiIsInR5cCI6IkpXVCIsImtpZCI6Ik1UaERRamxDUlRJelJVUTRRVU0wUVRJNU1FSkVOVGszUVVFeU5qVXdSa1JDTmpBeU16WTROQSJ9.eyJodHRwczovL2FwcERhdGEiOnt9LCJodHRwczovL3VzZXJEZXRhaWxzIjp7ImlkIjo0ODAwLCJ1c2VyVHlwZSI6ImRlZmF1bHQiLCJlbWFpbCI6InRlZy5zaW5naEBlc2hvcGJveC5jb20ifSwiaHR0cHM6Ly9hY2NvdW50cyI6WyJ0ZXN0ZmMiLCJiYW5nYWxvcmVmYyIsIm11bWJhaWZjIiwiZ3VyZ2FvbmZjIiwieW11bSIsInhjY3UiLCJkbXVtIiwibXVtYmFpdmVsb2NpdHlmY18yIiwiZ3VyZ2FvbmZjXzIiLCJtdW1iYWlmY18yIiwiYmFuZ2Fsb3JlZmNfMiIsImtvbGthdGFmY18yIiwiaHlkZXJhYmFkZmMiLCJkZ2duIiwiZWdnbiIsImZnZ24iLCJ4cG5xIiwiZXNiMDEzZmMiLCJhY2N1Iiwiem11bTIiLCJhaHlkIiwiYWNjdWZjXzIiLCJ5Z2duIiwieG11bSIsImVzaG9wIl0sImh0dHBzOi8vd2FyZWhvdXNlV29ya3NwYWNlcyI6WyJ0ZXN0ZmMiLCJiYW5nYWxvcmVmYyIsIm11bWJhaWZjIiwiZ3VyZ2FvbmZjIiwieW11bSIsInhjY3UiLCJkbXVtIiwibXVtYmFpdmVsb2NpdHlmY18yIiwiZ3VyZ2FvbmZjXzIiLCJtdW1iYWlmY18yIiwiYmFuZ2Fsb3JlZmNfMiIsImtvbGthdGFmY18yIiwiaHlkZXJhYmFkZmMiLCJkZ2duIiwiZWdnbiIsImZnZ24iLCJ4cG5xIiwiZXNiMDEzZmMiLCJhY2N1Iiwiem11bTIiLCJhaHlkIiwiYWNjdWZjXzIiLCJ5Z2duIiwieG11bSJdLCJodHRwczovL3dhcmVob3VzZXMiOltdLCJodHRwczovL3BhcnRuZXJzIjpbXSwiaXNzIjoiaHR0cHM6Ly9lc2hvcGJveC5hdXRoMC5jb20vIiwic3ViIjoiZW1haWx8NjQ2MzEyYjIyN2YxMmVjOTVkMTM3ZWIwIiwiYXVkIjpbImh0dHBzOi8vd21zLm15ZXNob3Bib3guY29tIiwiaHR0cHM6Ly9lc2hvcGJveC5hdXRoMC5jb20vdXNlcmluZm8iXSwiaWF0IjoxNzI0ODM2ODY0LCJleHAiOjE3MjQ5MjMyNjQsInNjb3BlIjoib3BlbmlkIHByb2ZpbGUgZW1haWwiLCJhenAiOiJJSU5KNmtuM0VCRktkMmVURnpNb1lnS2ZobDY1NDAyTCJ9.bwpcvnMFSxMPRjcvaZdyeOgNYJmi01Y626Oa5bQRkjs9kY9-eJsMFdOCt8jlMo97NdOCTnvdeveIfgXl0qzt70OPYqgpzRzUrpHtlx9N4zbNWHZA-20oK2RM6Mz4LSo5xTjmFFYHUGl3KRLECVG5dIbRwhvyjehHEWalH9woMZrRfs9wCxZsyOCcilYL0OGXm3pMe_WwiArdxIKrTucjcQiTlQAKLPSKTNEZL0Y6ag9pFkn2wO-ugajklT4KDX6qpjEFbdyS_fiQRsaSyrzyf6_FySV9a4YC30FNrqpY_9cjSrozJlXc7CW2EbM3cJAWnGUDBz_-NLMbs3cn41S60w' \
--header 'Connection: keep-alive' \
--header 'Origin: https://testingworkspaces.myeshopbox.com ' \
--header 'Referer: https://testingworkspaces.myeshopbox.com/ ' \
--header 'Sec-Fetch-Dest: empty' \
--header 'Sec-Fetch-Mode: cors' \
--header 'Sec-Fetch-Site: same-site' \
--header 'User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Safari/537.36' \
--header 'sec-ch-ua: "Not)A;Brand";v="99", "Google Chrome";v="127", "Chromium";v="127"' \
--header 'sec-ch-ua-mobile: ?0' \
--header 'sec-ch-ua-platform: "Windows"' \
--header 'Author;' \
--header 'Content-Type: application/json' \
--data '{
"buildingBlock": "all-orders",
"core": true,
"dateRangeFilters": [
"orderReceivedOn",
"orderReadyToShipTimestamp",
"orderHandoverDoneTimestamp",
"orderDeliveredTimestamp"
],
"description": "<div class='\''newsegment_tooltip_main'\''>\n <p class='\''descritpion_heading'\''>\n Order items handed over in the last 30 days that are completed.\n </p>\n</div>",
"filter": {
"currentOrderStatus": "is-Handover done,Delivered",
"orderHandoverDoneTimestamp": "last30days-fromDateTOtoDate"
},
"filterQuery": "(orderHandoverDoneTimestamp>=last30days)AND(orderHandoverDoneTimestamp<=toDate)AND( '\''currentOrderStatus'\'':'\''Handover done'\'' OR '\''currentOrderStatus'\'':'\''Delivered'\'' )",
"iconType": "",
"isCore": true,
"moreFilters": [
"orderItemDetails.brand",
"shipmentTrackingDetails.outForDeliveryAttempts",
"orderItemDetails.ean",
"orderItemDetails.esin",
"shipmentTrackingDetails.failedDeliveryAttempts",
"shipmentDetails.invoiceNumber",
"shipmentTrackingDetails.slaResolution",
"orderOutForDeliveryTimestamp",
"shipmentTrackingDetails.delayedDeliveryTag",
"shipmentTrackingDetails.handoverTag",
"orderItemID",
"shipmentDetails.trackingId",
"orderItemDetails.sku",
"vendorOrderNumber",
"riskScore",
"incidentDetails.name",
"customerOrderNumber"
],
"name": "All L",
"primaryFilters": [
"orderDetails.saleChannel",
"shipmentDetails.facilityCode",
"paymentDTO.paidDate",
"paymentDTO.status"
],
"showCount": false,
"slugType": "WORKSPACESLUG",
"sortIndex": 3,
"subGroup": "",
"version": "v2",
"visibleFor": ""
}
'
Curl for Count API:
curl --location 'http://localhost:8080/_ah/api/esb/v1/orders/count' \
--header 'Authorization: Bearer eyJhbGciOiJSUzI1NiIsInR5cCI6IkpXVCIsImtpZCI6IlJVVXdSREZCUVRSRFFqQkdORFUxTVVZeE16ZEdPRFJHTnpORk5EaEJSVEU0TVVORk5qVTJOdyJ9.eyJodHRwczovL2FwcERhdGEiOnt9LCJodHRwczovL2FjY291bnRzIjpbInFhc3RhZ2luZzIwMjMiLCJxYXN0YWdpbmdibHIwMDEiLCJxYXN0YWdpbmd2dDAyIiwicWFzdGFnaW5ndnQwMyIsInFhc3RhZ2luZ3Z0MDQiLCJxYXN0YWdpbmd0MDEiLCJxYXN0YWdpbmdzY2RqYyIsInFhc3RhZ2luZ3VuaXQwMDFtZiIsInFhc3RhZ2luZ3Bzb3Bsb2N1bml0bGV2ZWwiLCJxYXN0YWdpbmdwc29wbG9jc2t1bGV2ZWxzcCIsInFhc3RhZ2luZ3Bzb3Bsb2Nza3VsZXZlbGRicCIsInFhc3RhZ2luZ3Bzb3BuZG1pIiwicWFzdGFnaW5nY2huY2UiLCJxYXN0YWdpbmdwc29wdW5pdGxldmVsIiwicWFzdGFnaW5nYmJzcjAxIiwicWFzdGFnaW5nMTAwMjAwIiwicWFzdGFnaW5nYmFtIiwicWFzdGFnaW5na2h1IiwicWFzdGFnaW5nc3MwMSIsInFhc3RhZ2luZ2N0YyIsInFhc3RhZ2luZzEwMDMwMCIsInFhc3RhZ2luZzEwMDQwMCIsInFhc3RhZ2luZ3NzMDIiLCJxYXN0YWdpbmdzczAzIiwicWFzdGFnaW5nY2tsIiwicWFzdGFnaW5nZ25nIiwicWFzdGFnaW5nYW52bSIsInFhc3RhZ2luZ2JoZCIsInFhc3RhZ2luZzEwMDIwMGRvbm90bWlsb2MiLCJxYXN0YWdpbmc0MDA1MDBza3VsZXZlbGxvYyIsInFhc3RhZ2luZzUwMDYwMHVuaXRsZXZlbGxvYyIsInFhc3RhZ2luZ3NzMDQiLCJxYXN0YWdpbmdzZHMiLCJxYXN0YWdpbmdkbm0wMSIsInFhc3RhZ2luZ2h5ZGVyYWJhZDAyIiwicWFzdGFnaW5nbG9jMDEiLCJxYXN0YWdpbmdsb2MwMiIsInFhc3RhZ2luZ3B1bmVkbWkiLCJxYXN0YWdpbmdwdW5lc2t1IiwicWFzdGFnaW5ncHVuZXVuaXQiLCJxYXN0YWdpbmd1bml0bGV2bDEyMDAiLCJxYXN0YWdpbmd2aXphZ3VuaXRsZXZsMDA4OCIsInFhc3RhZ2luZ2RubWk1NTQ0IiwicWFzdGFnaW5nc2t1c3A2Njc3IiwicWFzdGFnaW5ndW5pdGxldmVsODg5OSIsInFhc3RhZ2luZ3Rlc3Rpbmdsb2NhdGlvbmZpbHRlciIsInFhc3RhZ2luZyJdLCJodHRwczovL3dhcmVob3VzZVdvcmtzcGFjZXMiOlsicWFzdGFnaW5nMjAyMyIsInFhc3RhZ2luZ2JscjAwMSIsInFhc3RhZ2luZ3Z0MDIiLCJxYXN0YWdpbmd2dDAzIiwicWFzdGFnaW5ndnQwNCIsInFhc3RhZ2luZ3QwMSIsInFhc3RhZ2luZ3NjZGpjIiwicWFzdGFnaW5ndW5pdDAwMW1mIiwicWFzdGFnaW5ncHNvcGxvY3VuaXRsZXZlbCIsInFhc3RhZ2luZ3Bzb3Bsb2Nza3VsZXZlbHNwIiwicWFzdGFnaW5ncHNvcGxvY3NrdWxldmVsZGJwIiwicWFzdGFnaW5ncHNvcG5kbWkiLCJxYXN0YWdpbmdjaG5jZSIsInFhc3RhZ2luZ3Bzb3B1bml0bGV2ZWwiLCJxYXN0YWdpbmdiYnNyMDEiLCJxYXN0YWdpbmcxMDAyMDAiLCJxYXN0YWdpbmdiYW0iLCJxYXN0YWdpbmdraHUiLCJxYXN0YWdpbmdzczAxIiwicWFzdGFnaW5nY3RjIiwicWFzdGFnaW5nMTAwMzAwIiwicWFzdGFnaW5nMTAwNDAwIiwicWFzdGFnaW5nc3MwMiIsInFhc3RhZ2luZ3NzMDMiLCJxYXN0YWdpbmdja2wiLCJxYXN0YWdpbmdnbmciLCJxYXN0YWdpbmdhbnZtIiwicWFzdGFnaW5nYmhkIiwicWFzdGFnaW5nMTAwMjAwZG9ub3RtaWxvYyIsInFhc3RhZ2luZzQwMDUwMHNrdWxldmVsbG9jIiwicWFzdGFnaW5nNTAwNjAwdW5pdGxldmVsbG9jIiwicWFzdGFnaW5nc3MwNCIsInFhc3RhZ2luZ3NkcyIsInFhc3RhZ2luZ2RubTAxIiwicWFzdGFnaW5naHlkZXJhYmFkMDIiLCJxYXN0YWdpbmdsb2MwMSIsInFhc3RhZ2luZ2xvYzAyIiwicWFzdGFnaW5ncHVuZWRtaSIsInFhc3RhZ2luZ3B1bmVza3UiLCJxYXN0YWdpbmdwdW5ldW5pdCIsInFhc3RhZ2luZ3VuaXRsZXZsMTIwMCIsInFhc3RhZ2luZ3ZpemFndW5pdGxldmwwMDg4IiwicWFzdGFnaW5nZG5taTU1NDQiLCJxYXN0YWdpbmdza3VzcDY2NzciLCJxYXN0YWdpbmd1bml0bGV2ZWw4ODk5IiwicWFzdGFnaW5ndGVzdGluZ2xvY2F0aW9uZmlsdGVyIiwicWFzdGFnaW5nIl0sImh0dHBzOi8vd2FyZWhvdXNlcyI6W10sImh0dHBzOi8vcGFydG5lcnMiOltdLCJodHRwczovL3VzZXJEZXRhaWxzIjp7ImVtYWlsIjoidGVnLnNpbmdoQGVzaG9wYm94LmNvbSIsImlkIjoyOTc2LCJ1c2VyVHlwZSI6ImRlZmF1bHQifSwiaXNzIjoiaHR0cHM6Ly9sb2dpbi5hdXBlcmF0b3IuY28vIiwic3ViIjoiZW1haWx8NjQ1ZTIwMGFjNmNlYmEwNDI3ZTYyZjdiIiwiYXVkIjpbImh0dHBzOi8vZXNob3Bib3gtcG9ydGFsLWRldi5hcHBzcG90LmNvbSIsImh0dHBzOi8vZXNob3Bib3gtcGF5bWVudC1yZWNvLmF1dGgwLmNvbS91c2VyaW5mbyJdLCJpYXQiOjE3MjMwOTU4MTYsImV4cCI6MTcyMzE4MjIxNCwic2NvcGUiOiJvcGVuaWQgcHJvZmlsZSBlbWFpbCIsImF6cCI6IlRTSDJUWHg3V3ZmeDZocHBJRmZ6bDVjYjFNR3F2OVZwIn0.MJswZkmIVGXAa2qXEVftQlYG05Bnicfw55uIal2qQiZpESOVpEZqQfgz8B2sea_dYsoHRp3U6caxpQzd_SFJRVToRmcF9gScPi9zvpamwIPyxF2XdDH7Ud31kIU9MdTmZIXfz0GnAnc9vxB0YNHTyVYnpxMFGNVCv0iFG9r7uaCSx6Nrhdyv-EK5Zt62mx3fr54QzhEgf6TqVHTtDAEdXset4SbCAh-BnzSNVPL5M_O32dyJ9VRJytG_o2DJD6VtVY-twp0fNHyIUJvELleizEQXv7aUKwUzQXDKKhvbp8NN7Sw_rlTWs3hZZceOsg_LMVSmT60Ih14x49bBDcmrGA' \
--header 'account_slug: qastaging' \
--header 'Content-Type: application/json' \
--data '{
"filterQuery": {
"6659ae59ac927c4a68037eb2": "(orderReceivedOn>=1701887400000)AND(orderReceivedOn<=1717439399999)AND( '\''currentOrderStatus'\'':'\''Processing'\'' )AND( '\''shipmentDetails.failedToRts'\'':'\''Yes'\'' )",
"6659aebdac927c4a68037eb3": "(orderReceivedOn>=1701887400000)AND(orderReceivedOn<=1717439399999)AND( '\''currentOrderStatus'\'':'\''Processing'\'' )AND( '\''shipmentDetails.failedToHandover'\'':'\''Yes'\'' )",
"6659af44ac927c4a68037eb4": "(orderReceivedOn>=1701887400000)AND(orderReceivedOn<=1717439399999)AND ('\''shipmentDetails.pickUpFailed'\'':'\''Yes'\'' )",
"6659af5aac927c4a68037eb5": "(orderReceivedOn>=1701887400000)AND(orderReceivedOn<=1717439399999)AND ('\''currentOrderStatus'\'':'\''New'\'' )AND ('\''currentOrderStatus'\'':'\''Processing'\'' )AND(expectedShipDate < 1717353000000)",
"6659af6dac927c4a68037eb6": "(orderReceivedOn>=1701887400000)AND(orderReceivedOn<=1717439399999)AND ('\''currentOrderStatus'\'':'\''Ready To Ship'\'' ) AND ('\''shipmentTrackingDetails.expectedHandoverDate'\'' < 1717353000000)"
}
}'
Response:
{
"6659aebdac927c4a68037eb3": "0",
"6659ae34ac927c4a68037eb0": "6",
"6659c4ecaa923f6e6a24c503": "0",
"6659af5aac927c4a68037eb5": "0",
"6659c503aa923f6e6a24c504": "1",
"Algolia time": "2297",
"Total Time": "2297",
"6659ada297506e03871ce751": "39",
"6659af6dac927c4a68037eb6": "1702",
"Total filters ": 31,
"6659ae47ac927c4a68037eb1": "0",
"6659c4d4aa923f6e6a24c502": "7",
"6659ae1097506e03871ce752": "15",
"updated_at": "2024-10-14 11:14:24",
"6659c5925ee8b260ee91e042": "1",
"6659ae59ac927c4a68037eb2": "171",
"6659c5a15ee8b260ee91e043": "9",
"6659c5695ee8b260ee91e041": "2",
"6659af44ac927c4a68037eb4": "3",
"6659c4afaa923f6e6a24c501": "58",
"Total segments ": 17
}
check filter query validity : Filters and boolean operators | Algolia
Algolia : Algolia
For access contact Mituj
Postman collection : https://app.getpostman.com/join-team?invite_code=6be2ce0c419b5f734ef701fb0c74761c&target_code=f4e35e371a2a5784c0598889e6ba9d97
Shipmentcount is on staging and Rushikesh is working on it :
Branch : Feature/OrderCount
Endpoint : 'http://localhost:8080/_ah/api/esb/v1/orders/shipmentCount'
Request :
{
"filterQuery": {
"61d2d83019e2b31cf7d350a1": "shipmentDetails.facilityCode : 'Eshopbox_Gurgaon_FC3' AND( 'currentOrderStatus':'Ready to ship' )AND( 'shipmentDetails.courierName':'xpressbees' ) ",
"61d2d83019e2b31cf7d350a2": "(orderReceivedOn >= 1722796200000) AND (orderReceivedOn <= 1725388199999)AND( 'currentOrderStatus':'On the way' )",
"61d2d83019e2b31cf7d350a3" : "(returns.returnDetails.createdOnTimestamp>=1711823400000)AND(returns.returnDetails.createdOnTimestamp<=1714415399999)"
}
}
Response:
{
"Total time ": "2554",
"updated_at": "2024-09-19 18:37:53",
"61d2d83019e2b31cf7d350a1": {
"filter": "shipmentDetails.facilityCode : 'Eshopbox_Gurgaon_FC3' AND( 'currentOrderStatus':'Ready to ship' )AND( 'shipmentDetails.courierName':'xpressbees' ) AND account : tcns",
"Total time": "876",
"Total shipments": 10816
},
"Total Time": "2554",
"61d2d83019e2b31cf7d350a3": {
"filter": "(returns.returnDetails.createdOnTimestamp>=1711823400000)AND(returns.returnDetails.createdOnTimestamp<=1714415399999) AND account : tcns",
"Total time": "1657",
"Total shipments": 23550
},
"61d2d83019e2b31cf7d350a2": {
"filter": "(orderReceivedOn >= 1722796200000) AND (orderReceivedOn <= 1725388199999)AND( 'currentOrderStatus':'On the way' ) AND account : tcns",
"Total time": "21",
"Total shipments": 0
}
}
New filters API:
curl --location 'http://localhost:8080/_ah/api/esb/v2/orders/filtersNew' \
--header 'Authorization: Bearer eyJhbGciOiJSUzI1NiIsInR5cCI6IkpXVCIsImtpZCI6IlJVVXdSREZCUVRSRFFqQkdORFUxTVVZeE16ZEdPRFJHTnpORk5EaEJSVEU0TVVORk5qVTJOdyJ9.eyJodHRwczovL2FwcERhdGEiOnt9LCJodHRwczovL3VzZXJEZXRhaWxzIjp7ImlkIjoyOTc2LCJ1c2VyVHlwZSI6ImRlZmF1bHQiLCJlbWFpbCI6InRlZy5zaW5naEBlc2hvcGJveC5jb20ifSwiaHR0cHM6Ly9hY2NvdW50cyI6WyJkZmNkZWwxMDEiLCJkZmNtdW0xMDEiLCJkZmNna3AxMDEiLCJkZmN1dDEwMSIsImRmY2oxMDEiLCJkZmNrMTAxIiwiZGZja2FyMTAxIiwiZGZjZGVsaGkiLCJkZmNuZGwwMDEiLCJkZmNuZXdwaW5jb2RlY2hlY2siLCJkZmNlZGl0cGluY29kZTEzMTIzIiwiZGZjcmVkciIsImRmY2RlcnQiLCJkZmNuZXdsb2NhdGlvbmhpbnVzIiwiZGZjdGVzdGRmYzEzMTIiLCJkZmNjdnl0IiwiZGZjdGVzdGNhc2UyIiwiZGZjdGVzdGNhc2UzIiwiZGZjdGVzdCIsImRmY3Rlc3RicmFuZGV3aGZpdyIsImRmY3ZjZGUiLCJkZmN0ZXN0bmFneWEiLCJkZmN0cnRyIiwiZGZjdGVzdHJha3VsMTIzMiIsImRmY2Vld3EiLCJkZmNvb2xpIiwiZGZjdGVzdGRlbHJ5IiwiZGZjd2hhdHNhcHBkZmMiLCJkZmN0ZWcxIiwiZGZjZ2FuZXNoZmMiLCJkZmN0ZXN0ZGZjcmF3IiwiZGZjdW5pdGxldmVsbG9jYXRpb25zIiwiZGZjbXVtMDEiLCJkZmNiYWcwMiIsImRmY211bTAyIiwiZGZjbmV3dGVzdDEwMSIsImRmY211bWJhaTEwMSIsImRmY2RlbGgxMTAyIiwiZGZjIl0sImh0dHBzOi8vd2FyZWhvdXNlV29ya3NwYWNlcyI6WyJkZmNkZWwxMDEiLCJkZmNtdW0xMDEiLCJkZmNna3AxMDEiLCJkZmN1dDEwMSIsImRmY2oxMDEiLCJkZmNrMTAxIiwiZGZja2FyMTAxIiwiZGZjZGVsaGkiLCJkZmNuZGwwMDEiLCJkZmNuZXdwaW5jb2RlY2hlY2siLCJkZmNlZGl0cGluY29kZTEzMTIzIiwiZGZjcmVkciIsImRmY2RlcnQiLCJkZmNuZXdsb2NhdGlvbmhpbnVzIiwiZGZjdGVzdGRmYzEzMTIiLCJkZmNjdnl0IiwiZGZjdGVzdGNhc2UyIiwiZGZjdGVzdGNhc2UzIiwiZGZjdGVzdCIsImRmY3Rlc3RicmFuZGV3aGZpdyIsImRmY3ZjZGUiLCJkZmN0ZXN0bmFneWEiLCJkZmN0cnRyIiwiZGZjdGVzdHJha3VsMTIzMiIsImRmY2Vld3EiLCJkZmNvb2xpIiwiZGZjdGVzdGRlbHJ5IiwiZGZjd2hhdHNhcHBkZmMiLCJkZmN0ZWcxIiwiZGZjZ2FuZXNoZmMiLCJkZmN0ZXN0ZGZjcmF3IiwiZGZjdW5pdGxldmVsbG9jYXRpb25zIiwiZGZjbXVtMDEiLCJkZmNiYWcwMiIsImRmY211bTAyIiwiZGZjbmV3dGVzdDEwMSIsImRmY211bWJhaTEwMSIsImRmY2RlbGgxMTAyIl0sImh0dHBzOi8vd2FyZWhvdXNlcyI6W10sImh0dHBzOi8vcGFydG5lcnMiOltdLCJpc3MiOiJodHRwczovL2VzaG9wYm94LXBheW1lbnQtcmVjby5hdXRoMC5jb20vIiwic3ViIjoiZW1haWx8NjQ1ZTIwMGFjNmNlYmEwNDI3ZTYyZjdiIiwiYXVkIjpbImh0dHBzOi8vZXNob3Bib3gtcG9ydGFsLWRldi5hcHBzcG90LmNvbSIsImh0dHBzOi8vZXNob3Bib3gtcGF5bWVudC1yZWNvLmF1dGgwLmNvbS91c2VyaW5mbyJdLCJpYXQiOjE3MTA3NDgyOTksImV4cCI6MTcxMDgzNDY5NywiYXpwIjoiVFNIMlRYeDdXdmZ4NmhwcElGZnpsNWNiMU1HcXY5VnAiLCJzY29wZSI6Im9wZW5pZCBwcm9maWxlIGVtYWlsIn0.Q7IgXOhr2aCU4Csdq2Ego_RdpnIK8TofYYaJkye6VJ0saxo_xU4NeLpUYbFxoLpLlMHlb4hABJ8UwUPBm9ffHtjFoXfJQ2Ksbz0f1CwdVyEA4b3WuiwFBFnq0rN0WAemSau_tGnYBZX6Puz4CbmchjPbrrij7Ky5oJBfdndCW7EpPqBdoTNZBty9Rkw8QnkSSmcLS46whaM3YjRD5n3xn4OOpvO6f5lQNRgpod9F9pyEqzmX8uHvjUSoqycdDyUSLjmKsxrNTG3tke-fFyMyFbfZh166Guwl7PjHqm3A9R_0XpBtBtT9uAnE_VPrM7iWoKqE3ksvF6UN54cSjLkkdA'
Multiple Item Return:
Project : https://gitlab.com/eshopbox-team/poe-backend-service
Return Endpoint :
Verify if return is valid and item details are correct
Creates CustomerReturnNumber and created entry in DB
Pickup Endpoint:
Group items on the basis of warehouse and call RecommendationAPI followed by ManifestationAPI from clickpost
Creates returnTracking ID, RefundId and approved entry in DB
Responsible for cron sync as well
curl :
curl --location 'http://localhost:8080/_ah/api/esb/v2/return' \
--header 'Authorization: Bearer eyJraWQiOiJNVGhEUWpsQ1JUSXpSVVE0UVVNMFFUSTVNRUpFTlRrM1FVRXlOalV3UmtSQ05qQXlNelk0TkEiLCJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJzdWIiOiI4MzgzMDAwNzAwIiwiYXVkIjpbImh0dHBzOi8vand0LmF1cGVyYXRvci5uZXQiXSwiYXpwIjoiZ29kYXZhcmlfcHJvZHVjdHMiLCJzY29wZSI6Im9wZW5JZCIsImlzcyI6Imh0dHBzOi8vYXV0aC5hdXBlcmF0b3IubmV0LyIsImV4cCI6IkF1ZyA2LCAyMDI0LCA2OjA3OjUxIEFNIiwidHlwZSI6ImZ1bGwiLCJpYXQiOiJBdWcgNSwgMjAyNCwgNjowNzo1MSBBTSIsImd0eSI6InBhc3N3b3JkIiwiY2xpZW50VXNlckVtYWlsIjoidGVnLnNpbmdoQGVzaG9wYm94LmNvbSJ9.AAAAB3NzaC1yc2EAAAABJQAAAQEAjmQfb2JpH284tBgkiW+duhbJb6VXp/y5N+99rBzCdB2RKl5mZ7NZiYRX85gf2qRoJ5xjbWBewwSGgy0MhqlcNsvBDE4q7SX8swmWKG6piG9BGmDxOAMiZwshlcifcRFGuGavctDQfhdMsAJ47LxaRGh65tcFqzlb3PpzqaFYSVeH7Ls99E9EWGvOQD/7e6UkhGfoatpgS6Lu3nxxDtsupHB5clv4cLlCALwgSHHwQZ34C+xMwqGhba9Q+KRVomcfawgvl1DtuxZxk/UHq1xh7bh8+QnhnCgthGX8FNgt92FgM7TP0QbENW7upIrIoqLnLedyy9+8KKfLLS9T0R0FiQ==' \
--header 'Content-Type: application/json' \
--data-raw '{
"customerOrderNumber": "ORD1511",
"isCOD": 0,
"isExchange": 0,
"refundMode": "originalPaymentMode",
"refundBankAccountDetails": "",
"exchangeItem": null,
"actor": "teg.singh@eshopbox.com",
"actorType": "seller",
"items": [
{
"lineItemSequenceNumber": 1,
"orderItemID": "ORD1511-30352479",
"orderItemIdPk" : "30352479",
"itemID": "oex233",
"quantity": "1",
"productName": "Oppo enco x2",
"returnReason": "Item no longer wanted",
"returnSubReason": "",
"exchangeSize": "",
"additionalInfo": {
"customerUploadImageUrl": "",
"comment": ""
}
}
],
"pickupAddress": {
"city": "Pune",
"countryCode": "IN",
"postalCode": "411057",
"addressLine1": "Hinjewadi, Pune",
"addressLine2": "",
"state": "Maharashtra",
"countryName": "IN",
"contactPhone": "8383000700",
"customerName": "Teg",
"email": "teg.singh@eshopbox.com"
}
}'
For created status entry in return shipment status logs is done from Return endpoint
For approved status entry in return shipment status logs is done from Pickup service
Tasks in queue :
Handle 2 months meta access token issue (To be planned ) SHE-4189
Add notification in case of delay in delivery/pickup https://auperator.atlassian.net/browse/SHE-4260
Incident handling SHE-4324