Lunch and Learn 6/5/2024

DecisionsTraining

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