Efficiently query for multiple tickets of a space

43 views
Skip to first unread message

andrea.st...@acus.eu

unread,
Sep 30, 2019, 12:15:36 PM9/30/19
to Assembla API Development
I need to get the ticket details for a few hundred tickets of a space.
These tickets aren't grouped by any criterion (be it users or milestones), and change each time, so I can't use the reports.

I'm currently using the `GET /v1/spaces/[space_id]/tickets/[number]`endpoint, one query for each ticket.

This is incredibly slow, but the only other option I can see to mass-query tickets is `GET /v1/spaces/[space_id]/tickets`,
which is even worse, as I want a small fraction of the total tickets of the space.

What I'd ideally want is a `GET /v1/spaces/[space_id]/tickets?numbers[]=[num1]&numbers[]=[num1]&....`
like the users[] parameter in `GET /v1/tasks` .

Is there some way to execute a query like that that I don't know? Or can I request such a feature?

Stanislav Kolotinskiy

unread,
Oct 1, 2019, 2:40:29 AM10/1/19
to andrea.st...@acus.eu, Assembla API Development
Hi Andrea,

unfortunately, we don’t have this functionality right now. I’ll forward this discussion to our product management team and they will decide if we are able to implement in the nearest future. I’ll keep you updated

Regards,
Stanislav

--
You received this message because you are subscribed to the Google Groups "Assembla API Development" group.
To unsubscribe from this group and stop receiving emails from it, send an email to assembla-api-d...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/assembla-api-dev/8b809849-ed01-4d2b-aecf-1f968d99f67c%40googlegroups.com.

Stanislav Kolotinskiy

unread,
Oct 1, 2019, 5:07:29 AM10/1/19
to andrea.st...@acus.eu, Assembla API Development
Hi Andrea,

our management team approved the idea to implement this fix. I’ll let you know when it gets into production

Regards,
Stanislav

andrea.st...@acus.eu

unread,
Oct 1, 2019, 5:13:46 AM10/1/19
to Assembla API Development
I thank you and your team for the fast response, looking forward to it.


Il giorno martedì 1 ottobre 2019 11:07:29 UTC+2, Stanislav Kolotinskiy ha scritto:
Hi Andrea,

our management team approved the idea to implement this fix. I’ll let you know when it gets into production

Regards,
Stanislav

On Oct 1, 2019, at 09:40, Stanislav Kolotinskiy <stan...@assembla.com> wrote:

Hi Andrea,

unfortunately, we don’t have this functionality right now. I’ll forward this discussion to our product management team and they will decide if we are able to implement in the nearest future. I’ll keep you updated

Regards,
Stanislav

On Sep 30, 2019, at 19:15, andrea.s...@acus.eu wrote:

I need to get the ticket details for a few hundred tickets of a space.
These tickets aren't grouped by any criterion (be it users or milestones), and change each time, so I can't use the reports.

I'm currently using the `GET /v1/spaces/[space_id]/tickets/[number]`endpoint, one query for each ticket.

This is incredibly slow, but the only other option I can see to mass-query tickets is `GET /v1/spaces/[space_id]/tickets`,
which is even worse, as I want a small fraction of the total tickets of the space.

What I'd ideally want is a `GET /v1/spaces/[space_id]/tickets?numbers[]=[num1]&numbers[]=[num1]&....`
like the users[] parameter in `GET /v1/tasks` .

Is there some way to execute a query like that that I don't know? Or can I request such a feature?

--
You received this message because you are subscribed to the Google Groups "Assembla API Development" group.
To unsubscribe from this group and stop receiving emails from it, send an email to assembla...@googlegroups.com.

ra...@assembla.com

unread,
Oct 29, 2019, 8:15:45 AM10/29/19
to Assembla API Development
Hello Andrea, 

Your request was implemented and already deployed in production. 
You can use it to request one ticket ("GET /v1/spaces/{space_id}/tickets?number={ticket_number}") or a list of tickets ("GET /v1/spaces/{space_id}/tickets?number[]={ticket_number1}&number[]={ticket_number2}&...").

Best regards,
Rafal

andrea.st...@acus.eu

unread,
Oct 29, 2019, 2:02:16 PM10/29/19
to Assembla API Development
Hello,

I have tested the new method, it works well and my application is now much faster.

The "number" parameter isn't documented yet (in https://api-docs.assembla.cc/content/ref/tickets_index.html ), so I'm not sure of its interactions with paging.
In my tests, the results are always non paged (up to around 200 entries), is there a point after which they become paged?

Thanks,
Andrea

andrea.st...@acus.eu

unread,
Nov 15, 2019, 11:13:53 AM11/15/19
to Assembla API Development
I have seen the new method has been documented, I've used it with great success over the last days.

I would like to ask for fast access to tickets relationships as well.

which has to be called once per ticket.

I would like to see something like:
* GET /v1/spaces/[space_id]/ticket_associations to get all the associations for all the tickets in the space all in a single go (possibly paginated)
* GET /v1/spaces/[space_id]/ticket_associations?number[]=num1&numbers[]=num2&... to get the associations for multiple tickets

Thank you again for your support.

Stanislav Kolotinskiy

unread,
Nov 25, 2019, 5:09:58 AM11/25/19
to andrea.st...@acus.eu, Assembla API Development
Hi Andrea,

that’s not currently in our roadmap, therefore I can’t give you any ETA. I’ll let you know if/when we plan to implement this.

Regards,
Stanislav

--
You received this message because you are subscribed to the Google Groups "Assembla API Development" group.
To unsubscribe from this group and stop receiving emails from it, send an email to assembla-api-d...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/assembla-api-dev/5dd790f6-859a-4ffd-a330-446260662724%40googlegroups.com.

Reply all
Reply to author
Forward
0 new messages