Thanks Mark, as always.
I think my first question to solve is -- given data like this - what's the quickest way to do lookups / updates in bulk.
| Rep Name | Employee_ID | FSA | COID | Store Code | Knock Status | Created DateTime |
| Joe Smart | MH7J | 1012A | CRCD | ICI089 | Successful Order | 2024-11-07T22:08:01 |
| Jim Smarter | MG2C | LOND | ICI171 | Successful Order | 2024-11-07T22:08:01 |
In this example, my employee ID is not a key field -- long story, but my folks might have any number of IDs given what contract they're on. What I need to do is look up this employee ID with the related record ID on the person table.
Using pipelines; mostly because I like to keep it as consistent -- what is the most efficient way to update this table where the employee ID from this staging table matches the related Person ID (ie the record ID from the Employee table).
I do this rather a lot for various things, but it's slow -- Search Records where Employee ID matches, return the Record ID, Loop over the search results, Update record, do it again. Seems to take the API 1-2 seconds to do this lookup.
I just tried a bucket -- Defined a Pipeline Table, Search Records from Client ID table, pulled my employee ID, added the row in memory -- but the same steps for looking up the bucket table as with the quickbase table -- and not appreciably faster.
