Topics to be covered -
Whatsapp
Segments Api
Multiple item return.
Whatsapp-
Repo :
https://gitlab.com/eshopbox-team/whatsapp-notifications-webhook-service
...
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
...
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
...
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
...
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"
}
}'
...