Help with using a query in HTTP API call

[Jayne_Smith]

Hi,

I am very new to Make and I’m stuck! I am trying to use an API call to get all the existing data from our booking system with an event date beyond a certain date and drop it into a Google Sheet. I only need to do this as a one off as I have a scenario in place that will add new and update existing bookings.

The API call works fine and returns data but it returns everything back to 2016! My module looks like this:

I have tried with and without quotes/double quotes around the date, but it has no effect it still returns all the old data.

This is the documentation from the system website. It doesn’t mention anything about querys so it may be that I am trying to make it do something it’s not capable of!

I can’t just do a data dump from the system itself as that doesn’t include the UIDs that I need for the update scenario to work.

Any advice/help you can give would be much appreciated.

Many thanks,
Jayne

[Msquare_Automation]

Hi @Jayne_Smith

Could you please confirm if you’re looking for the most recent attendee information? If you could provide a bit more context or details, we’ll be happy to assist you further.

Best regards,
Msquare Automation
Platinum Partner of Make
@Msquare_Automation

[Stoyan_Vatov]

Hey Jayne,

yeah the documentation says you can only pass Event attendance UID as a path parameter and doesn’t say anything about queries or having a body. I suppose you can filter the result afterwards.

[Jayne_Smith]

Thanks all for your responses.

I decided in the end it was easier to change my search/filter criteria in my other scenario and just take a data dump straight from the system. All sorted!