/
parent-child app setup

parent-child app setup

Owned by nilam.nerlekar (Unlicensed)
Last updated: Nov 23, 2023
2 min read

  1. App setup on eshopbox seller account (parent app setup) : Do the app setup on eshopbox seller account.

  2. App setup on other workspace ( child app setup)

    1. Install the app on a workspace. Will get in installationId in url (note the installationId). e.g here installationId is 1075

    2. Get the appId by following query

      select appId from ie_app_installation iai where iai.appInstallationId = 1075

    3. After app installation creation child connection by calling api through postman

      curl --location --globoff 'https://{accountslug}.myeshopbox.com/api/v1/connection/start' \ --header 'Content-Type: application/json' \ --header 'Authorization: Bearer eyJhbGciOiJSUzI1NiIsInR5cCI6IkpXVCIsImtpZCI6Ik1UaERRamxDUlRJelJVUTRRVU0wUVRJNU1FSkVOVGszUVVFeU5qVXdSa1JDTmpBeU16WTROQSJ9.eyJodHRwczovL2FwcERhdGEiOnt9LCJodHRwczovL3VzZXJEZXRhaWxzIjp7ImlkIjoxMDAzLCJ1c2VyVHlwZSI6ImRlZmF1bHQiLCJlbWFpbCI6ImFudXNoaS5kQGVzaG9wYm94LmNvbSJ9LCJodHRwczovL2FjY291bnRzIjpbImdyYXNpbSJdLCJodHRwczovL3dhcmVob3VzZVdvcmtzcGFjZXMiOltdLCJodHRwczovL3dhcmVob3VzZXMiOltdLCJodHRwczovL3BhcnRuZXJzIjpbIjQzMTg5NSIsIjI4NDE2NiIsIjg5ODY4NSIsIjY3ODE1MSIsIjEyMjA4NSIsIjI5NTM1MiIsIjE4NjE5NiIsIjE2MzUwOSIsIjU2MzM4NSIsIjgyMDA2MSIsIjkyOTEzMiIsIjkyNjc2NiIsIjMxMTE5MSIsIjEzMDU0MSJdLCJpc3MiOiJodHRwczovL2VzaG9wYm94LmF1dGgwLmNvbS8iLCJzdWIiOiJlbWFpbHw2MDg5NmVlZWI2MDg3MTAzMmU2YzhlYzMiLCJhdWQiOlsiaHR0cHM6Ly93bXMubXllc2hvcGJveC5jb20iLCJodHRwczovL2VzaG9wYm94LmF1dGgwLmNvbS91c2VyaW5mbyJdLCJpYXQiOjE2OTk1MzMxOTQsImV4cCI6MTY5OTYxOTU5NCwiYXpwIjoiSUlOSjZrbjNFQkZLZDJlVEZ6TW9ZZ0tmaGw2NTQwMkwiLCJzY29wZSI6Im9wZW5pZCBwcm9maWxlIGVtYWlsIn0.hBAS4BisnJpW0cqapZpgocpWZgAcAApaIwrlG-9Hb2a27P6umfRpgatXZUD7_Ul3K2Wn7eHib1lm1rJACG5sUf-ltyVIzoQvhdStq9ILvZbZBZBE_RIp6RQ8yR79ze-DBHJH9Pct-djDOXzu6-3bb5A7TeicbiiOLPRvcdhD8JOTKKXC61Hvk-6-qmiEPaaQiVo2RXut1susZPOj7d9BdloDB15aqvcG4rSRuehQUc81txI2bx_CgLejwxbZK3oF5VH1oZYGRBNlCROoR7JELmvtkdG_NGsYm1rBb9MhVy1MRHE1Q5YLQr9tQWg05JPBfa5uEy8ZEIe-s2QyZBnUzg' \ --header 'Cookie: JSESSIONID=bniEyVpy2ZKcX6EzKInBDQ' \ --data '{ "appId": 434, "installationId": 1075, "authFields": {}, "connectionName": "Nykaa", "isSellerOfRecord": "1" }'

import the above curl request in the postman.

In header Authorization token is required. To get token login into workspace. Right click on page, click on inspect. Go to Network. click on any api, in header will get the token

Request Body :

appId : will get from step 2 → b

installationId : will get from step 2 → a

authFields : should be empty as per mentioned in request.

connectionName : app name, visible on front end (e.g Nykaa, Ajio)

isSellerOfRecord : “1”

 

d. Get parentConnectionId from ie_appinstall_connection table

select iac.parentConnectionId from ie_appinstall_connection iac where iac.appInstallationId = 1075

e. Get channelId from channels table. Following connectionId is the parentConnectionId we got from step 2 → d

select id from channels c where connectionId = 2095

f. Get account id from accounts table. account_slug is child account workspace name

select id from accounts a where a.account_slug = 'grasim'

 

g. Get externalWmsChannelId from external_wms_channels table. channel_id is the id we got in step 2 → e

select id from external_wms_channels ewc where ewc.channel_id = 2673

 

h. Insert record in channel_account_mapping

INSERT INTO channel_account_mapping(channel_id, account_id, external_wms_channel_id, STATUS, enrollmentStatus, brandRegistrationStatus, opsVerificationStatus) VALUES (2673,132, 3493,'1','ACTIVE', '1', '1'); INSERT INTO channel_account_mapping(channel_id, account_id, external_wms_channel_id, STATUS, enrollmentStatus, brandRegistrationStatus, opsVerificationStatus) VALUES (2673,132, 3491,'1','ACTIVE', '1', '1'); INSERT INTO channel_account_mapping(channel_id, account_id, external_wms_channel_id, STATUS, enrollmentStatus, brandRegistrationStatus, opsVerificationStatus) VALUES (2673,132, 3492,'1','ACTIVE', '1', '1'); INSERT INTO channel_account_mapping(channel_id, account_id, external_wms_channel_id, STATUS, enrollmentStatus, brandRegistrationStatus, opsVerificationStatus) VALUES (2673,132, 3490,'1','ACTIVE', '1', '1');

Note : Need to add mappings for all locations which are enabled on a parent app. Suppose in step 2 → g we got 4 externalWmsChannelId’s then in step 2 → e we should add mappings for 4 externalWmsChannels

channel_id : step 2 → e

account_id : step 2 → f

external_wms_channel_id : step 2 → g

Related content