Uploading Attachment to Quickbooks

jeremyburns2256 — Fri, 17 May 2024 08:33:12 GMT

Hi,

I'm looking to use the Workato connector for Quickbooks to upload an image to later attach.

I'm following these notes but have not been able to solve it Attach images and notes (intuit.com).

I'm using a custom action with the Quickbooks connector.

Here's the details of my connector:

Request type: Raw request body

Response type: JSON response

Request body:

--B1pD17v6kehNbda7sT7J2JOqssMTGGvw
Content-Disposition: form-data; name="file_content_01"; filename="receipt_oct12229.jpg"
Content-Type: image/jpeg
/9j/4AAQSkZJRgABAQEASABIAAD/2wBDAAMCAgMCAgMDAwMEAwMEBQgFBQQEBQoHBwYIDAoMDAsKCwsNDhIQDQ4RDgsLEBYQERMUFRUVDA8XGBYUGBIUFRT/wAALCAABAAEBAREA/8QAFAABAAAAAAAAAAAAAAAAAAAACf/EABQQAQAAAAAAAAAAAAAAAAAAAAD/2gAIAQEAAD8AKp//2Q==
--B1pD17v6kehNbda7sT7J2JOqssMTGGvw--

Request Headers:

Content-Type multipart/form-data; boundary=B1pD17v6kehNbda7sT7J2JOqssMTGGvw

However I keep getting a similar error

{

2 AttachableResponse: [

3 {

4 Fault: {

5 Error: [

6 {

7 Message: Invalid Uploaded File,

8 Detail: The uploaded filename or file extension is invalid. Supplied Content Type: File Content Type:image/jpeg, File Name: File Name:receipt_oct12229.jpg,

9 code: 6041

10}

11],

12 type: ValidationFault

13}

14}

15],

16 time: 2024-05-17T01:28:50.296-07:00

17}

If I change the content type from image/jpeg to image/jpg I get a different error:

{

2 AttachableResponse: [

3 {

4 Fault: {

5 Error: [

6 {

7 Message: An application error has occurred while processing your request,

8 Detail: System Failure Error: java.lang.RuntimeException: error=parallelUploadFailed isS3UploadSuccessful=true isDocServiceUploadSuccessful=false,

9 code: 10000,

10 element: SystemFailureError

11}

12],

13 type: SystemFault

14}

15}

16],

17 time: 2024-05-17T01:29:39.737-07:00

18}

However when converting the sample .jpg file from base64 it indicates the correct MIME type is image/jpeg.

I have found people online be able to successfully use the API call from the documentation using 0Auth verification but using the Workato verification would make the process much simplier.

What is wrong with my implementation of this custom action in Workato?

Appreciate the input and suggestions!

Cheers,

Jeremy

Re: Uploading Attachment to Quickbooks

juliana-recio — Mon, 10 Jun 2024 06:41:42 GMT

Hi, @jeremyburns2256!

Good day! Apologies for the delay in response.
Here's a sample setup we have successfully tested on our end.

Hope this helps!

topic Uploading Attachment to Quickbooks in Workato Pros Discussion Board

Uploading Attachment to Quickbooks

Re: Uploading Attachment to Quickbooks