Hi Geoff,
i'm not sure to understand what you mean and what you are trying to accomplish.
JSitemap has a system to fetch data from a database and generate URLs, but the way that URLs are generated is completely outside JSitemap and it's the same that Joomla uses.
Reference:
https://storejextensions.org/faq/does-jsitemap-generate-urls-or-is-responsible-for-that.html
There are plenty of available and ready data sources for components out there. If you are trying to develop your custom data source for a specific component, my advice is to read the PDF docs at the paragraph 'SQL Query Compiler' where you find a step by step example to understand a bit better how the SQL based data source works.
Also the way that queries are set is not always directly related to the format of 'pretty' URLs generate by various routers.
If you have instead a very specific system that i ignore and that holds certain URLs in the database already formatted and if you want to pull them in the sitemap, probably the only way to do this is to develop a plugin data source using the JSitemap API. You can request the API SDK in such case, contact me at
This e-mail address is being protected from spam bots, you need JavaScript enabled to view it
The final alternative would be using the 'Links' type data source, but in this case you should specify links for the sitemap one by one manually.
Best regards,
John