Create Feed API code": "InvalidInput"

[priyankpatel-dev]

I want to implement feeds API in my system, after some workaround, I am able to create a feed document and able to upload feed data but when I try to create a feed from the document that I created I always get the same error response: "code": "InvalidInput", "message": "Invalid Input"

Here's what I have implemented:
// Create Amazon feed Doc

$specification = new CreateFeedDocumentSpecification;
    $response = $sdk->feeds()->createFeedDocument(
        $accessToken,
        $region,
        $specification->setContentType('text/xml; charset=utf-8')                   
    );
    dd($response);

//Upload Amazon feed Doc

        try {
        $response = Http::timeout(0)->withHeaders([
            'Content-Type' => 'text/xml; charset=utf-8'
        ])->put(
            'https://tortuga-prod-na.s3-external-1.amazonaws.com/%2FNinetyDays/amzn1.tortuga.4.na.066deb9b-a35c-489d-947f-82d1d0ee322b.T35LVJF9E8ZIFB?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Date=20220907T133156Z&X-Amz-SignedHeaders=content-type%3Bhost&X-Amz-Expires=300&X-Amz-Credential=AKIA5U6MO6RAGXROUKEY%2F20220907%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Signature=5ab07d7cbaf062d58add4e71714d4a856f7d4da33155fb21ff28b98d3ea24ada',
            $file
        );
        dd($response);
    } catch (\Exception $e) {
        return array('status' => 'error', 'data' => $e->getMessage());
    }

//Create an Amazon feed

$specification = new CreateFeedSpecification([
                            'feed_type' => "POST_FLAT_FILE_FULFILLMENT_DATA",
                            "marketplace_ids" => ['ATVPDKIKX0DER,A1AM78C64UM0Y8,A1MQXOICRS2Z7M,A2EUQ1WTGCTBG2,A2ZV50J4W1RKNI,A3H6HPSLHAK3XG,AHRY1CZE9ZY4H'],
                            "input_feed_document_id" => "123",
                        ]);
        $response = $sdk->feeds()->createFeed(
            $accessToken,
            $region,
            $specification
        );
        dd($response);

Does anyone have any idea about this?

[jasonhebert]

Looks like you are trying to submit an XML feed document as a POST_FLAT_FILE_FULFILLMENT_DATA type. If I am not mistaken that feed document is expected to be an XLS to tab-separated values file that contains one record per line in the file.

The template for that feed document can be found here: Flat.File.ShippingConfirm.xls
The old documentation for the prior API lists that here: FeedType_Enumeration__FBAFeeds

[priyankpatel-dev]

Actually, I am new to the SP API and all I want to do is update shipping information to amazon.
It is okay to do with the XLS, CSV, or Plain Text file as long as it works but at the moment I got stuck here, does anyone already implemented this?

[priyankpatel-dev]

Update

I fixed the feed create an issue and my feeds are getting processed successfully, but I am having an issue with the data I tried to create a .txt file with the "text/tab-separated-values" content type but in the feed result, I am getting the following error:

I tried with physical file read and upload that data into the feeds doc and also tried to generate data from the array but still the result is the same, Has anyone faced this and got any solution?

// Prepare data function

function generateFile() { $array = [ [ 'order-id', 'order-item-id', 'quantity', 'ship-date', 'carrier-code', 'carrier-name', 'tracking-number', 'ship-method', 'transparency_code', 'ship_from_address_name', 'ship_from_address_line1', 'ship_from_address_line2', 'ship_from_address_line3', 'ship_from_address_city', 'ship_from_address_county', 'ship_from_address_state_or_region', 'ship_from_address_postalcode', 'ship_from_address_countrycode' ], [ '123456789', '333333', '10', '10-02-30', 'FEDEX', 'FedEx', '852852828', 'Ground', '', '', '', '', '', '', '', '', '', '' ], [ '123456789', '333333', '10', '10-02-30', 'FEDEX', 'FedEx', '852852828', 'Ground', '', '', '', '', '', '', '', '', '', '' ] ]; $filename = '/amz-file.txt'; $file = fopen(public_path() . $filename, "w"); foreach ($array as $subArray) { fwrite($file, implode("\t", $subArray) . "\t\r\n"); } fclose($file); }

The file i tried to upload:
amz-file.txt

[priyankpatel-dev]

Feeds upload issue fixed!

[jsanchez-inova]

Hey, we can't post the code you use since I can't find how to do it.

[jsanchez-inova]

Can you send an example of how to upload a feed, but I can't find anything. I have the xml but I don't know how or where to send the file

[gala06195]

Hi, are you able to provide code how to post product feed in xml with PHP, I have a problem few days I am trying... I hope so that you can help me @priyankpatel-dev

[devilica]

I found solution for this create product feed in Laravel with Amazon SP-API (https://github.com/amazon-php/sp-api-sdk):

composer require amazon-php/sp-api-sdk
composer require nyholm/psr7 -W


use AmazonPHP\SellingPartner\AccessToken;
use AmazonPHP\SellingPartner\Model\Feeds\CreateFeedDocumentSpecification;
use AmazonPHP\SellingPartner\Model\Feeds\CreateFeedSpecification;
use AmazonPHP\SellingPartner\Regions;
use AmazonPHP\SellingPartner\SellingPartnerSDK;
use App\Models\Amazon\AmazonAuth;
use Exception;
use GuzzleHttp\Handler\CurlFactory;
use Illuminate\Support\Facades\Log;
use Illuminate\Support\Facades\Http;
use Illuminate\Support\Facades\App;
use Carbon\Carbon;
use Illuminate\Support\Facades\Storage;
use GuzzleHttp\Client;
use AmazonPHP\SellingPartner\Api\FeedsApi\FeedsSDK;
use AmazonPHP\SellingPartner\Configuration;
use AmazonPHP\SellingPartner\Exception\ApiException;
use AmazonPHP\SellingPartner\Exception\InvalidArgumentException;
use AmazonPHP\SellingPartner\HttpFactory;
use AmazonPHP\SellingPartner\HttpSignatureHeaders;
use AmazonPHP\SellingPartner\ObjectSerializer;
use Psr\Http\Client\ClientExceptionInterface;
use Psr\Http\Client\ClientInterface;
use Psr\Http\Message\RequestInterface;
use Psr\Log\LoggerInterface;
use AmazonPHP\SellingPartner\OAuth;
use Buzz\Client\Curl;
use Nyholm\Psr7\Factory\Psr17Factory;
use Psr\Log\NullLogger;


public function getAccessToken($channelId)
  {

    $amazonAuth = AmazonAuth::where('channel_id', $channelId)->first();  //my local database channel
    $isExpired = Carbon::parse($amazonAuth->expires_at)->isPast();
    $token = null;

    if ($isExpired) {

      $data = [
        'grant_type' => 'refresh_token',
        'refresh_token' => $amazonAuth->refresh_token,
        'client_id' => TenantService::getLwaClientId(),
        'client_secret' => TenantService::getLwaSecret()
      ];

      $response = Http::asForm()->post(
        'https://api.amazon.com/auth/o2/token',
        $data
      );


      if ($response->successful()) {
        $body = $response->json();
        $amazonAuth->access_token = $body['access_token'];
        $amazonAuth->expires_at = now()->addSeconds($body['expires_in'])->toDateTimeString();
        $amazonAuth->save();

        $token = $body['access_token'];
      } else {
        Log::channel('amazon')->info('Amazon access token refresh failed for amazon auth id: ' . $amazonAuth->id);
       
      }

    } else {
      $token = $amazonAuth->access_token;
    }

    if ($token) {
      $accessToken = new AccessToken(
        $token,
        $amazonAuth->refresh_token,
        'refresh_token',
        (int) $amazonAuth->expires_in,
        'refresh_token'
      );

      return $accessToken;
    }


  }

public function createFeedTest()
  {

    $client = new Client();
    $factory = new Psr17Factory();
    // $httpFactory = new HttpFactory($factory, $factory);
    $region = 'eu';
    $accessToken = $this->getAccessToken(150);
    $logger = new NullLogger();
    $configuration = Configuration::forIAMUser(
      $getLwaClientId,
      $getLwaSecret,
      $getAwsAccessKey,
      $getAwsSecretKey,
    );
    $sdk = SellingPartnerSDK::create($client, $factory, $factory, $configuration, $logger);
    $region = Regions::EUROPE;

    $specification = new CreateFeedDocumentSpecification;
    $feedDoc = $sdk->feeds()->createFeedDocument(
      $accessToken,
      $region,
      $specification->setContentType('text/xml; charset=utf-8')
    );
    $feedDocID = $feedDoc['feed_document_id'];
    $urlFeedUpload = $feedDoc['url'];

    $fileContent = '<?xml version="1.0" encoding="utf-8" ?>
    <AmazonEnvelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
              xsi:noNamespaceSchemaLocation="amzn-envelope.xsd">
            <Header>
              <DocumentVersion>1.01</DocumentVersion>
              <MerchantIdentifier>MYMERCHANTTOKEN</MerchantIdentifier>
            </Header>
            <MessageType>Product</MessageType>
            <PurgeAndReplace>false</PurgeAndReplace>
            <Message>
              <MessageID>1</MessageID>
              <OperationType>Update</OperationType>
              <Product>
                <SKU>56789</SKU>
                <StandardProductID>
                  <Type>ASIN</Type>
                  <Value>B0EXAMPLEG</Value>
                </StandardProductID>
                <ProductTaxCode>A_GEN_NOTAX</ProductTaxCode>
                <DescriptionData>
                  <Title>Example Product Title</Title>
                  <Brand>Example Product Brand</Brand>
                  <Description>This is an example product description.</Description>
                  <BulletPoint>Example Bullet Point 1</BulletPoint>
                  <BulletPoint>Example Bullet Point 2</BulletPoint>
                  <MSRP currency="USD">25.19</MSRP>
                  <Manufacturer>Example Product Manufacturer</Manufacturer>
                  <ItemType>example-item-type</ItemType>
                  <CountryOfOrigin>DE</CountryOfOrigin>
                  <UnitCount>1</UnitCount>
                  <PPUCountType>stück</PPUCountType>
                  <IsExpirationDatedProduct>false</IsExpirationDatedProduct>
                </DescriptionData>
                <ProductData>
                  <Health>
                    <ProductType>
                      <HealthMisc>
                        <Ingredients>Example Ingredients</Ingredients>
                        <Directions>Example Directions</Directions>
                      </HealthMisc>
                    </ProductType>
                  </Health>
                </ProductData>
                <IsHeatSensitive>false</IsHeatSensitive>

              </Product>
            </Message>
          </AmazonEnvelope>';

    dump($feedDoc);
    $curl = curl_init();
    curl_setopt($curl, CURLOPT_URL, $urlFeedUpload);
    curl_setopt($curl, CURLOPT_UPLOAD, true);
    curl_setopt($curl, CURLOPT_PROTOCOLS, CURLPROTO_HTTPS);
    curl_setopt($curl, CURLOPT_HTTPHEADER, array('Content-Type: text/xml; charset=utf-8'));
    curl_setopt($curl, CURLOPT_RETURNTRANSFER, 1);
    curl_setopt($curl, CURLOPT_BINARYTRANSFER, 1);
    curl_setopt($curl, CURLOPT_HEADER, false);
    curl_setopt($curl, CURLOPT_PUT, 1);
    curl_setopt($curl, CURLOPT_INFILE, fopen('data://text/plain,' . $fileContent, 'r'));
    curl_setopt($curl, CURLOPT_INFILESIZE, strlen($fileContent));
    #Only use below option on TEST environment if you have a self-signed certificate!!! On production this can cause security issues
    curl_setopt($curl, CURLOPT_SSL_VERIFYPEER, false);
    $response = curl_exec($curl);
    dump($response);
    curl_close($curl);
    $specificationNewFeed = new CreateFeedSpecification([
      'feed_type' => 'POST_PRODUCT_DATA',
      'marketplace_ids' => ['A1PA6795UKMFR9'],
      'input_feed_document_id' => $feedDocID

    ]);


    $responseFeed = $sdk->feeds()->createFeed(
      $accessToken,
      $region,
      $specificationNewFeed
    );
    dd($responseFeed);
  }

[jsanchez-inova]

If you were successful in being able to upload a file via feed, it uses your code but curl does not respond at all

but when creating the document it does send me the ID