Squidex API - Update data

ictest_account · November 23, 2021, 4:41pm

I have…

[x] Read the following guideline: https://docs.squidex.io/01-getting-started/installation/troubleshooting-and-support. I understand that my support request might get deleted if I do not follow the guideline.

I’m submitting a…

[ ] Regression (a behavior that stopped working in a new release)
[ ] Bug report
[ ] Performance issue
[x] Documentation issue or request

Current behavior

Expected behavior

Minimal reproduction of the problem

Environment

[ ] Self hosted with docker
[x] Self hosted with IIS
[ ] Self hosted with other version
[ ] Cloud version

Version: [VERSION]

Browser:

[x] Chrome (desktop)
[ ] Chrome (Android)
[ ] Chrome (iOS)
[ ] Firefox
[ ] Safari (desktop)
[ ] Safari (iOS)
[ ] IE
[ ] Edge

Others:
Hi Sebastian
I have a use case to update data based on some condition.
I am looking at the bulkUpload method of the API.
Would it be the most appropriate one ? Pls can you share some .net sample to use this ?

Thanks

Sebastian · November 23, 2021, 6:29pm

There is no “update by filter” thing. You have to query the items first, at least you need their IDs. Then you can use the bulk update API:

It is part of the official SDK. The following code is from the API tests:

github.com

Squidex/squidex/blob/master/backend/tools/TestSuite/TestSuite.ApiTests/ContentUpdateTests.cs#L264


    }
}

[Fact]
public async Task Should_create_bulk_content_with_scripting_but_disabled()
{
    TestEntity content = null;
    try
    {
        // STEP 1: Create content with a value that triggers the schema.
        var results = await _.Contents.BulkUpdateAsync(new BulkUpdate
        {
            Jobs = new List<BulkUpdateJob>
            {
                new BulkUpdateJob
                {
                    Type = BulkUpdateType.Upsert,
                    Data = new
                    {
                        number = new
                        {

There is also a BulkUpdateType.Patch and you an Id property at the BulkUpdateJob type.

ictest_account · November 25, 2021, 9:01pm

Thanks.
Where is ScriptTrigger getting populated from ?

github.com

Squidex/squidex/blob/master/backend/tools/TestSuite/TestSuite.ApiTests/ContentUpdateTests.cs#L274


{
    Jobs = new List<BulkUpdateJob>
    {
        new BulkUpdateJob
        {
            Type = BulkUpdateType.Upsert,
            Data = new
            {
                number = new
                {
                    iv = TestEntity.ScriptTrigger
                }
            }
        }
    },
    Publish = true
});

Assert.Single(results);
Assert.Null(results[0].Error);

Sebastian · November 26, 2021, 8:41am

It is just a special value from the tests. When the field has this value the script does something.