How to extract only templated projects

I just responded to you in that other thread before reading this - this is useful info that informs the other thread.

Since you mention “CSV or Excel” here, I would recommend you forget about my API Explorer suggestion because that will give you output in JSON format which is not CSV or Excel - there are online JSON to CSV converters but getting your output directly in CSV would be a lot more convenient.

One word of caution: if you do get a CSV output and want to open it in Excel, Excel will truncate the last digit of the ID unless you follow these steps:

(FYI Google Sheets does not have this issue so if you use Google Sheets instead of Excel, the IDs will be fine.)

Whether a project is a template or not is just a field on the project called is_template. If you use @Bastien_Siebman’s export and it doesn’t include that field, ask him nicely :slight_smile: to add it to the fields being exported; then it will be available to you as a column in Excel and you can just filter on that column.

1 Like