Access Token Cron for Nykaa
- Rashi Mishra (Unlicensed)
STEPS :
Step1. Fetch the data of connections from Database.
Step2. Extract id, refreshToken, state and authorization_code from table “ie_appinstall_connection“, appId from table “ie_app_installation“, version from table “ie_app_version“ and key, value from table “ie_environment_variable“ for the connections where ie_appinstall_connection.isActive = "1" AND e_app_installation.appId is not NULL.
Table Used : ie_appinstall_connection, ie_app_installation, ie_app_version, ie_environment_variable
DB Used: integration_engine_staging
Query:
SELECT ie_appinstall_connection.id, ie_appinstall_connection.inputFields, ie_appinstall_connection.refreshToken,
ie_appinstall_connection.state, ie_appinstall_connection.authorizationCode,
ie_app_installation.appId,
ie_app_version.version,
FROM ie_appinstall_connection
LEFT JOIN ie_app_installation ON ie_app_installation.appInstallationId = ie_appinstall_connection.appInstallationId
LEFT JOIN ie_app_version ON ie_app_version.appVersionId = ie_app_installation.appVersionId
WHERE ie_appinstall_connection.isActive = "1" AND ie_app_installation.appId = '' AND ie_appinstall_connection.accessTokenExpiryAt= now-5_daysStep3. Store the result of above query in a list and push the extracted data in taskQueue and return an acknowledge/success message.
Step 3.1. “listen/accessTokenCron” this endpoint will receive the data from taskQueue.
Step4. The API is called using the request params.
GET 'https://xxxxx/RestWS/api/sellerPanel/v3/authToken?username=51TEST4&password=sa@321Input Fields Required:
1. Username=50TEST
2. Password=pass
Step5. Save the updated accessToken data in DB “ie_appinstall_connection“ using the below query:
UPDATE `ie_appinstall_connection` SET
`accessToken` = :new_access_token,
`accessTokenExpiryAt` = :new_expiry_time,
`accessTokenGeneratedOn` = :current_time
WHERE `ie_appinstall_connection`.`id` = :connection_id;