Lunch and Learn 6/5/2024
01:26 Fetching entities based on state using folder extensions?
16:06 Can I get some information on using SQL query to fetch data?
30:38 "Partial request when fetching records: I created a database query for external database but my returned results say I only have 100 results, but there are 300k rows in table. Is there a setting to get all rows? Second question. I want to update an entity with the Query data. Is the update entity step the option to use?
45:21 "I have 2 questions:
1: in the step: Get Row 1. I can't load the first row, which contains the headers information.
2: in the step String Contains, if I search quotes in the row I get in the previous step, it keeps saying there is no " in the string.
We try to set the properties Source as constant, and set a string. in the debug, we can see it automatic add " to that string.
so when the step get the input of whole row from previous step, it think the original " " at the initial and final position just means it is a string.
When I tried to add step: Join String with separator, or use the merge the plain text in the property, the debug output show extra "" "" are appended