API return custom field value

[Justi Lawson]

Ok I have a weird one that I am not even sure it can be done. 

We have two custom fields.

1. Store Number

2. Store Phone Number

We have a 3rd party who wants to integrate with our environment. They want to be able to supply the store number and have the store phone number return. Is there any way to utilize Atlassian's API to accomplish this?

I had suggested to them I would have a third custom field that would be (Store Number - Store Phone Number) but they do not want to work with this because with Atlassian's API it will only return 100 records at a time and they do not want to do multiple calls to loop through the 400 records. 

[Stefan Salzl]

Hi @Justi Lawson ,

Do these 2 fields have any dependency or are they losely integrated?

furthermore:
How/where would they like to call/submit the store number? On issue level? Where do the want to retrieve the information from?

The point is:
A custom field could be filled with information in each issue. If they have no connection/dependency to each other you could have „store number: 1, Store tel number: 666-777“ and in another issue „store number: 1, Store tel number: 123-456“.

To suggest a solution it would be good to know the whole use case and the setting/what information is handled within jora issues.

Best
Stefan

[Justi Lawson]

I did have the third custom field (Store Number - Store Phone Number) and suggested they use the api to query looking for the store number, but it only returns 100 records at a time and they do not want to loop through the results 100 at a time. 

The use case is when a customer calls in they want to match the phone number and update the store # field. 

[Chris Thomas]

I'm not sure how familiar you are with PowerShell but there is a JiraPS module that will allow custom fields to be updated and I think the limit is 1,000.

However, I would look into a webhook to set the custom fields on issue creation or workflow transition from the 3rd party. That way no one has to worry about running a script/program or waiting for data to populate.