Upload attachment not working | API

gsp · September 24, 2020, 7:54pm

Upload formdata is not working

Headers as

susana.maria.repeto · September 25, 2020, 7:26am

Hi!

That’s an issue I have also recently experienced. The only solution that worked for me is on this thread: Upload File API

But it seems you’re missing something in your request, the Borrower Data. You should send it also in the form-data as a parameter I guess.
Try that.

gsp · September 25, 2020, 1:24pm

Thanks Susana, Let me try that link solution and update you,
Well the borrower data is nothing already passing formdata (with same parameters its working in postman) @susana.maria.repeto Did you make it work at Object repository or in TestScript ? (sorry for being naive on this)

susana.maria.repeto · September 25, 2020, 1:32pm

If it’s working on postman I can tell you for sure it’s going to work in Katalon, but maybe you’ll have to make your own code like me.
tip: check the headers generated in Postman, the will give you a hint

gsp · September 25, 2020, 1:39pm

Yep copied all headers but yes the code might work… thanks again

gsp · September 25, 2020, 4:04pm

Hi @susana.maria.repeto
after importing okhttp 4.9.0 jar, restarted the katalon.I am getting this error in my test script

 @ line 17, column 1.
   import com.squareup.okhttp

commenting the above i am getting

unable to resolve class OkHttpClient 
 @ line 24, column 14.
   OkHttpClient client = new OkHttpClient().newBuilder()

what is missing ? any way-around

gsp · September 25, 2020, 4:25pm

Got resolved by importing the above class silly

Now facing another error

unable to resolve class MediaType 
   MediaType mediaType = MediaType.parse("multipart/form-data");

have to import this too ?

susana.maria.repeto · September 25, 2020, 4:28pm

Uhm I don’t have my code in front of me right now, so I’m not 100% sure but I think I didn’t use an external library, you can simple put this on your script imports:

import okhttp3.*;

A little later I can check if that doesn’t work!

gsp · September 25, 2020, 4:32pm

yes imported okhttp3.* works for previous issue. Sure no worries let me know later. thanks

susana.maria.repeto · September 25, 2020, 6:59pm

Okay here I am again.
MediaType is from okhttp so if you put the line I posted above it would work. I think Katalon itself has some library with the same Object, make sure it is not taking the wrong one.

But let me ask you a question, because maybe we are going by the long route with this code and it can be done easier than that. What kind of file do you want to upload? (PDF, XML, .jpg…) and what’s the purpose?

Katalon also provides some classes to create API requests in scripting mode (not ObjectRepository). I gave you the code that uses OkHttp because once again, Katalon didn’t work with its own classes, at least for me.
Try also this code that is simpler, maybe it will work for you (of course you’ll have to change headers to match yours):

TestObjectProperty contentTypeHeader = new TestObjectProperty("Content-Type", ConditionType.EQUALS, "multipart/form-data")
	basicAuthHeader = new TestObjectProperty("Authorization",ConditionType.EQUALS, "Basic myBase64token")
	defaultHeaders = Arrays.asList(cookieHeader, contentTypeHeader)

	RequestObject ro = new RestRequestObjectBuilder()
			.withRestUrl(importTestExecJUnitEndpoint)
			.withHttpHeaders(defaultHeaders)
			.withRestRequestMethod("POST")
			.withMultipartFormDataBodyContent([new FormDataBodyParameter('afile',filePath,'PARAM_TYPE_FILE')])
			.build()

	ResponseObject respObj = WS.sendRequest(ro)

You should also check this link that explains much better than me the WS scripting API requests mannualy
Let me know!

gsp · September 25, 2020, 7:18pm

I am currently sending .txt (but lately .jpg . jpeg, .tiff , .xls will come in my tea case ) It basically do some selfsigned docs need for approval for same Itemid iam passing along with.

Thanks for your reply … Will surely update on its working

gsp · September 28, 2020, 5:14pm

Hi No Sucess on this

i use both codes separately in the tests it did get passed without any failure. But when check the HAR file for response get same “405” error like i am getting in Object repository

TestCase

Har file

"response" : {
        "status" : 415,
        "statusText" : "",
        "httpVersion" : "",
        "cookies" : [ ],
        "headers" : [ {
          "name" : "Transfer-Encoding",
          "value" : "chunked"
        },

Postman Request works fine

susana.maria.repeto · September 29, 2020, 7:13am

Hi!!

415 error typically is related to the media type you’re trying to upload, that is not supported.
Can you please post your full code and also the full HAR file?

Cheers!

gsp · September 29, 2020, 8:24pm

Test Script Code is (this

WS.sendRequest(findTestObject('TPO/TPO - Upload Document', [('RESOURCE_PREFIX_TPO') : GlobalVariable.RESOURCE_PREFIX_TPO
            , ('ACCESS_TOKEN') : GlobalVariable.ACCESS_TOKEN, 

public void importJUnitTestExecRequest()
{
OkHttpClient client = new OkHttpClient().newBuilder()
  .build();
MediaType mediaType = MediaType.parse("multipart/form-data;");
RequestBody body = new MultipartBody.Builder().setType(MultipartBody.FORM)
  .addFormDataPart("loanguid", "33384d20-1597-43d8-8d56-164f9f630097")
  .addFormDataPart("file","/C:/Users/pathtoupload/qaauto-tpo/test.txt",
    RequestBody.create(MediaType.parse("application/octet-stream"),
    new File("/C:/pathtoupload/test.txt")))
  .addFormDataPart("documentName", "underwriting")
  .addFormDataPart("documentType", "FHA")
  .addFormDataPart("applicationid", "ALL")
  .build();
Request request = new Request.Builder()
  .url("MyURL/attachment")
  .method("POST", body)
  .addHeader("Authorization", "Bearer ${ACCESS_TOKEN}")
  .addHeader("Content-Type", "multipart/form-data; boundary=<calculated when request is sent>")
  .addHeader("Accept-Encoding", "gzip, deflate, br")
  .addHeader("Content-Length", "calculated when request is sent>")
  .addHeader("Accept", "*/*")
  .build();
  
//Response response = client.newCall(request).execute();
//println("Response status: " + response);
//String responseBody = response.body().string();
//println("************ IMPORT TEST EXECUTION RESULTS RESPONSE BODY ************");
//println(responseBody);
//println("*********************************************************************");
//def slurper = new groovy.json.JsonSlurper()
//def result = slurper.parseText(response.getResponseBodyContent())
//println(result)
	Response response = null;
//
	try {
		response = client.newCall(request).execute();
		println("************ IMPORT TEST EXECUTION RESULTS RAW RESPONSE ************");
		println("Response status: " + response);
		println("********************************************************************");
		if (response.isSuccessful()){
			String responseBody = response.body().string();
			println("************ IMPORT TEST EXECUTION RESULTS RESPONSE BODY ************");
			println(responseBody);
			println("*********************************************************************");
		} else {
			throw new IOException("Unexpected HTTP code " + response);
		}
	} catch (IOException e) {
		e.printStackTrace();
	}
}

HAR file: Please check your inbox, shared already. Thanks

Russ_Thomas · September 29, 2020, 9:19pm

@duyluong @ThanhTo Can you add some wisdom here please?

ThanhTo · September 30, 2020, 3:17am

Not the most well-versed in API, so I’ll tag someone who knows more about this @huynguyen

susana.maria.repeto · September 30, 2020, 6:52am

Hello!

Okay I’m not sure about anything anymore but try this. I’ve changed the following:

You don’t need to put /C:/… you can just simply do C:/ or even C:\…
Deleted the MediaType mediaType = MediaType.parse(“multipart/form-data;”), you don’t need it
MediaType.parse needs “application/text”, because you’re uploading a txt
You can try deleting some of the headers, and try deleting the boundary also, I didn’t need it.
I am also still concerned about the response that says Borrower data, I really thing you need to pass it into the body request.

WS.sendRequest(findTestObject('TPO/TPO - Upload Document', [('RESOURCE_PREFIX_TPO') : GlobalVariable.RESOURCE_PREFIX_TPO, ('ACCESS_TOKEN') : GlobalVariable.ACCESS_TOKEN, 

public void importJUnitTestExecRequest() {
OkHttpClient client = new OkHttpClient();

RequestBody body = new MultipartBody.Builder().setType(MultipartBody.FORM)
  .addFormDataPart("loanguid", "33384d20-1597-43d8-8d56-164f9f630097")
  .addFormDataPart("file","C:/Users/pathtoupload/qaauto-tpo/test.txt", RequestBody.create(MediaType.parse("application/text"), new File("C:/pathtoupload/test.txt"))) 
  .addFormDataPart("documentName", "underwriting")
  .addFormDataPart("documentType", "FHA")
  .addFormDataPart("applicationid", "ALL")
  .build();
  
Request request = new Request.Builder()
  .url("MyURL/attachment")
  .post(body)
  .addHeader("Authorization", "Bearer ${ACCESS_TOKEN}")
  .addHeader("Content-Type", "multipart/form-data")
  .build();
  
//Response response = client.newCall(request).execute();
//println("Response status: " + response);
//String responseBody = response.body().string();
//println("************ IMPORT TEST EXECUTION RESULTS RESPONSE BODY ************");
//println(responseBody);
//println("*********************************************************************");
//def slurper = new groovy.json.JsonSlurper()
//def result = slurper.parseText(response.getResponseBodyContent())
//println(result)
	Response response = null;
//
	try {
		response = client.newCall(request).execute();
		println("************ IMPORT TEST EXECUTION RESULTS RAW RESPONSE ************");
		println("Response status: " + response);
		println("********************************************************************");
		if (response.isSuccessful()){
			String responseBody = response.body().string();
			println("************ IMPORT TEST EXECUTION RESULTS RESPONSE BODY ************");
			println(responseBody);
			println("*********************************************************************");
		} else {
			throw new IOException("Unexpected HTTP code " + response);
		}
	} catch (IOException e) {
		e.printStackTrace();
	}
}

Hope it works!!

huynguyen · September 30, 2020, 4:50pm

Hi @gsp,
Please send the whole HAR file for investigation.

gsp · September 30, 2020, 5:49pm

Hi Pls check inbox, HAR file shared too, Susana is having the same

Topic		Replies	Views
Not able to upload Multipart/form-data using Katalon Studio Archive katalon-studio , api-testing	2	1632	August 8, 2022
Upload file using REST API Katalon Studio katalon-studio , api-testing	5	3785	June 3, 2022
Problems using multipart/form-data in Katalon Katalon Studio katalon-studio , api-testing	4	1008	February 6, 2023
Problems using multipart/form-data in manual mode Katalon Studio katalon-studio , api-testing	10	2912	August 8, 2022
Problems using multipart/form-data in Katalon Katalon Studio katalon-studio , api-testing	2	906	February 7, 2023

Upload attachment not working | API

Related topics