I have a Maria DB and a JIRA platform, I would like to use the DB to create new issues there through the JIRA API, how can I integrate all of them?
I have already made the regular CRUD operations to the JIRA platform through the API using the HTTP Caller, but, how can I properly use the SQL Creator to use that data?
Yes, I apologize for the very brief details:
I'm trying to use the data from certain tables contained in a non-spatial DB to create new issues in the JIRA platform through the use of its API which I have properly connected with HTTP Caller. As a sample, I would like to get some values from a MYSQL table called "Label" to this JSON sintaxis:
{
"fields": {
"project":
{
"key": "TEST"
},
"summary": "REST ye merry gentlemen.",
"description": "Creating of an issue using project keys and issue type names using the REST API",
"label" : "examplelabelnumber1",
"issuetype": {
"name": "Bug"
}
}
}but I'm not quite sure how to call the value to this sintaxis.
So if I'm understanding you correctly, you want to read some MYSQL table and use the contents to populate a JSON document. Obviously this will depend on if it's a single MYSQL table or multiple tables that you have to join, but first thing to try is something like the following workflow:
<MYSQL reader> -- <JSONTemplater> -- <HTTPCaller>There's a pretty good article about using FME to write JSON, see:
https://knowledge.safe.com/articles/44293/json-writing-overview.html
In particular, you may want to look at this article that showcases the JSONTemplater:
https://knowledge.safe.com/articles/44294/json-writing-with-jsontemplater.html
And the JSONTemplater documentation: