List companies api, no modified date returned?

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:


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?

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 expressions don’t seem to allow ‘or null’

Any suggestion?

        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
                                        } )