# List companies api, no modified date returned?

**URL:** <https://forum.mautic.org/t/list-companies-api-no-modified-date-returned/21788>\
**Category:** Product Support\
**Created:** [November 26, 2021, 5:33pm UTC](https://forum.mautic.org/t/list-companies-api-no-modified-date-returned/21788 "2021-11-26T17:33:42Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![donbowman](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/donbowman/32/5702_2.png) [@donbowman](https://forum.mautic.org/u/donbowman)\
**Post date:** [November 26, 2021, 5:33pm UTC](https://forum.mautic.org/t/list-companies-api-no-modified-date-returned/21788/1 "2021-11-26T17:33:42Z")

</div>

**Your software**  
My Mautic version is: 4.0  
My PHP version is: 7.4  
My Database type and version is: tidb

**Your problem**  
My problem is:

curl -u USER:PASSWORD ‘[https://mautic.agilicus.com/api/companies](https://mautic.agilicus.com/api/companies)’

I am returned a set of companies, but i cannot see the date\_modified.

I see:  
id, score, fields.

of the fields, i see core, professional, other, all

none of these have any date or other info.

I am trying to do some sync w/ an external db, and its forcing me to fetch all all the time.

sicne there is no filtering, i cannot query SINCE some time (where mod time \> X), and,  
since I cannot see the mod time, i cannot bail out of my loop early.

Any suggestions?

---

<div class="post-metadata">

**Author:** ![donbowman](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/donbowman/32/5702_2.png) [@donbowman](https://forum.mautic.org/u/donbowman)\
**Post date:** [November 28, 2021, 10:24pm UTC](https://forum.mautic.org/t/list-companies-api-no-modified-date-returned/21788/2 "2021-11-28T22:24:14Z")

</div>

related… creating a company sets the ‘date\_modified’ to null. I think this should be ‘now’.

I’ve found a way to list the ones ‘since’ some time, (below), but i cannot also get ‘date\_modified’ isNull.

> **[The QueryBuilder - Doctrine Object Relational Mapper (ORM)](https://www.doctrine-project.org/projects/doctrine-orm/en/2.7/reference/query-builder.html#the-expr-class)**
>
> Doctrine Object Relational Mapper Documentation: The QueryBuilder

the expressions don’t seem to allow ‘or null’

Any suggestion?

```auto
        mt = Mautic.contacts.list(params = { "start": start,
                                        "limit": page_size,
                                        "orderBy": "date_modified",
                                        "orderByDir": "asc",
                                        'where[0][col]': 'date_modified',
                                        'where[0][expr]': 'gte',
                                        'where[0][val]': last_iso,
                                        'minimal': 1
                                        } )

```