I am in a situation where I need to use data from an API (XML) served by a third party in my WordPress site. The data will be updated on that third party application.
Specifically this is data about properties that is stored on said 3rd party web application. The data is made available in XML format. I would like to allow displaying of this data in a WP website, as well as searching, and eventual portal to said application for booking.
At the moment I have three options, and I would like to know if one is preferred over the others.
Store an xml with all data as using transient API in WordPress and access the data using Ajax in a post template
Store an xml with all data as using transient API in WordPress and access the data using php in a post template
Importing the data into the WP database as custom posts and associated metadata?
The data is only available as an XML format (which is why I mention it).
My specific worries are that not having the data stored in WP database might lead to inability to search/sort data using WP functions.
I am just beginning development of a plugin now, and the decision as to how to utilise the data will dictate the direction of development.