API example

[peterberlin]

Hello

It would be very helpful if someone would post a complete working api example file here in the forum. It should create as a record of a standard entity (Case, Account,..). Maybe in PHP.

This pattern could be used for comparison and testing.

Thank you very much in advance. I'm really looking forward to hearingfrom you.
Best wishes,

Peter

[item]

Hello,
look github of espocrm .. Yuri have make many documentation on howto development with many sample

https://github.com/espocrm/documentation/tree/master/development

.

[peterberlin]

Helllo Item
Thanks a lot for your hint.

[yuri]

Hi Peter,

Here's how to use PHP client https://github.com/espocrm/documenta...t-php.md#usage

API functions for Account entity type: https://github.com/espocrm/documenta...api/account.md

How to make search: https://github.com/espocrm/documenta...arch-params.md

[peterberlin]

Hi, Yuri,
Thank you very much.
I have read your documentation and understand the content. But since I don't know the REST API, there is a very simple question.
The code under "Usage" is the minimum code you need and can extend it or is it just a code snippet?

If you know what all the code looks like that works, you can customize it for your own themes.
peter

[telenieko]

Hello
It would be very helpful if someone would post a complete working api example file here in the forum. It should create as a record of a standard entity (Case, Account,..). Maybe in PHP.

This pattern could be used for comparison and testing.

The web interface uses the REST API for all its calls. I find it very useful to load the Network tab of hte chrome console and just do things, you will see there what API calls are involved in anything you.

For instance, creating an Account calls api/v1/Account

Note that it is specially usefull when managing attachments, documents or related records as you will see there are more than one single call involved.

[telecastg]

I agree with peterberlin that the API documentation is hard to follow, specially for someone like myself who has very little experience building APIs, but the actual implementation is like a lot of great Espo features, very simple yet very powerful.

These are the steps that I took, based on the documentation, to implement an API call to create a new Contact from an external PHP script:

At EspoCRM:

1) Go to Administration > API Users and create a new API user (or use an existing one if you prefer) and write down the generated API key.
2) Go to Administration > Roles and create a new Role for the API User (for example "Contact Agent")
3) Assign the appropriate permissions to the "Contact Agent" role (for example Create, Read, Update Contact entity only)
4) Link the "Contact Agent" role with the API user

At my external application:

1) Create a new script: espo_api_client.php, copy and paste the code for this script from the documentation's EspoApiClient class. https://github.com/espocrm/documenta...t-php.md#class to handle the mechanics of performing the API calls.

API calls are actually implemented using the PHP curl functions but these are quite complicated so the documentation provides a wrap class (EspoApiClient) to perform the calls with minimum coding.

2) Create the php script where I want to implement the API call and process any results if applicable. In my case the code here is:

<?php

require_once('espo_api_client.php');

$my_url = '{{https://your espo web address}} ';
$api_key = '{{here I put the API string generated by Espo for the API user}}';

$client = new EspoApiClient($my_url);
$client->setApiKey($api_key);

$new_contact_data = ['firstName' => '{{new contact first name}}', 'lastName' => '{{new contact last name}}'];

$reponse = $client->request('POST', 'Contact', $new_contact_data);

That's it ! as I mentioned quite easy to implement thanks to the EspoApiClient wrap class.

[peterberlin]

Hi telecastg,
thank you very much.
Your tips will certainly help many users who have no experience with the API.
But my thanks also go to the ESPO developers, who have extended the documentation in many places .
peter

[telecastg]

You're welcome

I also appreciate very much the time taken by the developers to provide documentation.

It is quite understandable that writing instructions for a process that is very familiar to one author makes it very hard to describe in a way that someone without experience can easily grasp. That is why we should encourage EVERYONE to help by posting examples as much as possible.

[esforim]

For forum searching keyword.

API_

[Maryam123]

Can you please tell me which url is to be used and what is the use of this api how can i ustilize it. Im new please help

[arthurmaciel]

When I run the js client on node.js I get:

(node:79836) UnhandledPromiseRejectionWarning: #<IncomingMessage>
at emitUnhandledRejectionWarning (internal/process/promises.js:151:15)
at processPromiseRejections (internal/process/promises.js:211:11)
at processTicksAndRejections (internal/process/task_queues.js:98:32)
(node:79836) UnhandledPromiseRejectionWarning: Unhandled promise rejection. This error originated either by throwing inside of an async function without a catch block, or by rejecting a promise which was not handled with .catch(). To terminate the node process on unhandled promise rejection, use the CLI flag `--unhandled-rejections=strict` (see https://nodejs.org/api/cli.html#cli_unhandled_rejections_mode). (rejection id: 1)
(node:79836) [DEP0018] DeprecationWarning: Unhandled promise rejections are deprecated. In the future, promise rejections that are not handled will terminate the Node.js process with a non-zero exit code.
at emitDeprecationWarning (internal/process/promises.js:161:11)
at processPromiseRejections (internal/process/promises.js:213:13)
at processTicksAndRejections (internal/process/task_queues.js:98:32)

The strange part is that when I run

var data = {
  maxSize: 1,
  where: [
    {
      type: 'equals',
      attribute: 'type',
      value: 'Customer'
    }
  ],
  select: 'id,name',
  };

const querystring = require('querystring');
console.log(querystring.stringify(data));

I get:

maxSize=1&where=&select=id%2Cname

That is, the where clause is not parsed properly. As I am trying to port the client to outside node.js (in my case Google Apps Script) all help would be appreciated.