Thank you Sunnyape for your help and suggestions.
I guess from the wording I’m using, you can tell I barely know anything about REST API or JIRA system. That’s why I really appreciate you taught me another word “endpoints”, which I should be correctly using. I guess my next search would be what all the possible Jira Cloud REST API endpoints are out there, which allow me to pull the Jira card info like “fields.Project.key”, “fields.Project.name”, “fields.Summary” etc.
I was asked to create a report including data from both one on-prem JIRA system and another Cloud based Jira system.
For the on prem JIRA system, I had no problem pulling all the data I need, so I was trying the same way on the Cloud based Jira system and that’s where I got issue, and it seems since 2025, Cloud Jira system doesn’t allow the old way of pulling all the data, but only using /rest/api/3/search/jql. I checked with both our internal on-prem and Cloud Jira admin, and they both suggested that I should try to get help from the vendor. Our Cloud Jira admin also helped to share his screen and showed me that my token never showed up on his admin page and he never saw any traffic from the log.
I’m just a little helpless here, so I’m searching all the options and trying to make up different links that fit our needs then trying them on different connectors like REST Connection Manager and HTTP Connection Managers.
I’m just a blind person trying to cross a river, trying one step after another. For example, in the link in HTTP Connection Manager, when adding &fields=key on the end of JSQL, I get the key (Jira card number) column info in the response, but when using &fields%3Dkey, I lost it, and neither link works in REST Connection Manager. I have no idea why it’s like that, and I found it seems I can not include all 742 Jira cards data in my response no matter if I have &maxResults=5000, as it always has next page token. Also, I cannot draft a link that returns the limited amounts of fields I need unless I add the string &fields=*all.
I’m just feeling when I found something through google that opens one door, there are more doors behind it, so any guidance would be super helpful for our need and for a newbie like me.
Thank you.
Alex