Assistance regarding API results?

[abidoss]

Hello friends, I have a JSON file with this information. When I received the file, I wanted to create leads with the information from this JSON content, but I see that it only created a single line with the first ID

json

[
  {
    "userId": "4",
    "lastname": "TEST",
    "firstname": "Ahmed"
  },
  {
    "userId": "7",
    "lastname": "TEST",
    "firstname": "Mehdi"
  },
  {
    "userId": "16",
    "lastname": "TEST",
    "firstname": "SARA",

  },
]​ 

[yuri]

I added the ability to parse the whole JSON with empty path for the next hotfix release https://github.com/espocrm/espocrm/issues/2880.

You will be able to put the JSON into a variable. It will be an array. Then by using while statement, you can call record\create for every item. You will also need to use object\get, example: $id = object\get($item, 'id');

If you need to call an API endpoint to create records in a different instance, you can utilize BPM with multi-instance sub-processes (instances per each parsed item).

[abidoss]

I used this but I get error

$data = json\encode($_lastHttpResponseBody, true);

$userId = object\get($data, 'userId');

description = $userId


[2023-10-27 19:41:38] ERROR: Workflow[6535a3db68e8691bd]: Action failed [executeFormula] with cid [3], details: function: object\get, index: 1, should be: object.

[yuri]

On v8.0.4

$list = json\retrieve(workflow\lastHttpResponseBody());

$i = 0;

while ($i < array\length($list)) {
    $item = array\at($list, $i);

    $userId = object\get($item, 'userId'); 
    $lastName = object\get($item, 'lastname');
    $firstName = object\get($item, 'firstname');

    record\create('Lead', 'firstName', $firstName, 'lastName', $lastName, 'userId', $userId);
 
    $i = $i + 1;
}

[abidoss]

Thanks Yuri, it works now

[abidoss]

Let's say I have 8000 IDs in my JSON file that I initially created using "record/create." After 2 days, my JSON file contains 8200 IDs. How can I add only the additional 200 IDs without it recreating all 8200 IDs and ensuring that it checks for existing records with the same name?

[rabii]

You just have to loop through the ids and compare them to existing ones in your db and create new ones, below is an example:

$list = json\retrieve(workflow\lastHttpResponseBody());

$i = 0;

while ($i < array\length($list)) {
    
    $item = array\at($list, $i);
    
    $id = object\get($item, 'id');
    
    if (record\exists('YOUR_ENTITY_TYPE', 'id=', $id)) {
        continue;
    }
        
    record\create('YOUR_ENTITY_TYPE', 'id', $id);
 
    $i = $i + 1;
}​​ 

[abidoss]

Good news, I tried this code, and the workflow doesn't give me any errors, and it doesn't recreate all the identifiers again. So far, that's good, but it doesn't update the rest of the identifiers. If I have 8000, it still stays at 8000 with your code.

[rabii]

Hey,

Try this instead:

$list = json\retrieve(workflow\lastHttpResponseBody());

$i = 0;

while ($i < array\length($list)) {
    
    $item = array\at($list, $i);
    
    $id = object\get($item, 'id');
    
    if (!record\exists('YOUR_ENTITY_TYPE', 'id=', $id)) {
        record\create('YOUR_ENTITY_TYPE', 'id', $id);
    }
 
    $i = $i + 1;
}​ 

[abidoss]

Thank you, Rabii. I will try.