Integromat/Make: 'Fetch all records' functionality needed!
Y
Yachal Upson
I want clients to be able to fetch all records from a table in SmartSuite, for use in another product, via the low-code Make platform (formerly Integromat).
The SS API does allow for paginated record retrieval, but this is a hassle and not suitable for client-empowering low-code applications. The lack of this function directly in Make has broken many use cases and although I will be implementing the HTTP module workaround (see vid below), this makes me want to return to Airtable every time.
Airtable has long had this functionality available on the Integromat/Make platform:
As part of their 'Search Records' Function.
The frustration is shared by another consultant in this section of a recent YT video:
Y
Yachal Upson
1) Transformation of relational/tabular data into network graphs (Nodes, edges). Product breakdown structure analysis and reporting (building and calculating using hierarchical BOM's driven out of relational/tabular data). Anything that involves transferring or analysis whole-of-table data.
2) 300+
3) I didn't actually mention difficulties with the workaround. But:
--a) Case in point - I can't actually get it to work in spite of reviewing the API docs and examining the config displayed in the linked video. I keep getting a 401 - auth credentials not supplied. They are supplied, and I've tried various arrangements. Have not yet tested in raw code separately but will.
--b) The HTTP module breaks from the simplicity of the other SS specific modules provided. Not great for clients.
--c) If it's causing me grief to set up. Imagine what that means to a non-developer/integrator.
Y
Yachal Upson
If that was personally written Jon, thanks for the quick engagement. If it was automated - nice chatbot implementation.
Jon Darbyshire
Hello Yachal Upson! I have a few more questions for you:
- Can you provide specific examples of the use cases that were broken due to the lack of 'Fetch all records' functionality?
- What is the average number of records you or your clients typically need to fetch from a table in SmartSuite?
- Can you elaborate on the difficulties faced when using the HTTP module workaround?