(DataFlex) Amazon SP-API Sellers Get Marketplace Participations

See more Amazon SP-API Examples

Demonstrates Amazon SP-API Sellers API -- get marketplace participations.

For more information, see https://developer-docs.amazon.com/sp-api/docs/sellers-api-v1-reference#getmarketplaceparticipations

Chilkat ActiveX Downloads ActiveX for 32-bit and 64-bit Windows

Use ChilkatAx-win32.pkg

Procedure Test
    Variant vAuthAws
    Handle hoAuthAws
    Handle hoRest
    Boolean iBTls
    Integer iPort
    Boolean iBAutoReconnect
    Boolean iSuccess
Token    Handle hoJsonToken
    String sLwa_token
    Variant vSbResponse
    Handle hoSbResponse
    String sUri
    Integer iStatusCode
    Handle hoJson
    String sId
    String sCountryCode
    String sName
    String sDefaultCurrencyCode
    String sDefaultLanguageCode
    String sDomainName
    Boolean iIsParticipating
    Boolean iHasSuspendedListings
    Integer i
    Integer iCount_i
    String sTemp1

    // 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
    Move True To iBTls
    Move 443 To iPort
    Move True To iBAutoReconnect
    // Make sure to use the correct domain.
    // In this example, we are using "sandbox.sellingpartnerapi-eu.amazon.com"
    Get ComConnect Of hoRest "sandbox.sellingpartnerapi-eu.amazon.com" iPort iBTls iBAutoReconnect 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 Create (RefClass(cComChilkatStringBuilder)) To hoSbResponse
    If (Not(IsComObjectCreated(hoSbResponse))) Begin
        Send CreateComObject of hoSbResponse
    End
    Move "/sellers/v1/marketplaceParticipations" To sUri
    Get pvComObject of hoSbResponse to vSbResponse
    Get ComFullRequestNoBodySb Of hoRest "GET" sUri 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:

    // {
    //   "payload": [
    //     {
    //       "marketplace": {
    //         "id": "ATVPDKIKX0DER",
    //         "countryCode": "US",
    //         "name": "Amazon.com",
    //         "defaultCurrencyCode": "USD",
    //         "defaultLanguageCode": "en_US",
    //         "domainName": "www.amazon.com"
    //       },
    //       "participation": {
    //         "isParticipating": true,
    //         "hasSuspendedListings": false
    //       }
    //     }
    //   ]
    // }

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

    Move 0 To i
    Get ComSizeOfArray Of hoJson "payload" To iCount_i
    While (i < iCount_i)
        Set ComI Of hoJson To i
        Get ComStringOf Of hoJson "payload[i].marketplace.id" To sId
        Get ComStringOf Of hoJson "payload[i].marketplace.countryCode" To sCountryCode
        Get ComStringOf Of hoJson "payload[i].marketplace.name" To sName
        Get ComStringOf Of hoJson "payload[i].marketplace.defaultCurrencyCode" To sDefaultCurrencyCode
        Get ComStringOf Of hoJson "payload[i].marketplace.defaultLanguageCode" To sDefaultLanguageCode
        Get ComStringOf Of hoJson "payload[i].marketplace.domainName" To sDomainName
        Get ComBoolOf Of hoJson "payload[i].participation.isParticipating" To iIsParticipating
        Get ComBoolOf Of hoJson "payload[i].participation.hasSuspendedListings" To iHasSuspendedListings
        Move (i + 1) To i
    Loop

    Showln "Success!"


End_Procedure