Public API & Zapier Improvements/Ideas | Voters

Public API & Zapier Improvements/Ideas

complete

Dean Vizer

Now that Public API and Zapier are out in beta we want to hear what you have to say and which endpoints you would like created

April 27, 2020

Dean Vizer

marked this post as

complete

To make this easier to maintain, it has been split out into the following tasks:

Future roadmap entries will be made about a particular feature of Siteglide. This ensures that you can easily track progress of each group of Public API endpoints

Votes have been moved accordingly

Matt Walter

marked this post as

in progress

Martin Sanderson

John Atkinson - endpoint for ecommerce products

John Atkinson

I have a B2B portal to build for a cabinet maker who has SKU's in Zoho I want to treat them as Ecommerce products and manage the data from Zoho he will absolutely not allow double key of product data. If I can achieve this then SiteGlide is the platform of choice.

Devon Reehl

Dean Vizer One thing that would unlock quite a bit for integrations would be to be able to search by Email in the User Search, not just by ID. In most cases, we won't have the SG ID of the users in a separate system, and I can't think of a way to get it. Make sense?

Devon Reehl

Dean Vizer Any update on the ability to get a user search by email, not just by ID?

Dean Vizer

Devon Reehl: I've got a version working internally.  Just need to do some more testing and then release.  
Should be in the next few weeks. Currently it is an update to the existing endpoint where instead of ID you could just type in an email address instead
EDIT: This is now live, the /api/public/site/users/crm/{id}
 endpoint now accepts either an ID or an Email Address

Casey Jeppesen

Why can't Zapier access Modules?
We need to be able to publish blog articles remotely.
..in order to get started more quickly, we attempted to rebuild the 'blog module' as a 'webapp'.  Unfortunately, we are running into more constraints.  In order to continue, we'd like to see this functionality added to Zapier:
 Create Module Item
 Upload Image (file blob)
 Get Categories
 Create Category
Re: Categories - this is very important.  It would be best if you wrote the id/name logic on your side - so we can 'create category' with Name, Slug and Parent Name.  This would save us a lot of headache (not having the "id" of the category available).  For instance, we want to create a category called "jet" and make it a subcategory of "airplanes".  We'd simply send those terms, and your API would query categories for "airplanes" - find the id, and set that as the parent category id for new term "jet" (and return the new term id & parent term id in response).
I realize this may present problems on duplicate term names, so might be best to use "parent slug" instead.  
I really hope you can get these things implemented soon, it's rather urgent for us.
Thanks!

Dean Vizer

Casey Jeppesen: Hey Casey,
Thanks for the feedback, some specific answers:
Modules - This hasn’t been added yet simply as we had focused on other areas and no one had requested it yet, will add them in the next round of updates though.
Images - Will have to investigate this more but it should be possible
Categories - There may be a way in Zapier that we can pre-load the current categories so when adding a new one you can pick from a drop down of existing ones.This would be similar to how picking your WebApp for a new item would work

Casey Jeppesen

Dean Vizer: Thanks Dean!
Re: Modules, when can we expect the next round of updates?
Re: Images - looking forward to it.
Re: Categories - adding a category via drop-down won't exactly solve our problem.  We need to be able to post a new blog and assign it to a category (or create new cat) automatically.

Dean Vizer

Casey Jeppesen: We don’t have any dates for the next round of updates at the moment, but I’ll update this task when we do.
For categories, with each endpoint (create module item and create category) being an action, that should mean you can chain the actions together in your zap.  So your zap would look something like Get Data -> Create Category -> Create blog post, with the last action having your new category already available to it.
Hopefully that makes sense!

Brendan Byrne

Hey Dean, 
connecting up Zapier and we keep getting this error in Zapier: "We’re having trouble loading 'Form ID' data
The app did not respond in-time. It may or may not have completed successfully."  
Does not seem to stop the zap from working - or at least testing successfully...

Dean Vizer

Brendan Byrne: Hey!
That error is related to the "Form ID" field, what it should do is load dropdown list of forms so you don't have to manually enter the ID of it.  As this doesn't affect the overall zap it should continue to work correctly which it looks like you're seeing.
I've taken a look at that account from our logs and there is a form which looks like it has been made via CLI (form_5).  If it helps then that form can be deleted via GraphQL so that the dropdown then works correctly.
I will also update the API so that it will automatically ignore forms that do not have a valid structure to work correctly with zapier

Dean Vizer

Brendan Byrne Just to update you that an API side update rolled out yesterday to automatically exclude forms that do not have a valid structure. This should solve the above error across all accounts

Devon Reehl

GET: When web app item is updated
GET: CRM user is updated
POST: Update CRM Record (including Secure Zone access)
POST: Create a Case

Dean Vizer

Devon Reehl: Zapier app v1.0.1 is now live with the following updates:

Create case
Create WebApp Item
Update WebApp Item
Create User
Update User
Get eCommerce Orders
Get eCommerce Products

Devon Reehl

Dean Vizer: Awesome work man!

Devon Reehl

Dean Vizer: Question on this - if I go to update a CRM user, how can I update their SZ access? These are the only fields I see: https://www.screencast.com/t/iIt8yTVYG

Dean Vizer

Devon Reehl: Is there a "refresh fields" button? It should display more fields and there is a warning at the bottom that says "Having trouble receiving custom fields"

Edit: A fix has been rolled out on our API for the above issue