Api Access to Custom View Data

[kyrpav]

I am trying to use an alternative system for Campaigns. I am not sure if twenty will have solution for Campaigns (mass email solution etc.)[apologies i created also a discord question].

So my idea was to get the view data outside of a custom list Or to get all people and reconstruct the filtering.

What did i check:

I can create a custom view in people page and i can find the view in the api.

I can not get the records.

I did find that based on viewName and the view api the viewId.
i can find the filters applied.
Then in the filters i can see that a filter applied to a field (specific fieldmetadataId) should contain a value (and i see the value also) but i do not know the name of the field in the api. Also in the api for the viewFields you have the same metadataId but you do not have a name.
So i can not get All people and find the fields that i need to apply the filters.
Any idea?

I am giving you also data where you can easily see the structures (and i am not sure if the proccess should change in case of multiple filters):

  "data": {
    "views": [
      {
        "name": "Custom people list",
        "objectMetadataId": "54580243-2aab-4962-b4d6-9d6c4a355af0",
        "type": "table",
        "key": null,
        "icon": "IconList",
        "kanbanFieldMetadataId": "",
        "position": -1,
        "isCompact": false,
        "openRecordIn": "SIDE_PANEL",
        "kanbanAggregateOperation": "COUNT",
        "kanbanAggregateOperationFieldMetadataId": null,
        "anyFieldFilterValue": "",
        "id": "ad1fdec3-cac0-4cac-8ea0-754745bc3cc4",
        "createdAt": "2025-09-01T10:13:50.694Z",
        "updatedAt": "2025-09-01T10:13:50.694Z",
        "deletedAt": null
      }
    ]
  }
  
  
    "data": {
    "viewFilters": [
      {
        "fieldMetadataId": "7925a2e5-048f-4932-ac05-6cf2fe1c5cd5",
        "operand": "contains",
        "value": "Dim",
        "displayValue": "Dim",
        "viewFilterGroupId": null,
        "positionInViewFilterGroup": null,
        "subFieldName": null,
        "id": "ee1b2991-4320-4697-96ff-0a66ff18f2bc",
        "createdAt": "2025-09-01T10:13:51.084Z",
        "updatedAt": "2025-09-01T10:13:51.084Z",
        "deletedAt": null,
        "viewId": "ad1fdec3-cac0-4cac-8ea0-754745bc3cc4"
      }
    ]
  }
  
  {
  "data": {
    "viewFields": [
      {
        "fieldMetadataId": "7925a2e5-048f-4932-ac05-6cf2fe1c5cd5",
        "isVisible": true,
        "size": 210,
        "position": 0,
        "aggregateOperation": null,
        "id": "13af5254-26ff-4dfb-a5c8-9bde5c570668",
        "createdAt": "2025-09-01T10:13:50.828Z",
        "updatedAt": "2025-09-01T10:13:50.828Z",
        "deletedAt": null,
        "viewId": "ad1fdec3-cac0-4cac-8ea0-754745bc3cc4"
      },
      {
        "fieldMetadataId": "7925a2e5-048f-4932-ac05-6cf2fe1c5cd5",
        "isVisible": true,
        "size": 210,
        "position": 0,
        "aggregateOperation": null,
        "id": "d7f80ad1-6478-41ae-9eaf-626c15eb20bc",
        "createdAt": "2025-08-22T14:52:16.948Z",
        "updatedAt": "2025-08-22T14:52:16.948Z",
        "deletedAt": null,
        "viewId": "10f8cdc2-c7a9-496d-b217-57c8488f751f"
      }
    ]
  }