Accessing Email api

Hello,

I have a problem. I want to create, get, .. emails from the orocrm api. First when I opened api/doc/rest_json_api I didn’t see anything related with emails. Then I found that oro added automatic generation of api since June 2016. So I edited the api.yml in the EmailBundle. To this:

YAML

api: entities: # Oro\Bundle\EmailBundle\Entity\EmailTemplate: ~ # Oro\Bundle\EmailBundle\Entity\AutoResponseRule: ~ # Oro\Bundle\EmailBundle\Entity\AutoResponseRuleCondition: ~ Oro\Bundle\EmailBundle\Entity\Email: documentation_resource: '@OroEmailBundle/Resources/doc/api/email.md' fields: activityTargets: data_type: association:manyToMany:activity actions: get: true get_list: true update: true create: true delete: true delete_list: false get_relationship: true update_relationship: true add_relationship: true delete_relationship: true subresources: recipients: true suggestions: target_class: Oro\Bundle\ApiBundle\Model\EntityIdentifier target_type: collection actions: get_relationship: true update_relationship: true add_relationship: true delete_relationship: true filters: fields: exclude-current-user: data_type: boolean Oro\Bundle\EmailBundle\Entity\EmailAttachment: ~ Oro\Bundle\EmailBundle\Entity\EmailAttachmentContent: ~ Oro\Bundle\EmailBundle\Entity\EmailBody: ~ Oro\Bundle\EmailBundle\Entity\EmailFolder: ~ Oro\Bundle\EmailBundle\Entity\EmailOrigin: ~ Oro\Bundle\EmailBundle\Entity\EmailRecipient: ~ Oro\Bundle\EmailBundle\Entity\EmailThread: ~ Oro\Bundle\EmailBundle\Entity\EmailUser: ~ # Oro\Bundle\EmailBundle\Entity\InternalEmailOrigin: ~ Oro\Bundle\EmailBundle\Entity\Mailbox: ~

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47

api:     entities: #        Oro\Bundle\EmailBundle\Entity\EmailTemplate: ~ #        Oro\Bundle\EmailBundle\Entity\AutoResponseRule: ~ #        Oro\Bundle\EmailBundle\Entity\AutoResponseRuleCondition: ~           Oro\Bundle\EmailBundle\Entity\Email:             documentation_resource: '@OroEmailBundle/Resources/doc/api/email.md'             fields:                 activityTargets:                     data_type: association:manyToMany:activity             actions:                 get: true                 get_list: true                 update: true                 create: true                 delete: true                 delete_list: false                 get_relationship: true                 update_relationship: true                 add_relationship: true                 delete_relationship: true             subresources:                 recipients: true                 suggestions:                     target_class: Oro\Bundle\ApiBundle\Model\EntityIdentifier                     target_type: collection                     actions:                         get_relationship: true                         update_relationship: true                         add_relationship: true                         delete_relationship: true                     filters:                         fields:                             exclude-current-user:                                 data_type: boolean           Oro\Bundle\EmailBundle\Entity\EmailAttachment: ~         Oro\Bundle\EmailBundle\Entity\EmailAttachmentContent: ~         Oro\Bundle\EmailBundle\Entity\EmailBody: ~         Oro\Bundle\EmailBundle\Entity\EmailFolder: ~         Oro\Bundle\EmailBundle\Entity\EmailOrigin: ~         Oro\Bundle\EmailBundle\Entity\EmailRecipient: ~         Oro\Bundle\EmailBundle\Entity\EmailThread: ~         Oro\Bundle\EmailBundle\Entity\EmailUser: ~ #        Oro\Bundle\EmailBundle\Entity\InternalEmailOrigin: ~         Oro\Bundle\EmailBundle\Entity\Mailbox: ~

I also tried just putting there: Oro\Bundle\EmailBundle\Entity\Email: ~
It worked but I think it is not showing everything. F.e. when I tried to add a new email. Through sandbox on api/emails POST with following content:

JavaScript

{ "data": { "type": "emails", "attributes": { "created": "2017-08-17T12:51:04Z", "subject": "test", "fromName": "test", "sentAt": "2017-08-17T12:51:04Z", "importance": 1, "internalDate": "2017-08-17T12:51:04Z", "head": true, "messageId": "test", "multiMessageId": null, "xMessageId": null, "xThreadId": null, "refs": [], "acceptLanguageHeader": null, "bodySynced": false } } }

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23

{   "data":     {       "type": "emails",       "attributes": {         "created": "2017-08-17T12:51:04Z",         "subject": "test",         "fromName": "test",         "sentAt": "2017-08-17T12:51:04Z",         "importance": 1,         "internalDate": "2017-08-17T12:51:04Z",         "head": true,         "messageId": "test",         "multiMessageId": null,         "xMessageId": null,         "xThreadId": null,         "refs": [],         "acceptLanguageHeader": null,         "bodySynced": false       }       } }

I got following error:

PHP

{ "errors": [ { "status": "500", "title": "not null constraint violation exception", "detail": "*DEBUG ONLY* An exception occurred while executing 'INSERT INTO oro_email (serialized_data, created, subject, from_name, sent, importance, internaldate, is_head, message_id, multi_message_id, x_message_id, x_thread_id, refs, acceptLanguageHeader, body_synced, thread_id, email_body_id, from_email_address_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params [\"Tjs=\", \"2017-08-17 12:51:04\", \"test\", \"test\", \"2017-08-17 12:51:04\", 1, \"2017-08-17 12:51:04\", 1, \"test\", null, null, null, null, null, 0, null, null, null]:\n\nSQLSTATE[23502]: Not null violation: 7 ERROR: null value in column \"from_email_address_id\" violates not-null constraint\nDETAIL: Failing row contains (4, null, null, null, 2017-08-17 12:51:04, test, test, 2017-08-17 12:51:04, 1, 2017-08-17 12:51:04, test, null, null, t, null, null, null, f, Tjs=)." } ] }

1 2 3 4 5 6 7 8 9

{   "errors": [     {       "status": "500",       "title": "not null constraint violation exception",       "detail": "*DEBUG ONLY* An exception occurred while executing 'INSERT INTO oro_email (serialized_data, created, subject, from_name, sent, importance, internaldate, is_head, message_id, multi_message_id, x_message_id, x_thread_id, refs, acceptLanguageHeader, body_synced, thread_id, email_body_id, from_email_address_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params [\"Tjs=\", \"2017-08-17 12:51:04\", \"test\", \"test\", \"2017-08-17 12:51:04\", 1, \"2017-08-17 12:51:04\", 1, \"test\", null, null, null, null, null, 0, null, null, null]:\n\nSQLSTATE[23502]: Not null violation: 7 ERROR:  null value in column \"from_email_address_id\" violates not-null constraint\nDETAIL:  Failing row contains (4, null, null, null, 2017-08-17 12:51:04, test, test, 2017-08-17 12:51:04, 1, 2017-08-17 12:51:04, test, null, null, t, null, null, null, f, Tjs=)."     }   ] }

I know what it means, but I haven’t seen any atribute in api/doc which I could set to connect the email with the address. Even I haven’t found relationships for email adresses.

I think that it is not generating the api correctly. Because even if I would like to create a Email with attachment. The correct way of doing it (looked in to the entity model). Is to create EmailBody which can add EmailAttachment and EmailBody is then added to Email. The problem is that I can’t see EmailBody in the api/doc/rest_json_api even though it is enabled in the api.yml.

Does somebody please know how to resolve this problem? Thank you :)

Topic