How do you handle the data and get the latest response when data changes?

[amir]

Your Workflow URL

https://connect.pabbly.com/workflow/mapping/IjU3NjUwNTZkMDYzZTA0MzE1MjY1NTUzYzUxMzci_pc

I get some data from API/GET, and it always has a different get; first, it had "0", then "1," and now "2" .. in the future it might have "3" or "4" ... my question is how do I always get the latest value? Kindly advise

 

[amir]

Here are a couple of responses that I copied by turning off Simple Response

[{"id":140,"code":"waiting-on-team","name":"Waiting on team","displayOrder":0,"isCustom":true,"color":"","icon":"","createdAt":"2021-01-28T00:32:00Z","updatedAt":"2021-01-28T00:32:00Z","createdBy":{"id":390813,"type":"users"},"updatedBy":{"id":390813,"type":"users"},"state":"active"},{"id":131,"code":"in-progress","name":"In Progress","displayOrder":0,"isCustom":true,"color":"#16BC9E","icon":"","createdAt":"2020-12-17T23:04:58Z","updatedAt":"2020-12-17T23:05:27Z","createdBy":{"id":390813,"type":"users"},"updatedBy":{"id":390813,"type":"users"},"state":"active"},{"id":1,"code":"active","name":"Active","displayOrder":0,"isCustom":false,"color":"#44d335","icon":"status-new","createdAt":"0001-01-01T00:00:00Z","updatedAt":"0001-01-01T00:00:00Z","createdBy":{"id":0,"type":"users"},"updatedBy":{"id":0,"type":"users"},"state":"active"}]

[{"id":1,"code":"active","name":"Active","displayOrder":0,"isCustom":false,"color":"#44d335","icon":"status-new","createdAt":"0001-01-01T00:00:00Z","updatedAt":"0001-01-01T00:00:00Z","createdBy":{"id":0,"type":"users"},"updatedBy":{"id":0,"type":"users"},"state":"active"},{"id":140,"code":"waiting-on-team","name":"Waiting on team","displayOrder":0,"isCustom":true,"color":"","icon":"","createdAt":"2021-01-28T00:32:00Z","updatedAt":"2021-01-28T00:32:00Z","createdBy":{"id":390813,"type":"users"},"updatedBy":{"id":390813,"type":"users"},"state":"active"},{"id":131,"code":"in-progress","name":"In Progress","displayOrder":0,"isCustom":true,"color":"#16BC9E","icon":"","createdAt":"2020-12-17T23:04:58Z","updatedAt":"2020-12-17T23:05:27Z","createdBy":{"id":390813,"type":"users"},"updatedBy":{"id":390813,"type":"users"},"state":"active"}]

[{"id":1,"code":"active","name":"Active","displayOrder":0,"isCustom":false,"color":"#44d335","icon":"status-new","createdAt":"0001-01-01T00:00:00Z","updatedAt":"0001-01-01T00:00:00Z","createdBy":{"id":0,"type":"users"},"updatedBy":{"id":0,"type":"users"},"state":"active"},{"id":141,"code":"top-priority","name":"Top Priority","displayOrder":0,"isCustom":true,"color":"","icon":"","createdAt":"2021-01-30T21:22:04Z","updatedAt":"2021-01-30T21:22:04Z","createdBy":{"id":390813,"type":"users"},"updatedBy":{"id":390813,"type":"users"},"state":"active"},{"id":140,"code":"waiting-on-team","name":"Waiting on team","displayOrder":0,"isCustom":true,"color":"","icon":"","createdAt":"2021-01-28T00:32:00Z","updatedAt":"2021-01-28T00:32:00Z","createdBy":{"id":390813,"type":"users"},"updatedBy":{"id":390813,"type":"users"},"state":"active"},{"id":131,"code":"in-progress","name":"In Progress","displayOrder":0,"isCustom":true,"color":"#16BC9E","icon":"","createdAt":"2020-12-17T23:04:58Z","updatedAt":"2020-12-17T23:05:27Z","createdBy":{"id":390813,"type":"users"},"updatedBy":{"id":390813,"type":"users"},"state":"active"}]

[{"id":141,"code":"top-priority","name":"Top Priority","displayOrder":0,"isCustom":true,"color":"","icon":"","createdAt":"2021-01-30T21:22:04Z","updatedAt":"2021-01-30T21:22:04Z","createdBy":{"id":390813,"type":"users"},"updatedBy":{"id":390813,"type":"users"},"state":"active"},{"id":140,"code":"waiting-on-team","name":"Waiting on team","displayOrder":0,"isCustom":true,"color":"","icon":"","createdAt":"2021-01-28T00:32:00Z","updatedAt":"2021-01-28T00:32:00Z","createdBy":{"id":390813,"type":"users"},"updatedBy":{"id":390813,"type":"users"},"state":"active"},{"id":131,"code":"in-progress","name":"In Progress","displayOrder":0,"isCustom":true,"color":"#16BC9E","icon":"","createdAt":"2020-12-17T23:04:58Z","updatedAt":"2020-12-17T23:05:27Z","createdBy":{"id":390813,"type":"users"},"updatedBy":{"id":390813,"type":"users"},"state":"active"},{"id":1,"code":"active","name":"Active","displayOrder":0,"isCustom":false,"color":"#44d335","icon":"status-new","createdAt":"0001-01-01T00:00:00Z","updatedAt":"0001-01-01T00:00:00Z","createdBy":{"id":0,"type":"users"},"updatedBy":{"id":0,"type":"users"},"state":"active"}]

[{"id":1,"code":"active","name":"Active","displayOrder":0,"isCustom":false,"color":"#44d335","icon":"status-new","createdAt":"0001-01-01T00:00:00Z","updatedAt":"0001-01-01T00:00:00Z","createdBy":{"id":0,"type":"users"},"updatedBy":{"id":0,"type":"users"},"state":"active"},{"id":141,"code":"top-priority","name":"Top Priority","displayOrder":0,"isCustom":true,"color":"","icon":"","createdAt":"2021-01-30T21:22:04Z","updatedAt":"2021-01-30T21:22:04Z","createdBy":{"id":390813,"type":"users"},"updatedBy":{"id":390813,"type":"users"},"state":"active"},{"id":140,"code":"waiting-on-team","name":"Waiting on team","displayOrder":0,"isCustom":true,"color":"","icon":"","createdAt":"2021-01-28T00:32:00Z","updatedAt":"2021-01-28T00:32:00Z","createdBy":{"id":390813,"type":"users"},"updatedBy":{"id":390813,"type":"users"},"state":"active"},{"id":131,"code":"in-progress","name":"In Progress","displayOrder":0,"isCustom":true,"color":"#16BC9E","icon":"","createdAt":"2020-12-17T23:04:58Z","updatedAt":"2020-12-17T23:05:27Z","createdBy":{"id":390813,"type":"users"},"updatedBy":{"id":390813,"type":"users"},"state":"active"},{"id":4,"code":"on-hold","name":"On-hold","displayOrder":10000,"isCustom":false,"color":"#24ccee","icon":"status-on-hold","createdAt":"0001-01-01T00:00:00Z","updatedAt":"0001-01-01T00:00:00Z","createdBy":{"id":0,"type":"users"},"updatedBy":{"id":0,"type":"users"},"state":"active"}]

 

[Pabblymember11]

Hey @amir

Can you please elaborate on the condition which you want to achieve in the automation?

 

[amir]

Hey @amir

Can you please elaborate on the condition which you want to achieve in the automation?

I want to get the Current Status of the Ticket through API, but when I GET data, it pulls multiple records that were previously used on Ticket. my goal is only to get data for the Current Status that way I can always get fresh data

 

[amir]

Hey guys, my issue seems solved for now. I found another way to extract the status. I will inform if further help is required. ty!