Adding Zapier as form storage option

Site URL: http://redbow.org.nz/our-programmes

Hi,

I'm using Zapier as storage option for my Newsletter and Form blocks.

It seems like Squarespace integration with Zapier is quite immature. Zapier makes a request to Squarespace to pull the data of the forms available as follows when creating a trigger:
POST Request: https://zapier.com/api/v4/implementations/choices/

Body: {
  "selected_api": "SquarespaceConvertedCLIAPI@1.8.0", 
  "authentication_id": 33781047, 
  "params": {"formId": ""},
  "page": 0,
  "prefill": "form.id.name",
  "system_context": {"gulliver": {"zap_id": "159360612"}}
}

Content-Type: application/json
Other headers: Not provided for security reasons, but they are not relevant to investigate this matter.
 

Response:
{
    "success": true,
    "choices": [
        {
            "key": "613ae6bf6bbdea61fd41c5b1",
            "label": "Newsletter Form",
            "sample": "613ae6bf6bbdea61fd41c5b1"
        },
        {
            "key": "61898128dbf09e656ab1039f",
            "label": "Newsletter Form",
            "sample": "61898128dbf09e656ab1039f"
        },
        {
            "key": "61ad7d1f5bbad1528304a4a3",
            "label": "Sign up form",
            "sample": "61ad7d1f5bbad1528304a4a3"
        },
        {
            "key": "62b6801d6bc8b546cafb9434",
            "label": "Sign up - Join TRB Journey",
            "sample": "62b6801d6bc8b546cafb9434"
        },
        {
            "key": "62b69d8a88dc6309c35ba9b0",
            "label": "Contact Us - Question or Feedback",
            "sample": "62b69d8a88dc6309c35ba9b0"
        },
        {
            "key": "62b6a534fd8b381bc8241701",
            "label": "Contact Us - Support",
            "sample": "62b6a534fd8b381bc8241701"
        }
    ],
    "next_page": null
}

There are 6 forms in that list, I have a total of 9 forms in my site. I can't locate one of the forms in that list at all. That's a mystery, although it bothers me, that's not the problem. The problem is that the forms that should display in Zapier are not displaying, and the reason is that Squarespace is returning that as response, so Zapier just shows what Squarespace sends.

There is a form at the bottom of the page www.redbow.org.nz/our-programmes. The form's data-form-id, that's how Squarespace refers to the form Id is: 62b6bdf62563205d918d6f1e does not display in the response above but it's an active form using Zapier as storage option.

Back in Zapier:

- When creating a new Zap the form with id 62b6bdf62563205d918d6f1e doesn't display. 

- If the Zap where the form 62b6bdf62563205d918d6f1e is used as part of the trigger is turned off and on, an error happens.

These wrong behaviors are due to the response of the POST request above.

To me this is a critical bug in the Squarespace API. I have tried to find the API related to forms but I have only been able to find apis related to Ecommerce stuff.

I would appreciate if a Squarespace Expert could have a look into this matter. It's my understanding that Zapier logged a support ticket called "Published form missing from New Form Submission dynamic dropdown #4" for Squarespace to look into this. There are more people affected.

If someone has more information about this issue, please share the love.

The reason why I'm putting this information here is because this bug has given me huge headaches and still does. So I wanted to share it with other customers that might be facing the same problem. I have had also very bad experiences dealing with Squarespace support until the took my matters seriously, so I hope I get better results with the community.

Last but not the least, from my deep testing I think  this issue might be related with disabling and enabling pages with forms.

Thank you for your time,

Natalia

I suspect there won't be much we can do to help if the issues are on the backend of SS.

I think your feeling that SS's depth of implementation for form handling is immature is correct. It's like they got a start on it but didn't come back around and deepen the features. If I recall correctly the features available to some forms are not supported across all form elements (there are some that shouldn't, of course, because of their context). I suspect that SS not making another pass on form features like Zapier support is due to most folks just don't use it so it is a low priority issue. Which of course is frustrating for folks that actually need the feature and for it to work well and consistently.

I'm not aware of an SS published forms API.

You might need to go with a forms company whose focus is forms to get what you need. That won't work for all SS forms but should for form blocks.

Hi Creedon,

Thanks for coming back to me and provide your opinion.

I'm not sure why the forms API is not public in the same way as the Commerce API is.

It's funny that premium features related to customers who pay for upgrade plans to access to them are not being taken care of by SS properly. It's very disappointing. That doesn't say anything good about SS, that's for sure.

I will leave this open to see if someone else has anything else to share.

Take care,

Natalia

Hi,

I have added a new form called Test form as I'm doing more digging into this. Just in case that a tester/developer from SS looks into this and sees 7 forms in the REST response instead of the initial 6. The following is the data in the response related to the Test form:

 {
   "key": "62b967e82563205d91bb483c",
   "label": "Test form",
   "sample": "62b967e82563205d91bb483c"
}

Thanks,

Natalia

4 hours ago, Natalia_TRB said:

Just in case that a tester/developer from SS looks into this

Squarespace employees do not respond to requests for support via the forum (see item 6 of the forum guidelines). If the Zapier integration isn't working as expected, I recommend that you contact Squarespace Customer Care directly to report your concerns.

Hi Paul,

Thanks for your reply.

I did also open a support request with SS pointing to this post link. But I prefer to leave this post open to see if someone else in the community has something to input. Unfortunately, SS doesn't notify customers when there are bugs or problems in their software. These forums is the only way we customers have to share these matters with the community until SS changes the way they notify their customers about their issues.

Thanks,

Natalia

Update: SS has indicated that they are going to escalate this ticket for review and that they will reply back with more information as soon as possible.

I will keep you posted with any news I get from them.

Cheers,

Natalia

I've also been having issues very suddenly

I can get everything connected with Zapier, can even run the test through Zapier and everything works great. However, it will not trigger when a new form is submitted. No errors shown in Zapier, and the form sends to other storages just fine.

Very frustrating as this sudden issue has caused me to miss opportunities to reach out to clients quickly, and likely miss business.

I am not sure if this has any relation to what was previously discussed in this thread, I didn't understand much of the technical discussion. Other than, it appears that SS is not communicating with Zapier properly. 

Hope this adds some nugget of information to the issue and is resolved soon.

Hi Zak,

Sorry to hear you are also having problems. It could be related to the problem I'm facing. I do recommend doing the following in Zapier:

1. Create a new Zap, call it test-zap or something like that. I have a zap to use just for testing.
2. Set submitting a form from SS as trigger.
3. Check what forms display in the drop-down list when it comes to select a form.
4. If the forms are not displaying there, VOILA! If the forms are still there, you will need to do more trouble shooting. Like turning the Zaps on and off, reconnecting your Squarespace connection in Zapier, disconnect and reconnect the forms in SS again, etc...

In my case the problem is that the SS Forms API is not listing all the forms I have on my site. No idea why and this is what I'm trying to get an explanation for. To me it's a bug unless a page and/or form need to have a specific status and storage option selected to display when a request is made.

Let me know how you are getting on.

Best of luck,

Natalia
 

Hi,

Squarespace has come back to me indicating that there is some odd behavior happening where some forms are being picked up by Zapier and some are not.

They said that they have noted this down for the Design and Engineering teams to review. So hopefully they take this issue seriously and do something about it. It's obvious there is a bug in their forms API. This is nothing to do with Zapier, the SS forms API is not working as it should be. Zapier just displays the forms that the SS API returns.

I'll keep you posted with any updates.

Cheers,

Natalia

Hi guys,

Just giving you an update about SS. These are the words from the Product Specialist:

Quote

"We’re unable to guarantee a follow-up or offer an ETA for resolution, but I can assure you that appropriate teams have been notified about this issue and are working on a fix as soon as possible."

Unfortunately, I don't think they will do much about it, otherwise they would have said something like "we are working on a solution and we'll notify you as soon as there are any updates."

The reason why I'm sharing all of this with you is for you not to have any expectations at all when it comes to SS Customer Care support. Very disappointing, but that's how it is.

Have a good day,

Natalia