EspoCRM API Attachment empty response

[kanoriuta]

Hello,

I'm trying to upload contact's document via EspoCRM API v1.

The first thing I do is send POST fields to 'api/v1/Attachment'. My POST fields look like this:

CURLOPT_POSTFIELDS => json_encode(array(
    'name' => $_FILES['file']["name"],
    'publishDate' => date('Y-m-d'),
    'type' => $_FILES['file']['type'],
    'size' => $_FILES['file']['size'],
    'file' => ',' . base64_encode(file_get_contents($_FILES['file']['tmp_name'])),
)), 

File is being created but unfortunately, I don't get any response from API so I just don't know which ID should be assigned with the contact.

Any suggestions how to get new attachment's ID from API?

[tanya]

Hello.
It returns the ID.

[kanoriuta]

Hello,
It returns the ID then I upload .txt files, but try adding pdf or image files and it won't return any data.
Tried it with your script and the same result happened.
I am using 4.3.1 version by the way.

[tanya]

Better to use $url = "ESPO_DIR/api/v1/Attachment/action/upload";
And you will get attachmentId in response

[kanoriuta]

I changed the url and I got the attachment ID.
Unfortunately in localhost/431/data/upload/ empty files are being created now.
The same thing with database table `attachment` only the `ID`, `created_at` and `created_by_id` were added, other values are empty.

[tanya]

read actionUpload here application/Espo/Controllers/Attachment.php

set all field (except file) in one more patch request.

[kanoriuta]

application/Espo/Controllers/Attachment.php ln 47: $arr = explode(',', $data);
application/Espo/Services/Attachment.php ln 39: list($prefix, $contents) = explode(',', $data['file']);
One of them is exploding $data and the other one $data['file']

I'm still not sure why that comma is so necessary or why it can't be done with just one POST request. But it must be a bug because it can be done with one POST request while uploading text files.

So in the end I sent POST request to 'localhost/espo/api/v1/Attachment/action/upload' with fields:

CURLOPT_POSTFIELDS => json_encode(
    ',' . base64_encode(file_get_contents($_FILES['file']['tmp_name']))
), 

And then PATCH request to 'localhost/espo/api/v1/Attachment/{attachment_id}' with fields:

CURLOPT_POSTFIELDS => json_encode(array(
    'name' => $_FILES['file']["name"],
    'publishDate' => date('Y-m-d'),
    'type' => $_FILES['file']['type'],
    'size' => $_FILES['file']['size'],
)), 

And it's all good now.

[kanoriuta]

One more question related with attachments.

After attachment creation I sent new POST request to 'localhost/espo/api/v1/Document' and I got document's ID.

Now I need to insert new data into 'contact_document' table but I don't know how.
Is it even possible to connect contact and document via API?

Or maybe I should create new topic for it?

[tanya]

The easiest way to get answer, if you do not want to read a documentation ( https://www.espocrm.com/documentation/development/api/ Related Entities), is installing test espocrm instanse. Then you do what you want with UI and check Network Log in browser console

Request URL: ESPO_LOCATION/api/v1/Document/{documentId}/contacts
Request Method: POST
Post Params: {ids: ["{contactId}"]}

OR

Request URL: ESPO_LOCATION/api/v1/Contact/{contactId}/documents
Request Method: POST
Post Params: {ids: ["{documentId1}", "{documentId2}","{documentId3}"]}

[Maryam123]

Why no one is giving response to my post