ContributionsMost RecentMost LikesSolutionsRe: Calling do query API does not return all lines in a field Turned out to be an issue with Pyhton's <a target="" rel="" href="https://docs.python.org/3/library/xml.etree.elementtree.html#module-xml.etree.ElementTree" alt="" title="xmletreeElementTree Implementation of the ElementTree API" name="" value="" type="">xml.etree.ElementTree</a>.<br alt="" title="" name="" value="" type="" target="" rel="">The data I am pulling from QB is in JSON format -- the ElementTree library was failing to parse the multi-line structure -- it was returning only the characters before the first line break. Solution was to use the following command to parse the field: <br alt="" title="" name="" value="" type="" target="" rel="">' '.join( list( field.itertext() ) )<br alt="" title="" name="" value="" type="" target="" rel=""><br alt="" title="" name="" value="" type="" target="" rel=""> Calling do query API does not return all lines in a fieldI'm using the API to extract records from a table. One of the fields in the table contains text that looks like this: { "requireValidParent": "no", "projects": "56", "phus": { "massDelta": { "locations": "2,3,6,7", "min": "-0.05", "max": "0.01" } } The API call only returns '{' for the text in this field. Re: Automation: Update a TIME fieldThanks!Automation: Update a TIME fieldIs it possible to update a TIME field using an Automation? When trying to build an Automation the TIME field from my table is omitted from the "select fields" list...Automation: Atomicity and LockingDo Automations run as an atomic transaction and/or perform any row/table locking while they run? Wondering if/how my application will behave when multiple users simulataneously run Automations.Re: Automation: Using data from previous trigger record or previous actions.Hi John -- thanks for the note... Well...the instructions say ""....choose as much data as you want from your trigger record or previous actions"...guess I'm trying too figure out exactly what this means, seems like the instructions are quite vague. So...you're saying...given an automation with several actions: 1. Use one action to put some date in a table 2. Configure a second action to act on the data from step 1 3. Lather-rinse-repeat as needed...Correct? HHhhmmm...seems like an interesting technique...thanks! OK -- what about manual entries? What sort of operations are possible? Plain text? Formulas? Any other sort of command/script? Date-Time Field: Options for precision?I've noticed the precision of [Date Created] and [Date Modified] is in milliseconds... However, user-defined Date/Time fields seem to be limited to minutes??? Is there a way to adjust the precision of user-defined Date/Time fields? Automation: Using data from previous trigger record or previous actions.Automations do some GREAT things...but when building an automation I often muse over the embedded instructions that say "....choose as much data as you want from your trigger record or previous actions. You can combine this data with manual entries." How can I get data from a previous action? Is there some sort of formula or scripting which provides access to the process flow? What sort of "manual entries" are possible? Plain text or some sort of formula/script?Re: Automation: Can create but can't manageThis reply was created from a merged topic originally titled Automation: Can create but can't manage. Working with an admin account... Occasionally, I can create an automation, but then can no longer edit/delete/disable it... The other automations I have created seem to operate normally, but I'm stuck with one that can no longer be controlled...with unpredictable results!Automation: Can create but can't manageWorking with an admin account... Occasionally, I can create an automation, but then can no longer edit/delete/disable it... The other automations I have created seem to operate normally, but I'm stuck with one that can no longer be controlled...with unpredictable results!