Jira
Connector
The Jira connector is fairly standard. It asks for your username, password and URL. Your URL will be something like: https://starfishetl.atlassian.net. Your "password" may not be your password. In some, or all, accounts, you must supply an API key as your password. To generate an API key, as of this writing, open the "Settings" gear icon -> Atlassian Account Settings -> Security -> Create and manage API tokens. Create a Token for Starfish to use and put that into the "password" field.
Origin Filters
Date Time
To filter by Date/Time, Use:
updatedDate>="2021-08-12 10:40"
Please note that Jira Query Language does NOT support seconds. See this post: https://community.atlassian.com/t5/Jira-questions/Jira-API-JQL-Datetime-Format-Doesn-t-Support-Seconds-and/qaq-p/1476275.
Sorting
Append "order by FIELD ASC/DESC" to your Criteria
order by updated ASC
Inserting a File
To insert a file, create an Insert Stage for the attachment table. Pass the file to the attachment byte[] field. In this case, I was reading from SugarCRM, so I did not need to convert the object returned by the Smart Lookup.
object ScriptedField() { string result; result = ""; object att; byte[] data = Encoding.ASCII.GetBytes(""); //Starfish.LogMessage(Starfish.GetJSON(attachmentIndex,"id")); att = Starfish.SmartLookup("Notes","attachment","[{\"id\":\"" + Starfish.GetJSON(attachmentIndex,"id") + "\"}]",false,"","ORIGIN"); if (att == null) { //If the returned object is null, we do not want to insert no attachment. Starfish.GotoNextRow(); } return att; }