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.

The connector is based on code from CData. See documentation here: https://cdn.cdata.com/help/BJG/ado/pg_startedintro.htm.

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;
}