Discuss a project

DL-006 · Case study

Adapter for Amazon SP-API authentication

Orion's orders ran in a legacy Visual FoxPro app that could not authenticate to the SP-API. We built a connector that handles authentication and proxies requests.

Client
Orion
Location
USA
Industry
Amazon Seller
Capabilities
03Build04Secure
01

Challenge

  • Legacy Visual FoxPro application had to authenticate with Amazon's SP-API.
  • SP-API requests had to run from the existing application, not a rewrite.
  • Direct-to-consumer shipping needed PII-restricted customer data.
02

Environment

  • Telescope and binocular maker, established in 1975, selling on Amazon.
  • Visual FoxPro platform plus Amazon CSV files in daily operations.
03

Intervention

  • Development plan and tech diagram agreed before implementation.
  • SP-API connector handling authentication and proxying requests for Visual FoxPro.
  • Guidance on managing PII and handling Amazon CSV files.
  • Documentation with examples for order retrieval and report downloads.
04

Outcome

  • Visual FoxPro application executes SP-API requests through the connector.
  • Access to PII-restricted data for direct-to-consumer shipping.
  • Detailed report of completed work handed over; collaboration continued.
The Visual FoxPro application sends requests to a Lambda-based connector, which handles SP-API authentication and proxies calls, including restricted-data calls, back to the legacy app.RESTRICTED DATA BOUNDARYrequestsproxiedPIIVISUAL FOXPROLegacy appSP-API CONNECTORAWS Lambda / Node.jsAUTHToken handlingDOCSOrders / reports examplesSP-API20+ endpointsRESTRICTED DATAPII
  1. 01VISUAL FOXPROLegacy appSP-API CONNECTORAWS Lambda / Node.jsrequests
  2. 02SP-API CONNECTORAWS Lambda / Node.jsAUTHToken handling
  3. 03SP-API CONNECTORAWS Lambda / Node.jsSP-API20+ endpointsproxied
  4. 04SP-API20+ endpointsRESTRICTED DATAPII
  5. 05RESTRICTED DATAPIISP-API CONNECTORAWS Lambda / Node.jsPII
  6. 06DOCSOrders / reports examplesVISUAL FOXPROLegacy app
Fig. 07Authentication adapter for a legacy clientThe Visual FoxPro application sends requests to a Lambda-based connector, which handles SP-API authentication and proxies calls, including restricted-data calls, back to the legacy app.Scale NTS

Results, as published.

20+
SP-API endpoints used
3 weeks
Project time
2
Deltologic experts involved

Stack and services.

Stack05

  • Amazon SP-API
  • AWS Lambda
  • NodeJS
  • TypeScript
  • Visual FoxPro

Services used03

Tell us what has to work.

A senior engineer reads every brief. Describe the system, what it runs on today and what happens when it fails.

Discuss a project