[source-amazon-seller-partner] Bad Request code 400 'Could not match input arguments

[TereGranero]

Connector Name

Amazon Seller Partner

Connector Version

4.6.2

What step the error happened?

Configuring a new connector

Relevant information

I am using Airbyte open source v. 1.6.0.
I am trying to connect to Sandbox in US region as a Seller. I filled in LWA Client Id, LWA Client Secret and manually Refresh Token.
When testing the source, Configuration check failed due to a 'Bad Request'. I've also tried with connector v. 4.50 with the same result.
I also tried to create the source via API but sync fails in check connection.

Relevant log output

2025-04-15 11:45:18 info 
2025-04-15 11:45:18 info ----- START CHECK -----
2025-04-15 11:45:18 info 
2025-04-15 11:45:27 info Connector exited, processing output
2025-04-15 11:45:27 info Output file jobOutput.json found
2025-04-15 11:45:27 info Connector exited with exit code 0
2025-04-15 11:45:27 info Reading messages from protocol version 0.2.0
2025-04-15 11:45:27 error 'GET' request to 'https://sandbox.sellingpartnerapi-na.amazon.com/orders/v0/orders?MarketplaceIds=ATVPDKIKX0DER&MaxResultsPerPage=100&LastUpdatedAfter=2023-04-16T09%3A45%3A26Z&LastUpdatedBefore=2023-04-17T00%3A00%3A00Z' failed with status code '400' and error message: 'Could not match input arguments'. Request (body): 'None'. Response (body): '{'errors': [{'code': 'InvalidInput', 'message': 'Could not match input arguments', 'details': ''}]}'. Response (headers): '{'Server': 'Server', 'Date': 'Tue, 15 Apr 2025 09:45:26 GMT', 'Content-Type': 'application/json', 'Content-Length': '135', 'Connection': 'keep-alive', 'x-amz-rid': '37E2H97H5BQ1B2JEJR9M', 'x-amzn-RateLimit-Limit': '5.0', 'x-amzn-RequestId': '05a23f22-3561-4ebc-ae11-98f6d66d7c79', 'x-amz-apigw-id': 'OPF05a23f223561', 'X-Amzn-Trace-Id': 'Root=1-67fe2ab6-05a23f2235614ebc', 'Vary': 'Content-Type,Accept-Encoding,User-Agent', 'Strict-Transport-Security': 'max-age=47474747; includeSubDomains; preload'}'.
2025-04-15 11:45:27 error Check failed
2025-04-15 11:45:27 info Checking for optional control message...
2025-04-15 11:45:27 info Writing output of e55879a8-0ef8-4557-abcf-ab34c53ec460_5b589e68-846e-4223-85bb-6e05c5892740_0_check to the doc store
2025-04-15 11:45:27 info Marking workload e55879a8-0ef8-4557-abcf-ab34c53ec460_5b589e68-846e-4223-85bb-6e05c5892740_0_check as successful
2025-04-15 11:45:27 info 
2025-04-15 11:45:27 info Deliberately exiting process with code 0.
2025-04-15 11:45:27 info ----- END CHECK -----
2025-04-15 11:45:27 info

Contribute

• Yes, I want to contribute

[marcosmarxm]

Are you able to connect/make a single request using curl?

[marcosmarxm]

@TereGranero it looks there is a similar issue #57754. I escalated both the connector team to take a look.

[TereGranero]

Are you able to connect/make a single request using curl?

curl -X POST http://localhost:8008/api/v1/sources/create \
  -H "Content-Type: application/json" \
  -H "Authorization: Bearer JWT" \
  -d '{
    "sourceDefinitionId": "e55879a8-0ef8-4557-abcf-ab34c53ec460",
    "workspaceId": "f859b53f-ba14-41a9-8e1a-843c719b2f40",
    "name": "Amazon Seller Sandbox",
    "connectionConfiguration": {
      "region": "US",
      "auth_type": "oauth2.0",
      "account_type": "Seller",
      "period_in_days": 90,
      "aws_environment": "SANDBOX",
      "financial_events_step": "180",
      "wait_to_avoid_fatal_errors": false,
      "report_options_list": [
        {
          "report_name": "GET_FLAT_FILE_ALL_ORDERS_DATA_BY_ORDER_DATE_GENERAL",
          "stream_name": "flat_file_orders_report",
          "options_list": []
        }
        ],
      "lwa_app_id": "CLIENT_ID",
      "lwa_client_secret": "SECRET",
      "refresh_token": "REFRESH_TOKEN",
      "replication_start_date": "2023-04-16T00:00:00Z",
      "replication_end_date": "2023-04-17T00:00:00Z"
    }
  }'

Returned this:
{"sourceDefinitionId":"e55879a8-0ef8-4557-abcf-ab34c53ec460","sourceId":"9db5e080-ddba-42f3-a5d1-a3656d98ff9c","workspaceId":"f859b53f-ba14-41a9-8e1a-843c719b2f40","connectionConfiguration":{"region":"US","auth_type":"oauth2.0","lwa_app_id":"**********","account_type":"Seller","refresh_token":"**********","period_in_days":90,"aws_environment":"SANDBOX","lwa_client_secret":"**********","report_options_list":[{"report_name":"GET_FLAT_FILE_ALL_ORDERS_DATA_BY_ORDER_DATE_GENERAL","stream_name":"flat_file_orders_report","options_list":[]}],"replication_end_date":"2023-04-17T00:00:00Z","financial_events_step":"180","replication_start_date":"2023-04-16T00:00:00Z","wait_to_avoid_fatal_errors":false},"name":"Amazon Seller Sandbox","sourceName":"Amazon Seller Partner","icon":"https://connectors.airbyte.com/files/metadata/airbyte/source-amazon-seller-partner/latest/icon.svg","isVersionOverrideApplied":false,"isEntitled":true,"supportState":"supported","createdAt":1744700973}

The source is created but fails test when sync

[TeresaGranero]

@TereGranero it looks there is a similar issue #57754. I escalated both the connector team to take a look.

@marcosmarxm any news about this issue? we are still waiting...