Lianja

Amazon SP-API Get Feeds

See more Amazon SP-API Examples

Returns feed details for the feeds that match the filters that you specify. Lianja

llSuccess = .F.

// This example requires the Chilkat API to have been previously unlocked.
// See Global Unlock Sample for sample code.

loAuthAws = createobject("CkAuthAws")
loAuthAws.AccessKey = "AWS_ACCESS_KEY"
loAuthAws.SecretKey = "AWS_SECRET_KEY"
loAuthAws.ServiceName = "execute-api"
// Use the region that is correct for your needs.
loAuthAws.Region = "eu-west-1"

loRest = createobject("CkRest")
llSuccess = loRest.Connect("sandbox.sellingpartnerapi-eu.amazon.com",443,.T.,.T.)
if (llSuccess = .F.) then
    ? loRest.LastErrorText
    release loAuthAws
    release loRest
    return
endif

llSuccess = loRest.SetAuthAws(loAuthAws)

// Load the previously obtained LWA access token.
// See Fetch SP-API LWA Access Token
loJsonToken = createobject("CkJsonObject")
llSuccess = loJsonToken.LoadFile("qa_data/tokens/sp_api_lwa_token.json")
if (llSuccess = .F.) then
    ? "Failed to load LWA access token."
    release loAuthAws
    release loRest
    release loJsonToken
    return
endif

// Add the x-amz-access-token request header.
lcLwa_token = loJsonToken.StringOf("access_token")

loRest.ClearAllHeaders()
loRest.AddHeader("x-amz-access-token",lcLwa_token)

loRest.ClearAllQueryParams()
loRest.AddQueryParam("feedTypes","POST_PRODUCT_DATA")
loRest.AddQueryParam("pageSize","10")
loRest.AddQueryParam("processingStatuses","CANCELLED,DONE")

loSbResponse = createobject("CkStringBuilder")
lcPath = "/feeds/2021-06-30/feeds"
llSuccess = loRest.FullRequestNoBodySb("GET",lcPath,loSbResponse)
if (llSuccess = .F.) then
    ? loRest.LastErrorText
    release loAuthAws
    release loRest
    release loJsonToken
    release loSbResponse
    return
endif

// Examine the response status.
lnStatusCode = loRest.ResponseStatusCode
if (lnStatusCode <> 200) then
    ? "Response status text: " + loRest.ResponseStatusText
    ? "Response body: "
    ? loSbResponse.GetAsString()
    ? "Failed."
    release loAuthAws
    release loRest
    release loJsonToken
    release loSbResponse
    return
endif

? loSbResponse.GetAsString()

// If successful, gets a JSON response such as the following:

// {
//   "feeds": [
//     {
//       "feedId": "FeedId1",
//       "feedType": "POST_PRODUCT_DATA",
//       "createdTime": "2019-12-11T13:16:24.630Z",
//       "processingStatus": "CANCELLED",
//       "processingStartTime": "2019-12-11T13:16:24.630Z",
//       "processingEndTime": "2019-12-11T13:16:24.630Z"
//     }
//   ],
//   "nextToken": "VGhpcyB0b2tlbiBpcyBvcGFxdWUgYW5kIGludGVudGlvbmFsbHkgb2JmdXNjYXRlZA=="
// }

// Use this online tool to generate parsing code from sample JSON: 
// Generate Parsing Code from JSON

loJson = createobject("CkJsonObject")

loJson.LoadSb(loSbResponse)

lcNextToken = loJson.StringOf("nextToken")
i = 0
lnCount_i = loJson.SizeOfArray("feeds")
do while i < lnCount_i
    loJson.I = i
    lcFeedId = loJson.StringOf("feeds[i].feedId")
    lcFeedType = loJson.StringOf("feeds[i].feedType")
    lcCreatedTime = loJson.StringOf("feeds[i].createdTime")
    lcProcessingStatus = loJson.StringOf("feeds[i].processingStatus")
    lcProcessingStartTime = loJson.StringOf("feeds[i].processingStartTime")
    lcProcessingEndTime = loJson.StringOf("feeds[i].processingEndTime")
    i = i + 1
enddo

? "Success!"


release loAuthAws
release loRest
release loJsonToken
release loSbResponse
release loJson