cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

Uploading Attachment to Quickbooks

jeremyburns2256
Deputy Chef I
Deputy Chef I

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

 

 

1 ACCEPTED SOLUTION

juliana-recio
Workato employee
Workato employee

Hi, @jeremyburns2256

Good day! Apologies for the delay in response. 
Here's a sample setup we have successfully tested on our end. 
Screenshot 2024-06-10 at 2.32.07โ€ฏPM.pngScreenshot 2024-06-10 at 2.28.51โ€ฏPM.pngScreenshot 2024-06-10 at 2.31.28โ€ฏPM.pngScreenshot 2024-06-10 at 2.33.44โ€ฏPM.png

 

Hope this helps! 

View solution in original post

1 REPLY 1

juliana-recio
Workato employee
Workato employee

Hi, @jeremyburns2256

Good day! Apologies for the delay in response. 
Here's a sample setup we have successfully tested on our end. 
Screenshot 2024-06-10 at 2.32.07โ€ฏPM.pngScreenshot 2024-06-10 at 2.28.51โ€ฏPM.pngScreenshot 2024-06-10 at 2.31.28โ€ฏPM.pngScreenshot 2024-06-10 at 2.33.44โ€ฏPM.png

 

Hope this helps!