Hello.
I would advise to check our development documentation, it contains a comprehensive explanation on how to use REST API and how to pull data from X-Cart database.
*
https://devs.x-cart.com/rest-api/
REST API allows to pull absolutely every single data entity from X-Cart.