SSIS Components for WordPress

Build 25.0.9434

SiteWidgets

Query and update the active and inactive widgets for a site.

Table Specific Information

SELECT

The component uses the WordPress API to process some of the filters.

  • Id supports the '=' comparison.

The component processes other filters client-side within the component.

For example, the following queries are processed server side.

SELECT * FROM SiteWidgets WHERE Id = 'block-1'

Update

To update a SiteWidgets you must specify the following column: Id.

UPDATE SiteWidgets SET Position = 5 WHERE Id = 'block-1'

Delete

To delete a SiteWidgets you must specify the following column: Id.

DELETE FROM SiteWidgets WHERE Id = '139'

Columns

Name Type ReadOnly References Description
Id [KEY] String True

The unique identifier assigned to the widget instance.

IdBase String True

The base identifier shared by all instances of this widget type.

Position Integer False

The widget's display order within its assigned sidebar.

Sidebar String False

The identifier of the sidebar where the widget is currently active.

SettingsAggregate String False

A collection of configuration settings that define the widget's behavior and appearance.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434