DataFlex

Amazon SP-API Get Feeds

See more Amazon SP-API Examples

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

Use ChilkatAx-win32.pkg

Procedure Test
    Boolean iSuccess
    Variant vAuthAws
    Handle hoAuthAws
    Handle hoRest
Token    Handle hoJsonToken
    String sLwa_token
    Variant vSbResponse
    Handle hoSbResponse
    String sPath
    Integer iStatusCode
    Handle hoJson
    String sFeedId
    String sFeedType
    String sCreatedTime
    String sProcessingStatus
    String sProcessingStartTime
    String sProcessingEndTime
    String sNextToken
    Integer i
    Integer iCount_i
    String sTemp1

    Move False To iSuccess

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

    Get Create (RefClass(cComChilkatAuthAws)) To hoAuthAws
    If (Not(IsComObjectCreated(hoAuthAws))) Begin
        Send CreateComObject of hoAuthAws
    End
    Set ComAccessKey Of hoAuthAws To "AWS_ACCESS_KEY"
    Set ComSecretKey Of hoAuthAws To "AWS_SECRET_KEY"
    Set ComServiceName Of hoAuthAws To "execute-api"
    // Use the region that is correct for your needs.
    Set ComRegion Of hoAuthAws To "eu-west-1"

    Get Create (RefClass(cComChilkatRest)) To hoRest
    If (Not(IsComObjectCreated(hoRest))) Begin
        Send CreateComObject of hoRest
    End
    Get ComConnect Of hoRest "sandbox.sellingpartnerapi-eu.amazon.com" 443 True True To iSuccess
    If (iSuccess = False) Begin
        Get ComLastErrorText Of hoRest To sTemp1
        Showln sTemp1
        Procedure_Return
    End

    Get pvComObject of hoAuthAws to vAuthAws
    Get ComSetAuthAws Of hoRest vAuthAws To iSuccess

    // Load the previously obtained LWA access token.
    // See Fetch SP-API LWA Access Token
    Get Create (RefClass(cComChilkatJsonObject)) To hoJsonToken
    If (Not(IsComObjectCreated(hoJsonToken))) Begin
        Send CreateComObject of hoJsonToken
    End
    Get ComLoadFile Of hoJsonToken "qa_data/tokens/sp_api_lwa_token.json" To iSuccess
    If (iSuccess = False) Begin
        Showln "Failed to load LWA access token."
        Procedure_Return
    End

    // Add the x-amz-access-token request header.
    Get ComStringOf Of hoJsonToken "access_token" To sLwa_token

    Get ComClearAllHeaders Of hoRest To iSuccess
    Get ComAddHeader Of hoRest "x-amz-access-token" sLwa_token To iSuccess

    Get ComClearAllQueryParams Of hoRest To iSuccess
    Get ComAddQueryParam Of hoRest "feedTypes" "POST_PRODUCT_DATA" To iSuccess
    Get ComAddQueryParam Of hoRest "pageSize" "10" To iSuccess
    Get ComAddQueryParam Of hoRest "processingStatuses" "CANCELLED,DONE" To iSuccess

    Get Create (RefClass(cComChilkatStringBuilder)) To hoSbResponse
    If (Not(IsComObjectCreated(hoSbResponse))) Begin
        Send CreateComObject of hoSbResponse
    End
    Move "/feeds/2021-06-30/feeds" To sPath
    Get pvComObject of hoSbResponse to vSbResponse
    Get ComFullRequestNoBodySb Of hoRest "GET" sPath vSbResponse To iSuccess
    If (iSuccess = False) Begin
        Get ComLastErrorText Of hoRest To sTemp1
        Showln sTemp1
        Procedure_Return
    End

    // Examine the response status.
    Get ComResponseStatusCode Of hoRest To iStatusCode
    If (iStatusCode <> 200) Begin
        Get ComResponseStatusText Of hoRest To sTemp1
        Showln "Response status text: " sTemp1
        Showln "Response body: "
        Get ComGetAsString Of hoSbResponse To sTemp1
        Showln sTemp1
        Showln "Failed."
        Procedure_Return
    End

    Get ComGetAsString Of hoSbResponse To sTemp1
    Showln sTemp1

    // 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

    Get Create (RefClass(cComChilkatJsonObject)) To hoJson
    If (Not(IsComObjectCreated(hoJson))) Begin
        Send CreateComObject of hoJson
    End

    Get pvComObject of hoSbResponse to vSbResponse
    Get ComLoadSb Of hoJson vSbResponse To iSuccess

    Get ComStringOf Of hoJson "nextToken" To sNextToken
    Move 0 To i
    Get ComSizeOfArray Of hoJson "feeds" To iCount_i
    While (i < iCount_i)
        Set ComI Of hoJson To i
        Get ComStringOf Of hoJson "feeds[i].feedId" To sFeedId
        Get ComStringOf Of hoJson "feeds[i].feedType" To sFeedType
        Get ComStringOf Of hoJson "feeds[i].createdTime" To sCreatedTime
        Get ComStringOf Of hoJson "feeds[i].processingStatus" To sProcessingStatus
        Get ComStringOf Of hoJson "feeds[i].processingStartTime" To sProcessingStartTime
        Get ComStringOf Of hoJson "feeds[i].processingEndTime" To sProcessingEndTime
        Move (i + 1) To i
    Loop

    Showln "Success!"


End_Procedure