0

I am trying to access the pricing data from an API via POST request with a string of SKU's.

The string to send the server is a JSON array of the SKU's with all spacing removed (provided under code).

I am receiving a 500 error from the server when accessing via Java/Eclipse, however, when sending similar requests via Postman I receive the desired response.

The API limits requests to 100 per response and I have over 6000 prices to populate so I don't want to do this via postman.

I will eventually write a loop to process the entire request, but before I can get there I need to figure out why the server is responding with a 500 code and stating that the body of the request is null.

Here is my code:

import java.io.BufferedReader;
import java.io.IOException;
import java.io.InputStreamReader;
import java.io.OutputStream;
import java.net.HttpURLConnection;
import java.net.MalformedURLException;
import java.net.URL;
import java.nio.file.FileSystems;
import java.nio.file.Files;
import java.nio.file.Path;
import java.util.List;

public class PricingAPI {
    private static HttpURLConnection connection;

    public static void main(String[] args) {
        // TODO Auto-generated method stub
        
//      This is the reader to interpret what comes from API
        BufferedReader readsFromURL;
//      String the API reader appends to
        String lineFromURL;
//      Content that gets read from API URL and will be written to our own file
        StringBuffer responseContent = new StringBuffer();
//      this is the String that hold the sku to request 100 after
        String skuStartAfter = "0";
//      This is the SKU list to request from the API Server
        List<String> jsonInputStringList;
//      Used to take the list of strings and convert to single string
        String jsonInputString;
//      This is the file the jsonInpustString pulls from
        Path skuList = FileSystems.getDefault().getPath("SKU.json");
        
        try {
//          This buffered reader pulls the text out of the JSON to be sent as body
            jsonInputStringList = Files.readAllLines(skuList);
            
//          Converts the list of strings to a single string
            jsonInputString = String.join("", jsonInputStringList);
            
//          Tests the content of the jsonInputString
            System.out.println(jsonInputString);
            
//              API Endpoint to send POST request to
                URL url = new URL("https://emerson-api.emersonecologics.com/pricing/v1/pricing-request/?limit=100&startAfterId=" + skuStartAfter + "&endsWithId=");
                
//              Opens connection and casts to HttpURLConnection
                connection = (HttpURLConnection) url.openConnection();
                
//              Tests the URL connection by printing it out for us to view
                System.out.println(url);
                
                
                
//              HTTP Request Setup
                
//              Set method to post
                connection.setRequestMethod("POST");
                
//              Allow output from API
                connection.setDoOutput(true);
                
//              Get the output stream and assign to 'os' variable
                OutputStream os = connection.getOutputStream();
                
//              Convert SKU JSON file to Bytes and put into an array
                byte [] input = jsonInputString.getBytes("utf-8");
                
//              Write byte array "input" to the output stream for body of the HTTP Request
                os.write(input, 0, input.length);
//              connection.setRequestProperty("Content-Type", "application/json; utf-8");
//              connection.setRequestProperty("Accept", "application/json");
                connection.setConnectTimeout(5000);
                connection.setReadTimeout(5000);
                
                
                
                
//              If there is an error this block runs
                if (connection.getResponseCode() > 299) {
                    readsFromURL = new BufferedReader(new InputStreamReader(connection.getErrorStream()));
                    while ((lineFromURL = readsFromURL.readLine()) != null) {
                        responseContent.append(lineFromURL);
                    }
                    readsFromURL.close();
                    
//                  Connection Status Indicator (200-500)
                    System.out.println(responseContent);
                    System.out.println(connection.getResponseCode());
                } 
//              If there is no error the content is added to responseContent
                else {
                    readsFromURL = new BufferedReader(new InputStreamReader(connection.getInputStream()));
                    while ((lineFromURL = readsFromURL.readLine()) != null) {
                        responseContent.append(lineFromURL.substring(163,lineFromURL.length()-52));
                    }
                    System.out.println(responseContent);
                    readsFromURL.close();
                }
            
        }catch (MalformedURLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        } catch (IOException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
        
        

    }

}

here is the first 100 SKU's that I have as jsonInputString:

{"skus":["A16411","A16413","A16723","A16735","A16722","A16904","A16738","A16747","A16750","A34989","A16726","A16415","A16725","A16936","A16418","A16412","A16739","A16934","A16933","A64049","A67071","A67064","A16705","A16403","A16937","A16704","A16941","A16703","A16414","A16733","A16724","A66501","5HYDR","A71901","A7060","ACG16","ACET2","ACETY","AR70461","ADRE3","A70760","A70102","ALAR60","AIDII","A69109","A77490","ANTIO","ARTEM","ART33","ARTHR","A77510","A65702","A65603","A72809","BIFID","BIOTI","A76510","A71604","A76440","BRAI2","REMIN","BUFCC","BUF21","A50203","BUFCP","BUTYR","CALC2","CMCI2","PYRUV","CALM","CALM1","A72007","A74704","CAT4","CELLU","CHMVM","CHITO","CHRON","COQ30","COQ12","COMPL","COPP2","COQGA","COQ52","CQTOC","CQH60","A72908","A68802","AR76670","DHA8","DHE30","DHE31","DHE14","DHE11","DIM2","DIM5","DIM4","DRWI2","EARTH","A77100"]}
  • 1
    Do you need to include any specific ```Content-Type``` header in your request? Can you enable logging of the ```HttpURLConnection``` request like described [here](https://stackoverflow.com/questions/3428341/java-display-request-of-an-httpurlconnection-before-sending)? – Gryphon Aug 29 '20 at 23:59
  • Call all setter methods *before* writing output. But I believe the real problem is that you **never close the output stream**, so the bytes are sitting in a buffer and never actually transmitted to the server. Use try-with-resources, which any good IDE should have warned you about: `try (OutputStream os = connection.getOutputStream()) { os.write(jsonInputString.getBytes("utf-8")); }` and remember to uncomment the setting of `Content-Type` and set it before writing. – Andreas Aug 30 '20 at 01:41
  • Thanks Guys, setting the `Content-Type` prior to writing did the trick. – Andrew Werling Aug 30 '20 at 04:13

0 Answers0