Unable to find Harvest project by Project Code

I've been using Pabbly to create Harvest projects from my Jira epics for a while now. I'm wanting to automate the archiving of the Harvest project when the epic is closed. The Harvest project code is the Jira issue ID (i.e. the Jira issue is P-123 so the corresponding Harvest project code is P-123).

I have the webhook set up when the issue is resolved, however I am finding that I cannot locate the Harvest project based on the project code, it's requiring me to look it up by the project ID, which I don't have. I thought maybe I could store the Harvest Project ID into a custom field when I create the Harvest project, but it looks like the Jira config only has a small number of fields that I can update, and my custom field is not one of them.

Is there currently a way that I could track this, either by looking up the Harvest project by code or storing the Harvest Project ID into the Jira ticket that I can then reference to archive the project when it's completed?

Thanks!

It actually looks like I also can't archive a Harvest project from Pabbly - so that would be very helpful as well.

Hi @jdavidbakr,

Please share the Workflow URL in which you have this use case.

Here is the workflow to send the project to Harvest: https://connect.pabbly.com/workflow/mapping/IjU3NjMwNTZmMDYzZjA0M2M1MjY1NTUzNSI_3D_pc

Here is the workflow I started to consume the epic resolution and archive the Harvest project: https://connect.pabbly.com/workflow/mapping/IjU3NjUwNTZjMDYzMjA0MzI1MjZkNTUzNTUxMzQi_pc

As per the Harvest API documentation, there is no endpoint that utilizes a project code to retrieve a project. Additionally, there is no dedicated endpoint for archiving a project; instead, it suggests using the 'Update Project' action event for the purpose of archiving
https://help.getharvest.com/api-v2/projects-api/projects/projects/

Ok - I think that will work if I can store the Harvest Project ID into Jira when the Harvest project is created; however, the Jira endpoint only lets me set a few fields. Is there a way for the Jira endpoint to set a custom field?

Ok - I think that will work if I can store the Harvest Project ID into Jira when the Harvest project is created; however, the Jira endpoint only lets me set a few fields. Is there a way for the Jira endpoint to set a custom field?

For this, you will have to get in touch with Jira's support team. If Jira sends custom field data, it will be captured in the trigger step.

I'm actually asking about setting the custom fields, not reading them. I'm pretty sure I can read them, but I first need to be able to set them. The jira action only has a few fields available to set.

I was trying the "update issue" action

Please allow me some time to discuss the possibility of getting custom fields in the "Update Issue" action event with my team. I will get back to you with an update soon.