How to display results from CRM?

Question

XML

In general, a server from one CRM system takes data in the form of xml with all employees.
The server is supposed to request information, for example, about one employee with some numbers. This number is naturally stored in one of hundreds of fields.
It comes to my mind to sort through the entire array and compare the numbers, and when found, give out. But I don't like this way at all. And not "fast".

Note: you cannot save to your database, since the data in crm changes sometimes.

Answer 1

If the data in XML is not updated every minute, then you can take XML, parse it and save it to the database once an hour, for example, or once a day using CRON

Answer 2

you cannot save to your database, since the data in crm changes sometimes.

And what's the problem? Fill in the data in tables with a prefix for example tmp. When will be filled in - you change these tables with current workplaces. Delete old tables.
This option is suitable if you have no id collisions.
In the case when collisions are still possible - it all depends on your specific task.

Answer 3

Note: you cannot save to your database, since the data in crm changes sometimes.

Strange note. you can insert a line with user data into the database and add the date when the data was downloaded to the line. Then, in order to get an up-to-date data set, you need to take a sample by the most recent date. Old data after updating the database can be thrown out or used in some strange way, for example, showing users as deleted...