Comparaison des versions

Légende

  • Ces lignes ont été ajoutées. Ce mot a été ajouté.
  • Ces lignes ont été supprimées. Ce mot a été supprimé.
  • La mise en forme a été modifiée.

Overview

...

Kepler - SQL Query Fields | Grids & Dashboards  provides a REST API to enable you to

...

get data from your database. 

Using GET HTTP METHOD (Deprecated)

Base URL

The base URL to call the file SQL Custom Field is: 

 <Base-URL>/rest/kepler-SQLC/

................................ 

1.0/tableResource/getData/{CutomfieldID}/{issueKey}/{dependentFields}

Required Parameters 


Parameters

Explanation

issueKeykey issue
CutomfieldIDID of your field ex : customfield_11100
dependentFieldsan array converted to base64 which contains the list of fields with values ​​of those which depend on the custom fields.

An example of usage :


Image Added


Using POST HTTP METHOD (since 2.13.1)

Base URL

The base URL to call the file SQL Custom Field is: 

 <Base-URL>/rest/kepler-SQLC/1...............................................0/tableResource/getData

Required Body :


Bloc de code
languagejava
{
  "customfieldId": "customfield_10000",
  "issueKey": "$issue.key",
  "allDependentFields": [
    {
      "id": "customfield_10000",
      "value": "dependent_field_value"
    }
  ]
}


Parameters

Explanation

issueKeykey issue
CutomfieldIDID of your field ex : customfield_10000
dependentFieldsa list of dependent field with values of each field