Query Project Assets Using REST API

Pipeline Integrations
1

I’m trying to query the Asset’s for a specific Project Name. Why does it return all Assets in the database no matter what I do? I’m guessing it has something to do with the filter
[‘project.Project.name’,‘is’,‘VFXP’]

$.ajax({
            url: url + '/api/v1/entity/assets',
            method: 'get',
            headers: headers,
            data: {
                fields: 'code,project',
                filters: [
                    ['sg_category', 'is', 'Tool'],
                    ['project.Project.name','is','VFXP']
                ]
            },
            success: function (data) {
                console.log(JSON.stringify(data));
                document.getElementById("queryConsole").value = JSON.stringify(data, null, 3);
                $('#queryConsole').value = JSON.stringify(data, null, 3);
            },
            error: function () {
                $('#queryOutput').html('Bummer: there was an error!');
            },
        })
1 Like
2

Have you tried ["project", "name_is", "VFXP"] ?
It shouldn’t be any different though…

3

Yeah that didnt change anything. Still does not actual filter the items to a specific project

4

Hi John,

It should work with post. Here is the reference Search all records.

Loney