Issues with importing data into AirTable using a jira filter

[Beverly Sunkle]

I've created a filter in Jira for our AirTable specialist to use to import some data into AirTable.  The issue we are having is somewhere along the way the filter is being changed from the project name to the project ID so it is not working.  The filter is written like this...

project in ("OMS", "Order Management", "Order Sourcing", "Fulfillment") AND issuetype not in (Defect, "PROD Defect") AND createdDate >= startOfYear() ORDER BY key

but its being translated (somewhere along the way to )

project in (10254, 10255, 10256, 10257) AND issuetype not in (Defect, "PROD Defect") AND createdDate >= startOfYear() ORDER BY key

Here's the message we are getting on the airtable side...

A value with '10254' does not exist for the field 'project'

Some of the filters I created worked fine, but several of them are not.

[Marc - Devoteam · Accepted solution]

Hi @Beverly Sunkle 

The translation is done to shorten an avoid mistakes. The project names are translated to the project id's

Some the name corresponds to an idea in the system.

There are 2 things that can be wrong.

But the most obvious is, that the users from the airtable side don't have browse access to the project with ID 10254.

Check the project permissions and see which roles, groups or users have browse permissions on the project with ID 10254

[Beverly Sunkle]

Thank you so much....this solved our issue!!!

[Mohanraj Thangamuthu · Accepted solution]

Hello, Good day. Looks like users have lost "Browse project" permission this could be one of the reason why users see the project ID. Could you please check the browse project permission for these users ?

[Beverly Sunkle]

Thanks.  Solved the issue because we were using a service account for this work and it was not part of the regular User permissions.