0

We use vTiger query Rest API to extract the ticket data to use it for reporting purposes - currently, we have 500,000+ tickets. Considering that one can extract 100 records per page, it takes hours to pull the entire dataset. What are we missing/what options are we not aware of from vtiger to pull the data on a daily basis?

The single option proposed by the support team was to use a reporting module.

Update: we use vTiger Cloud. The database backup can be shared by the support team once every 6 months.

Ekaterina Ponkratova
  • 27
  • 4
  • It is unclear where the database is located. Is it located on an in-house server, or on some-cloud-based server ? You can always get a backup of that database, and restore it on a local MySQL database, and do some free reporting...... (sure it will take time because you need to know the structure of that database..) – Luuk Jun 14 '23 at 18:53
  • @Luuk, thank you for the comments! I've updated the question. – Ekaterina Ponkratova Jun 14 '23 at 19:26
  • 1
    If you can only get a dump of your database once every six months, I would strongly consider looking for an alternative service, especially if they don't offer you alternatives to access YOUR data. – psauleda Jun 16 '23 at 06:47
  • 1
    Just use sync method on Rest API and fetch records that modified from certain timestamp! – Hamid Jun 21 '23 at 20:41

0 Answers0