Skip to main content
Question

Acuity month Parameter

  • November 18, 2024
  • 5 replies
  • 28 views

Noob_developer

Hey guys, 

I'm building a Zap that uses the Acuity Scheduling API to retrieve available appointment dates. I'm encountering an issue where the month parameter in the API request isn't accepting the dynamically generated "YYYY-MM" format from a "Code by Zapier" step.

I've confirmed that the code correctly outputs the "YYYY-MM" value as a string, but it doesn't appear as an option in the month parameter's mapping dropdown. I've tried refreshing the Zap, reconnecting my Acuity account, and explicitly defining the output type in the code, but the issue persists.

Could this be a bug or limitation in how Zapier handles data types or mapping between the code step and the API request action? Are there any workarounds or suggestions you can provide?

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

5 replies

Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • November 18, 2024

Hi ​@Noob_developer 

For us to have more info, post screenshots showing how your Zap steps are outlined and configured in EDIT mode with the field mappings.

Also, link to the Acuity API endpoint documentation you used to configure the API request.


JammerS
Forum|alt.badge.img+6
  • Zapier Staff
  • November 19, 2024

Just to advise, when posting a screenshot to the Community, it is essential to obscure any sensitive information within the screenshot for security purposes. Thank you. We're looking forward to troubleshooting your issue further.


Noob_developer

Hi ​@Noob_developer 

For us to have more info, post screenshots showing how your Zap steps are outlined and configured in EDIT mode with the field mappings.

Also, link to the Acuity API endpoint documentation you used to configure the API request.

 

Hi, here are some screenshots, and the link to the Acuity API endpoint documentation below.

 

The screenshots in order:

  1. screenshots 1 and 2 showcase the result of my API request action’s test step.
  1. Shows the configuration of my API Request action, and the month parameter's mapping dropdown. (As you can see, the month parameter is currently set to a static value, but I want to dynamically populate it with the yearMonth output from the Code step (screenshot 3 ).)
  2. Shows the successful execution of my "Code by Zapier" step, which correctly outputs the yearMonth value in the "YYYY-MM" format.

https://developers.acuityscheduling.com/reference/get-availability-dates

 



 

 

 

 


Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • November 20, 2024

@Noob_developer 

For the Acuity API request configured in the Zap step, the Query String Parameter “year” is not a supported option from the API endpoint documentation, so make sure to remove that.

Screenshot shows the Acuity API request without a variable mapped to the “month” query string parameter.

Screenshots show the Acuity API request as Zap step 2, but it is unclear what Zap step the Code step is.

The Code step would need to come before the Acuity API Request Zap steps, so you can map the variable from the Code step.

Also, instead of using a Code step, you may want to try using this Zap action: Formatter > Date & Time > Format

NOTE: Zap steps that use the Formatter app count as 0 Tasks in Zap Runs.

Help for Formatter: https://zapier.com/apps/formatter/help

Help link about using system generated timestamps in Zap steps: https://zapier.com/help/create/customize/insert-the-time-your-zap-runs-into-a-field

 


SamB
Community Manager
Forum|alt.badge.img+11
  • Community Manager
  • November 26, 2024

Hey ​@Noob_developer 👋

Just came across this and wanted to check how you got on with Troy’s suggestions here—did they do the trick?

Want to ensure you’re all set here so please let us know if you’re still stuck at all. Would be happy to assist further! 🙂