0

Exporting all vendors rates (old views): filter by Last Modification. Getting information through the API.

Juan (Comunica Translations) 3 weeks ago in API updated by Viktor Mizsei 3 weeks ago 2

Hello:

I have found the way to retrieve all vendors rates in a CSV through the "old views" system. The thing is that I don't want to retrieve all of them, just the ones that changed in the last X days.

Did you find a way to fiilter by LastModification?
And overall, is there a way to retrieve this information through the API? Or at least through a macro that then I can retrieve the results from the API.

Thanks a lot for your information.
My best regards.

+1

Hi Juan,

I do not think there is a way to export it via API, regarding the macro, I do not have one to share.

The view itself does not have any filters, which in your case is an issue.

What I would probably do is add Last Modification column to the view and sort out in the excel-like software

2024-04-10_13h22_59.mp4

Whatever view you prepare in the vendors competencies you will be able to select in the export mechanism in the old views

It is possible. There are two ways to do that:

You can retrieve the view result with API. First you should create a view and filter it by lastmodification. Check the API documentation: .../api-doc#/home-api  browser/csv

Other way is to create a macro, which filters the record, and you can run this macro through API. This is much more complicated, but complex filtering is also possible this way.