Like value reference for summary is ("fields")("summary"). How about project type? Which to track the issue is under software or other fields.
In what sense? What's a "value reference"? Where are you seeing ("fields")("summary") ?
I'm using Excel VBA to get the json data from Jira, for example
Summary = Json("issues")("fields")("summary")
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
So its just field information. I assume you are getting it over the REST interface?
The project "type" is a structural attribute of a project, not an issue field. You'll need to make a call to read the project for an issue and look for the project type in the response. It's under https://docs.atlassian.com/jira/REST/server/#api/2/project-getProject
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Not from me I'm afraid. I don't use any form of BASIC, and avoid spreadsheets like the plague as they're almost all wrong.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.