Hi there,
Many of the projects that I work on which I could use Amelia for, I end up not using Amelia because your templates you have made do not fit the use case correctly and are not flexible enough to allow me to change them.
So what I would like to do is to code my own templates - but in order to do that I need to know how to query the data stored in Amelia.

Normally I would query custom post types, custom taxonomies, custom fields etc, but it seems that the data created by Amelia is not stored in the 'Wordpress way'. Unless I am mistaken?

Please can you help?

Thanks,
Keith

Hi Marko, thanks for your reply. I'm trying to understand more what you have sent me and also tried to query data via your API but nothing is working.

For example, I would like to query all of the 'Services' I have setup in Amelia, but I cannot see anywhere in your documentation where it explains how to do that.

I have used Chat GPT to try and help me code this and this is the snippet I am using:

<?php
$response = wp_remote_get('mysiteURL/wp-admin/admin-ajax.php?action=wpamelia_api&call=/api/v1/services', [ 'headers' => [ 'Authorization' => 'Bearer MY_API_KEY' ]
]);

if (is_wp_error($response)) { // Handle error $error_message = $response->get_error_message(); echo "Something went wrong: $error_message";
} else { // Process the data $data = json_decode(wp_remote_retrieve_body($response), true); if (!empty($data)) { // If you want to see the full structure of the fetched data, uncomment the next line. // echo '<pre>' . print_r($data, true) . '</pre>';
// Display just the count of services for now. echo 'Number of services fetched: ' . count($data); } else { echo 'No services found.'; }
}

?>

I have of course here swapped my URL and my API key for dummy text.

This does not return any data, when I know that I have 15 services setup in Amelia.
Please can you provide instructions on how to query the services setup in Amelia? Or at the very least how to get all of the ID's for the services

Hi Marko, thank you very much to you and your dev team for such a helpful and detailed reply :)

I am going to try this and see if I can get it to work. I will report back.

Thanks again,

Keith

Hi Marko, so from the code snippet you have sent me I have now been able to make a code snippet which queries services and displays the service name, description and price which is great. However, I have also tried to display the category of each service but this does not seem to work (and I know that all of my services have been applied to various categories).
So, I am guessing that I will need to look more at the 'amelia api all.postman.json' file you sent me. However, I have not used the 'Postman' system before and I was wondering if you can offer some guidance:

- I have created an account on postman and logged in
- However from there I do not know what to do to find examples of the PHP cURL code (like what you sent me in the image in a previous reply). Do I need to upload that file 'amelia api all.postman.json' file into Postman? And if so where / how in Postman do I do that?

Thanks again so much for your help

Hi Marko, thank you again to you and your dev team for the helpful reply. 

I have now been able to successfully import the postman collection you sent me and I can see all of the different API calls inside the application (matching the screenshots you sent me). This is great :)
I will now work on developing my code further.
As we are still talking about querying data from Amelia I did not think I would need to open a separate ticket here (plus I think this entire thread will be very helpful for other users of Amelia), but I will of course open up separate tickets if the subject was to change.

Thanks again for your help and have a great weekend,

Keith