Most of
Underscore's methods work on
collections which is a term they coined to refer to either JavaScript
arrays or
objects. In my opinion the
Underscore documentation does not call attention to this fact explicitly enough. Methods that only operate on arrays appear under the Array section of their documentations:
http://underscorejs.org/ Regarding which method to use to reject duplicates I would use
_.reject() because you will be rejecting
whole records not just an isolated
field if it already exists in the table. See:
http://underscorejs.org/#reject You will need to transform the output of
API_DoQuery to an array of arrays or an array of objects as it returns an XML document. Also, once your data is filtered down to prevent duplicates you will need to reassemble the data into a CSV string as
API_ImportFromCSV is the only method to import multiple records.
Feel free to contact me off-world if you need additional help.
Also regarding the first
User Group Conference in Brazil I came up with a great name and theme song:
QuickBase Mas Que Nada (QuickBase No Way)
https://www.youtube.com/watch?v=zeBDoNBNMro
We can theme the conference around all the great things you can do with QuickBase that are considered "
impossible" with purely native features. I am working on my presentation of using
Lua (created in Brazil!) with
QuickBase:
http://www.lua.org/
