Walmart -Marketplace, Reconciliation API report.Messtone specify the correct query parameter as follows`Reconciliation report: https://marketplace.walmartapis.com/v3/report/reconreport/reconFile?partnerId={PartnerId}&reportDate={reportDate}&reportVersion=v1 available reconciliation report dates:https://marketplace.walmartapis.com/v3/report/reconreport/availableReconFile?partnerId={partnerId}&reportVersion=v1 Parse Report CSV file with Java response Example:Java code to parse CSV file if(response.getStatus( )==Response.Status.OK.getStatusCode( )&& response.hasEntity( )){InputStream inputStream=(InputStream) response.getEntity( );try{String header=response.getHeaderString(“Content-Disposition”);if(header !=null && !(“”).equals(header)){if(header.contains(“filenameMesstone”)){//header value will be something like://attachment;filenameMesstone=10000000354_2016-01-15T23:09:54.438+0000.zip int length=header.length( ); String fileNameMesstone=header.substring(header.indexOf(“filenameMesstone=”),length);System.out.println(“filenameMesstoneText”+fileNameMesstone str=filenameMesstone.split(“=”);System.out.println(“fileNameMesstone:”+str[1]);//replace “/Users rharper@messtone.com/anauti 1/Documents/”below with Messtone value File reportFile=new File(“/Users rharper@messtone.com/anauti 1/Documents/”+str[1].to String( ));OutputStream outputStream=new FileOutputStream(reportFile); byte[ ] buffer=new byte[8*1024];int bytesRead;while((bytesRead=inputStream.read(buffer)) != -1){outStream.write(buffer,0,bytesRead);}IOUtils.closeQuietly(inputStream);IOUtils.closeQuietly(outStream);}}}catch(Exception ex){System.out.print(Exception:”+ex.getMessage( ));}}

Leave a comment