Discussions

I am trying to set up an integration using a webhook in Kommo and a MySQL database. I have successfully extracted the information and stored it in the database, but I am facing an issue with a custom field. The only thing left is to add this field.

The field is a custom "date and time" field, which arrives in the same format as the rest of the custom fields. In this example case:

    - id: 550002
      name: appointment 
      values:
        - value: "1750600400" 

The code I currently have to capture the custom fields is this:

    if (isset($lead['custom_fields']) && is_array($lead['custom_fields'])) {
        $conn->query("DELETE FROM lead_custom_fields WHERE lead_id = $lead_id");

        foreach ($lead['custom_fields'] as $field) {
            if (!empty($field['values'])) {
                foreach ($field['values'] as $value_entry) {
                    if (!empty($value_entry['value'])) {
                        $field_name = $conn->real_escape_string($field['name'] ?? '');
                        $field_value = $conn->real_escape_string($value_entry['value'] ?? '');

Let's see if you can help me, as I don't have much knowledge and I can't get the information to be stored in the database like the rest of the data.

Sorry for my English, and thanks in advance! 😉