Data API constraints issues

Need help APIs
1

I followed all the instructions to configure de bubble data api and set up correctly.
The link would be https://agksystem.com/api/1.1/obj/conversas
I put the link below to show the functionality about the GET call and appearly works as it should do.
But, unfortunality, we can see in this video that the constraints does not work properly.
I set up some fields in json fields, but the fields don’t appear.
I filter by date, but the GET show all records ignoring all constraints set up.
There is no privacy rules, the thing/table has public visibility.

I think the bubble tool is buggy and their support simply tell me to solve here in this forum.

Constraints Issues

2

The request is not sent as a JSON, but as a encoded string of this json in a “constraints” key with value set to the json like

GET https://securitybook.bubbleapps.io/version-test/api/1.1/obj/rentalunit?constraints=[%20{%20%22key%22:%20%22unitname%22,%20%22constraint_type%22:%20%22equals%22,%20%22value%22:%20%22Unit%20A%22%20}%20,{%20%22key%22:%20%22unitnumber%22,%20%22constraint_type%22:%20%22greater%20than%22,%20%22value%22:%20%223%22%20}]

Original without encoding:

https://securitybook.bubbleapps.io/version-test/api/1.1/obj/rentalunit?constraints=[ { "key": "unitname", "constraint_type": "equals", "value": "Unit A" } ,{ "key": "unitnumber", "constraint_type": "greater than", "value": "3" }]

Please read documentation…

3

I used swagger and the tool sent this urls as json

https://agksystem.com/api/1.1/obj/conversas?limit=50&cursor=0&constraints={"constraints"%3A%20[{"key"%3A%20"Created%20Date"%2C"constraint_type"%3A"greater%20than%20or%20equal%20to"%2C"value"%3A%20"{{date}}T00%3A00%3A00"}%2C{"key"%3A%20"Created%20Date"%2C%20"constraint_type"%3A%20"less%20than%20or%20equal%20to"%2C"value"%3A%20"{{date}}T23%3A59%3A59"}%2C{"key"%3A%20"OrignType"%2C%20"constraint_type"%3A%20"text%20contains"%2C%20"value"%3A%20"{{orign_type}}"}%2C%20{"key"%3A"TipoConversa"%2C%20"constraint_type"%3A%20"text%20contains"%2C%20"value"%3A%20"{{tipo_conversa}}"}%2C{"key"%3A%20"Created%20By"%2C%20"constraint_type"%3A%20"text%20contains"%2C%20"value"%3A%20"{{created_by}}"}%20]%2C%20"limit"%3A%20100%2C%20"cursor"%3A%20"next_cursor_value"%2C%20"fields"%3A%20[%20"OrignType"%2C%20"TipoConversa"%2C%20"Created%20By"%2C%20"Created%20Date"%2C%20"mensagem"]%20}

image
image936×859 29.2 KB

The Response Body below brought 50 registers without the fields that I asked and not filtered as I asked too.

{
  "response": {
    "cursor": 0,
    "results": [
      {
        "Selected_To_Set_As_Read": false,
        "Created By": "1621354230082x170462043729183700",
        "_id": "1629205360964x326785378164408300",
        "Created Date": "2021-08-17T13:02:40.327Z",
        "UsersThatReadMessage": [
          "1654261631609x899824825035051800"
        ],
        "UserNamesThatReadMessage": [
          "Leonardo Pacce"
        ],
        "Modified Date": "2024-06-06T15:39:13.786Z",
        "mensagem": "\"Modified Order Uploads Docs\"",
        "po-message": "215"
      },
      {
        "mensagem": "\"Modified Order Uploads Docs\"",
        "Created By": "1621354230082x170462043729183700",
        "UserNamesThatReadMessage": [
          "Leonardo Pacce"
        ],
        "_id": "1629205449554x828019391082266600",
        "po-message": "215",
        "Selected_To_Set_As_Read": false,
        "UsersThatReadMessage": [
          "1654261631609x899824825035051800"
        ],
        "Created Date": "2021-08-17T13:04:08.631Z",
        "Modified Date": "2024-06-06T15:39:13.787Z"
      },
      {
        "UserNamesThatReadMessage": [
          "Leonardo Pacce"
        ],
        "Selected_To_Set_As_Read": false,
        "mensagem": "\"Modified Order Uploads Docs\"",
        "UsersThatReadMessage": [
          "1654261631609x899824825035051800"
        ],
        "Created By": "1621354230082x170462043729183700",
        "Modified Date": "2024-06-06T15:39:13.787Z",
        "Created Date": "2021-08-17T13:04:26.366Z",
        "po-message": "215",
        "_id": "1629205467450x411475502753906700"
      },
      {
        "Selected_To_Set_As_Read": false,
        "_id": "1629205789180x386017771209883650",
        "po-message": "215",
        "UserNamesThatReadMessage": [
          "Leonardo Pacce"
        ],
        "Created By": "1621354230082x170462043729183700",
        "Created Date": "2021-08-17T13:09:48.382Z",
        "mensagem": "Modified Order Uploads Docs",
        "Modified Date": "2024-06-06T15:39:13.788Z",
        "UsersThatReadMessage": [
          "1654261631609x899824825035051800"
        ]
      },
      {
        "mensagem": "Modified Order Uploads Docs",
        "po-message": "215",
        "UsersThatReadMessage": [
          "1654261631609x899824825035051800"
        ],
        "Created By": "1621354230082x170462043729183700",
        "Modified Date": "2024-06-06T15:39:13.789Z",
        "UserNamesThatReadMessage": [
          "Leonardo Pacce"
        ],
        "Selected_To_Set_As_Read": false,
        "_id": "1629205825719x782846491325890600",
        "Created Date": "2021-08-17T13:10:24.655Z"
      },
      {
        "_id": "1629205845950x304279255140532200",
        "Created Date": "2021-08-17T13:10:45.215Z",
        "UsersThatReadMessage": [
          "1654261631609x899824825035051800"
        ],
        "mensagem": "teste",
        "Created By": "1621354230082x170462043729183700",
        "Selected_To_Set_As_Read": false,
        "UserNamesThatReadMessage": [
          "Leonardo Pacce"
        ],
        "Modified Date": "2024-06-06T15:39:13.790Z"
      },
      {
        "Created By": "1621354230082x170462043729183700",
        "Selected_To_Set_As_Read": false,
        "UserNamesThatReadMessage": [
          "Leonardo Pacce"
        ],
        "Modified Date": "2024-06-06T15:39:13.790Z",
        "po-message": "215",
        "Created Date": "2021-08-17T13:11:04.150Z",
        "_id": "1629205865174x526245733991448600",
        "UsersThatReadMessage": [
          "1654261631609x899824825035051800"
        ],
        "mensagem": "Modified Order Uploads Docs"
      },
      {
        "_id": "1629205882092x291935697781391360",
        "Selected_To_Set_As_Read": false,
        "UserNamesThatReadMessage": [
          "Leonardo Pacce"
        ],
        "mensagem": "Modified Order Uploads Docs",
        "po-message": "216",
        "Created By": "1621354230082x170462043729183700",
        "Created Date": "2021-08-17T13:11:20.956Z",
        "Modified Date": "2024-06-06T15:39:13.791Z",
        "UsersThatReadMessage": [
          "1654261631609x899824825035051800"
        ]
      },
      {
        "Selected_To_Set_As_Read": false,
        "po-message": "215",
        "mensagem": "Modified Order Uploads Docs",
        "Created By": "1621354230082x170462043729183700",
        "UserNamesThatReadMessage": [
          "Leonardo Pacce"
        ],
        "Modified Date": "2024-06-06T15:39:13.792Z",
        "Created Date": "2021-08-17T13:12:18.270Z",
        "UsersThatReadMessage": [
          "1654261631609x899824825035051800"
        ],
        "_id": "1629205939325x782467672441618400"
      },
      {
        "po-message": "215",
        "mensagem": "Modified Order Uploads Docs",
        "Created By": "1621354230082x170462043729183700",
        "UserNamesThatReadMessage": [
          "Leonardo Pacce"
        ],
        "Created Date": "2021-08-17T13:13:20.391Z",
        "Selected_To_Set_As_Read": false,
        "_id": "1629206001437x152344018367283200",
        "UsersThatReadMessage": [
          "1654261631609x899824825035051800"
        ],
        "Modified Date": "2024-06-06T15:39:13.793Z"
      },
      {
        "Selected_To_Set_As_Read": false,
        "Created Date": "2021-08-17T13:14:25.223Z",
        "UsersThatReadMessage": [
          "1654261631609x899824825035051800"
        ],
        "po-message": "215",
        "Modified Date": "2024-06-06T15:39:13.793Z",
        "UserNamesThatReadMessage": [
          "Leonardo Pacce"
        ],
        "mensagem": "Modified Order Uploads Docs",
        "_id": "1629206066245x393751227579236350",
        "Created By": "1621354230082x170462043729183700"
      },
      {
        "UsersThatReadMessage": [
          "1654261631609x899824825035051800"
        ],
        "po-message": "215",
        "Created By": "1621354230082x170462043729183700",
        "mensagem": "Modified Order Uploads Docs",
        "_id": "1629206074653x800830465691353100",
        "Created Date": "2021-08-17T13:14:34.155Z",
        "Modified Date": "2024-06-06T15:39:13.794Z",
        "UserNamesThatReadMessage": [
          "Leonardo Pacce"
        ],
        "Selected_To_Set_As_Read": false
      },
      {
        "Modified Date": "2024-06-06T15:39:13.794Z",
        "po-message": "215",
        "_id": "1629206087043x957567014532284400",
        "mensagem": "Modified Order Uploads Docs",
        "Created By": "1621354230082x170462043729183700",
        "Created Date": "2021-08-17T13:14:45.931Z",
        "UsersThatReadMessage": [
          "1654261631609x899824825035051800"
        ],
        "UserNamesThatReadMessage": [
          "Leonardo Pacce"
        ],
        "Selected_To_Set_As_Read": false
      },
      {
        "po-message": "215",
        "Selected_To_Set_As_Read": false,
        "UsersThatReadMessage": [
          "1654261631609x899824825035051800"
        ],
        "UserNamesThatReadMessage": [
          "Leonardo Pacce"
        ],
        "mensagem": "Modified Order Uploads Docs",
        "Modified Date": "2024-06-06T15:39:13.794Z",
        "Created By": "1621354230082x170462043729183700",
        "Created Date": "2021-08-17T13:16:38.426Z",
        "_id": "1629206199524x699777551675949000"
      },
      {
        "po-message": "215",
        "Selected_To_Set_As_Read": false,
        "mensagem": "Modified Order Uploads Docs",
        "UserNamesThatReadMessage": [
          "Leonardo Pacce"
        ],
        "UsersThatReadMessage": [
          "1654261631609x899824825035051800"
        ],
        "Created Date": "2021-08-17T13:17:00.225Z",
        "Modified Date": "2024-06-06T15:39:13.795Z",
        "_id": "1629206221282x859434127002173400",
        "Created By": "1621354230082x170462043729183700"
      },
      {
        "mensagem": "Modified Order Uploads Docs",
        "UsersThatReadMessage": [
          "1654261631609x899824825035051800"
        ],
        "_id": "1629206249155x435715783129563140",
        "UserNamesThatReadMessage": [
          "Leonardo Pacce"
        ],
        "po-message": "215",
        "Created Date": "2021-08-17T13:17:28.097Z",
        "Created By": "1621354230082x170462043729183700",
        "Modified Date": "2024-06-06T15:39:13.795Z",
        "Selected_To_Set_As_Read": false
      },
      {
        "Selected_To_Set_As_Read": false,
        "po-message": "215",
        "UserNamesThatReadMessage": [
          "Leonardo Pacce"
        ],
        "Created By": "1621354230082x170462043729183700",
        "mensagem": "Modified Order Uploads Docs",
        "UsersThatReadMessage": [
          "1654261631609x899824825035051800"
        ],
        "_id": "1629206300434x574775646518247400",
        "Modified Date": "2024-06-06T15:39:13.796Z",
        "Created Date": "2021-08-17T13:18:19.628Z"
      },
      {
        "po-message": "215",
        "Created Date": "2021-08-17T13:19:29.723Z",
        "Created By": "1621354230082x170462043729183700",
        "UsersThatReadMessage": [
          "1654261631609x899824825035051800"
        ],
        "UserNamesThatReadMessage": [
          "Leonardo Pacce"
        ],
        "Modified Date": "2024-06-06T15:39:13.796Z",
        "mensagem": "Modified Order Uploads Docs",
        "Selected_To_Set_As_Read": false,
        "_id": "1629206370754x169198074190888960"
      },
      {
        "_id": "1629206387161x473642290257854460",
        "Modified Date": "2024-06-06T15:39:13.796Z",
        "UsersThatReadMessage": [
          "1654261631609x899824825035051800"
        ],
        "mensagem": "Modified Order Uploads Docs",
        "Created By": "1621354230082x170462043729183700",
        "Created Date": "2021-08-17T13:19:46.099Z",
        "po-message": "215",
        "UserNamesThatReadMessage": [
          "Leonardo Pacce"
        ],
        "Selected_To_Set_As_Read": false
      },
      {
        "po-message": "216",
        "Modified Date": "2024-06-06T15:39:13.797Z",
        "Created Date": "2021-08-17T13:22:35.341Z",
        "Selected_To_Set_As_Read": false,
        "UserNamesThatReadMessage": [
          "Leonardo Pacce"
        ],
        "Created By": "1621354230082x170462043729183700",
        "_id": "1629206555938x451377699841638400",
        "mensagem": "Modified Order Uploads Docs",
        "UsersThatReadMessage": [
          "1654261631609x899824825035051800"
        ]
      },
      {
        "Modified Date": "2024-06-06T15:39:14.034Z",
        "UsersThatReadMessage": [
          "1654261631609x899824825035051800"
        ],
        "Created By": "1621354230082x170462043729183700",
        "Created Date": "2021-08-17T13:23:04.170Z",
        "mensagem": "Modified Order Uploads Docs",
        "UserNamesThatReadMessage": [
          "Leonardo Pacce"
        ],
        "po-message": "215",
        "Selected_To_Set_As_Read": false,
        "_id": "1629206585182x175843112907440130"
      },
      {
        "mensagem": "Modified Order Uploads Docs",
        "_id": "1629206606455x790702770895716400",
        "Modified Date": "2024-06-06T15:39:14.034Z",
        "Created By": "1621354230082x170462043729183700",
        "UsersThatReadMessage": [
          "1654261631609x899824825035051800"
        ],
        "po-message": "215",
        "UserNamesThatReadMessage": [
          "Leonardo Pacce"
        ],
        "Selected_To_Set_As_Read": false,
        "Created Date": "2021-08-17T13:23:25.384Z"
      },
      {
        "mensagem": "Modified Order Uploads Docs",
        "UsersThatReadMessage": [
          "1654261631609x899824825035051800"
        ],
        "Created By": "1621354230082x170462043729183700",
        "po-message": "215",
        "Modified Date": "2024-06-06T15:39:14.035Z",
        "Created Date": "2021-08-17T13:23:43.512Z",
        "UserNamesThatReadMessage": [
          "Leonardo Pacce"
        ],
        "Selected_To_Set_As_Read": false,
        "_id": "1629206624598x861656534101524500"
      },
      {
        "Modified Date": "2024-06-06T15:39:14.035Z",
        "mensagem": "Modified Order Uploads Docs",
        "Created By": "1621354230082x170462043729183700",
        "Created Date": "2021-08-17T13:24:52.120Z",
        "po-message": "215",
        "UserNamesThatReadMessage": [
          "Leonardo Pacce"
        ],
        "_id": "1629206693231x143129016778358780",
        "Selected_To_Set_As_Read": false,
        "UsersThatReadMessage": [
          "1654261631609x899824825035051800"
        ]
      },
      {
        "Created Date": "2021-08-17T13:39:02.912Z",
        "Created By": "1621354230082x170462043729183700",
        "Selected_To_Set_As_Read": false,
        "UserNamesThatReadMessage": [
          "Leonardo Pacce"
        ],
        "po-message": "216",
        "UsersThatReadMessage": [
          "1654261631609x899824825035051800"
        ],
        "_id": "1629207543352x158744802917089280",
        "Modified Date": "2024-06-06T15:39:14.036Z",
        "mensagem": "\"Modified PO Uploads\""
      },
      {
        "mensagem": "\"Modified PO Uploads\"",
        "_id": "1629207551343x525326646617309200",
        "po-message": "216",
        "Modified Date": "2024-06-06T15:39:14.036Z",
        "UsersThatReadMessage": [
          "1654261631609x899824825035051800"
        ],
        "Created By": "1621354230082x170462043729183700",
        "Selected_To_Set_As_Read": false,
        "Created Date": "2021-08-17T13:39:10.453Z",
        "UserNamesThatReadMessage": [
          "Leonardo Pacce"
        ]
      },
      {
        "UsersThatReadMessage": [
          "1654261631609x899824825035051800"
        ],
        "_id": "1629207565469x542903102165483500",
        "Created Date": "2021-08-17T13:39:24.723Z",
        "UserNamesThatReadMessage": [
          "Leonardo Pacce"
        ],
        "Selected_To_Set_As_Read": false,
        "Created By": "1621354230082x170462043729183700",
        "po-message": "216",
        "mensagem": "\"Modified PO Uploads\"",
        "Modified Date": "2024-06-06T15:39:14.036Z"
      },
      {
        "UserNamesThatReadMessage": [
          "Leonardo Pacce"
        ],
        "Modified Date": "2024-06-06T15:39:14.037Z",
        "po-message": "216",
        "Selected_To_Set_As_Read": false,
        "mensagem": "\"Modified PO Uploads\"",
        "UsersThatReadMessage": [
          "1654261631609x899824825035051800"
        ],
        "_id": "1629207679488x370534134163177500",
        "Created By": "1621354230082x170462043729183700",
        "Created Date": "2021-08-17T13:41:18.552Z"
      },
      {
        "Created Date": "2021-08-17T13:41:35.645Z",
        "UsersThatReadMessage": [
          "1654261631609x899824825035051800"
        ],
        "po-message": "216",
        "UserNamesThatReadMessage": [
          "Leonardo Pacce"
        ],
        "_id": "1629207696636x230329458572656640",
        "mensagem": "\"Modified PO Uploads\"",
        "Selected_To_Set_As_Read": false,
        "Modified Date": "2024-06-06T15:39:14.037Z",
        "Created By": "1621354230082x170462043729183700"
      },
      {
        "mensagem": "\"Modified PO Uploads\"",
        "po-message": "216",
        "Modified Date": "2024-06-06T15:39:14.038Z",
        "Selected_To_Set_As_Read": false,
        "Created Date": "2021-08-17T13:41:49.234Z",
        "_id": "1629207710253x291171694422261760",
        "Created By": "1621354230082x170462043729183700",
        "UsersThatReadMessage": [
          "1654261631609x899824825035051800"
        ],
        "UserNamesThatReadMessage": [
          "Leonardo Pacce"
        ]
      },
      {
        "mensagem": "\"Modified PO Uploads\"",
        "Created Date": "2021-08-17T13:46:02.298Z",
        "UsersThatReadMessage": [
          "1654261631609x899824825035051800"
        ],
        "UserNamesThatReadMessage": [
          "Leonardo Pacce"
        ],
        "Created By": "1621354230082x170462043729183700",
        "_id": "1629207963261x278176752423403500",
        "po-message": "216",
        "Modified Date": "2024-06-06T15:39:14.039Z",
        "Selected_To_Set_As_Read": false
      },
      {
        "UsersThatReadMessage": [
          "1654261631609x899824825035051800"
        ],
        "UserNamesThatReadMessage": [
          "Leonardo Pacce"
        ],
        "Selected_To_Set_As_Read": false,
        "po-message": "216",
        "mensagem": "Modified PI Uploads Docs",
        "Modified Date": "2024-06-06T15:39:14.039Z",
        "Created Date": "2021-08-17T13:55:27.018Z",
        "_id": "1629208526878x363107462395723800",
        "Created By": "1621354230082x170462043729183700"
      },
      {
        "Modified Date": "2024-06-06T15:39:14.039Z",
        "Created Date": "2021-08-17T14:00:46.311Z",
        "mensagem": "Modified PI Uploads Docs",
        "po-message": "216",
        "UserNamesThatReadMessage": [
          "Leonardo Pacce"
        ],
        "Created By": "1621354230082x170462043729183700",
        "UsersThatReadMessage": [
          "1654261631609x899824825035051800"
        ],
        "Selected_To_Set_As_Read": false,
        "_id": "1629208847253x372987027033423900"
      },
      {
        "UsersThatReadMessage": [
          "1654261631609x899824825035051800"
        ],
        "mensagem": "Modified PI Uploads Docs",
        "po-message": "215",
        "Modified Date": "2024-06-06T15:39:14.040Z",
        "_id": "1629208868705x838078275846144000",
        "UserNamesThatReadMessage": [
          "Leonardo Pacce"
        ],
        "Created Date": "2021-08-17T14:01:07.787Z",
        "Selected_To_Set_As_Read": false,
        "Created By": "1621354230082x170462043729183700"
      },
      {
        "UserNamesThatReadMessage": [
          "Leonardo Pacce"
        ],
        "mensagem": "Modified PI Uploads Docs",
        "Modified Date": "2024-06-06T15:39:14.040Z",
        "po-message": "216",
        "Created By": "1621354230082x170462043729183700",
        "Selected_To_Set_As_Read": false,
        "Created Date": "2021-08-17T14:01:23.494Z",
        "UsersThatReadMessage": [
          "1654261631609x899824825035051800"
        ],
        "_id": "1629208884577x836136246289629200"
      },
      {
        "po-message": "215",
        "Created By": "1621354230082x170462043729183700",
        "Selected_To_Set_As_Read": false,
        "Created Date": "2021-08-17T15:24:21.587Z",
        "UsersThatReadMessage": [
          "1654261631609x899824825035051800"
        ],
        "mensagem": "\"Modified PO Uploads\"",
        "_id": "1629213861097x416056206483259400",
        "UserNamesThatReadMessage": [
          "Leonardo Pacce"
        ],
        "Modified Date": "2024-06-06T15:39:14.040Z"
      },
      {
        "po-message": "216",
        "Created Date": "2021-08-17T15:26:50.840Z",
        "Selected_To_Set_As_Read": false,
        "Modified Date": "2024-06-06T15:39:14.041Z",
        "UserNamesThatReadMessage": [
          "Leonardo Pacce"
        ],
        "_id": "1629214010576x755205650645516300",
        "UsersThatReadMessage": [
          "1654261631609x899824825035051800"
        ],
        "mensagem": "\"Modified PO Uploads\"",
        "Created By": "1621354230082x170462043729183700"
      },
      {
        "Selected_To_Set_As_Read": false,
        "mensagem": "\"Modified PO Uploads\"",
        "Modified Date": "2024-06-06T15:39:14.041Z",
        "Created By": "1621354230082x170462043729183700",
        "Created Date": "2021-08-17T15:27:20.347Z",
        "UsersThatReadMessage": [
          "1654261631609x899824825035051800"
        ],
        "po-message": "216",
        "UserNamesThatReadMessage": [
          "Leonardo Pacce"
        ],
        "_id": "1629214040061x507833558921904100"
      },
      {
        "Created Date": "2021-08-17T15:27:28.388Z",
        "UserNamesThatReadMessage": [
          "Leonardo Pacce"
        ],
        "mensagem": "\"Modified PO Uploads\"",
        "Created By": "1621354230082x170462043729183700",
        "_id": "1629214048118x908739605425029100",
        "Modified Date": "2024-06-06T15:39:14.041Z",
        "UsersThatReadMessage": [
          "1654261631609x899824825035051800"
        ],
        "Selected_To_Set_As_Read": false,
        "po-message": "216"
      },
      {
        "Created Date": "2021-08-17T15:34:53.410Z",
        "_id": "1629214492957x297431150080819200",
        "UsersThatReadMessage": [
          "1654261631609x899824825035051800"
        ],
        "Modified Date": "2024-06-06T15:39:14.042Z",
        "mensagem": "teste",
        "Created By": "1621354230082x170462043729183700",
        "UserNamesThatReadMessage": [
          "Leonardo Pacce"
        ],
        "Selected_To_Set_As_Read": false
      },
      {
        "_id": "1629214494332x799140128099139600",
        "UsersThatReadMessage": [
          "1654261631609x899824825035051800"
        ],
        "Selected_To_Set_As_Read": false,
        "Created By": "1621354230082x170462043729183700",
        "Created Date": "2021-08-17T15:34:54.553Z",
        "UserNamesThatReadMessage": [
          "Leonardo Pacce"
        ],
        "Modified Date": "2024-06-06T15:39:14.239Z"
      },
      {
        "Created By": "1621354230082x170462043729183700",
        "Modified Date": "2024-06-06T15:39:14.240Z",
        "UsersThatReadMessage": [
          "1654261631609x899824825035051800"
        ],
        "Selected_To_Set_As_Read": false,
        "_id": "1629315403222x159900793030836220",
        "mensagem": "Modified Deposit Payments Docs",
        "po-message": "215",
        "UserNamesThatReadMessage": [
          "Leonardo Pacce"
        ],
        "Created Date": "2021-08-18T19:36:44.393Z"
      },
      {
        "Created By": "1621354230082x170462043729183700",
        "Selected_To_Set_As_Read": false,
        "Created Date": "2021-08-18T19:36:58.129Z",
        "po-message": "215",
        "Modified Date": "2024-06-06T15:39:14.240Z",
        "mensagem": "Modified Deposit Payments Docs",
        "UserNamesThatReadMessage": [
          "Leonardo Pacce"
        ],
        "UsersThatReadMessage": [
          "1654261631609x899824825035051800"
        ],
        "_id": "1629315418152x468442021311021060"
      },
      {
        "Created Date": "2021-08-18T19:37:23.613Z",
        "UserNamesThatReadMessage": [
          "Leonardo Pacce"
        ],
        "Modified Date": "2024-06-06T15:39:14.241Z",
        "mensagem": "Modified Packing Confirmation Docs",
        "po-message": "215",
        "Selected_To_Set_As_Read": false,
        "_id": "1629315443435x209727015543898100",
        "UsersThatReadMessage": [
          "1654261631609x899824825035051800"
        ],
        "Created By": "1621354230082x170462043729183700"
      },
      {
        "Created Date": "2021-08-18T20:47:42.248Z",
        "Modified Date": "2024-06-06T15:39:14.241Z",
        "po-message": "215",
        "Created By": "1621354230082x170462043729183700",
        "UserNamesThatReadMessage": [
          "Leonardo Pacce"
        ],
        "Selected_To_Set_As_Read": false,
        "_id": "1629319661689x905517239886151700",
        "mensagem": "Modified Condition Confirmation Docs",
        "UsersThatReadMessage": [
          "1654261631609x899824825035051800"
        ]
      },
      {
        "Modified Date": "2024-06-06T15:39:14.242Z",
        "Selected_To_Set_As_Read": false,
        "po-message": "215",
        "mensagem": "Modified Condition Confirmation Docs",
        "UserNamesThatReadMessage": [
          "Leonardo Pacce"
        ],
        "_id": "1629319744628x550326878464376800",
        "Created By": "1621354230082x170462043729183700",
        "UsersThatReadMessage": [
          "1654261631609x899824825035051800"
        ],
        "Created Date": "2021-08-18T20:49:04.888Z"
      },
      {
        "po-message": "215",
        "Modified Date": "2024-06-06T15:39:14.244Z",
        "UserNamesThatReadMessage": [
          "Leonardo Pacce"
        ],
        "Created By": "1621354230082x170462043729183700",
        "UsersThatReadMessage": [
          "1654261631609x899824825035051800"
        ],
        "Created Date": "2021-08-18T20:49:21.027Z",
        "Selected_To_Set_As_Read": false,
        "_id": "1629319760834x153905772456312830",
        "mensagem": "Modified Place the Order Docs"
      },
      {
        "Created By": "1621354230082x170462043729183700",
        "po-message": "215",
        "mensagem": "Modified Place the Order Docs",
        "UserNamesThatReadMessage": [
          "Leonardo Pacce"
        ],
        "UsersThatReadMessage": [
          "1654261631609x899824825035051800"
        ],
        "_id": "1629319762640x797962099771572200",
        "Created Date": "2021-08-18T20:49:22.452Z",
        "Modified Date": "2024-06-06T15:39:14.244Z",
        "Selected_To_Set_As_Read": false
      },
      {
        "UsersThatReadMessage": [
          "1654261631609x899824825035051800"
        ],
        "Selected_To_Set_As_Read": false,
        "Modified Date": "2024-06-06T15:39:14.245Z",
        "mensagem": "Modified Place the Order Docs",
        "_id": "1629319763695x701617056445628400",
        "Created Date": "2021-08-18T20:49:23.549Z",
        "po-message": "215",
        "UserNamesThatReadMessage": [
          "Leonardo Pacce"
        ],
        "Created By": "1621354230082x170462043729183700"
      },
      {
        "_id": "1629319821390x275765210041024500",
        "Created By": "1621354230082x170462043729183700",
        "UserNamesThatReadMessage": [
          "Leonardo Pacce"
        ],
        "Created Date": "2021-08-18T20:50:21.676Z",
        "UsersThatReadMessage": [
          "1654261631609x899824825035051800"
        ],
        "po-message": "215",
        "mensagem": "Modified Condition Confirmation Docs",
        "Selected_To_Set_As_Read": false,
        "Modified Date": "2024-06-06T15:39:14.245Z"
      }
    ],
    "count": 50,
    "remaining": 54442
  }
}
Response headers
4

The request is working, but the fields and constraints that I wanted not working.

5

Can you copy paste the json constraint here…
You are not settings your constraints correctly in the field in swagger… you need to remove the first part {"constraints": and the last }

6

Ops, I forgot it.
Here is

{“constraints”: [{“key”: “Created Date”,“constraint_type”:“greater than or equal to”,“value”: “{{date}}T00:00:00”},{“key”: “Created Date”, “constraint_type”: “less than or equal to”,“value”: “{{date}}T23:59:59”},{“key”: “OrignType”, “constraint_type”: “text contains”, “value”: “{{orign_type}}”}, {“key”:“TipoConversa”, “constraint_type”: “text contains”, “value”: “{{tipo_conversa}}”},{“key”: “Created By”, “constraint_type”: “text contains”, “value”: “{{created_by}}”} ], “limit”: 100, “cursor”: “next_cursor_value”, “fields”: [ “OrignType”, “TipoConversa”, “Created By”, “Created Date”, “mensagem”]}

7

Would it be this?

[{“key”: “Created Date”,“constraint_type”:“greater than or equal to”,“value”: “{{date}}T00:00:00”},{“key”: “Created Date”, “constraint_type”: “less than or equal to”,“value”: “{{date}}T23:59:59”},{“key”: “OrignType”, “constraint_type”: “text contains”, “value”: “{{orign_type}}”}, {“key”:“TipoConversa”, “constraint_type”: “text contains”, “value”: “{{tipo_conversa}}”},{“key”: “Created By”, “constraint_type”: “text contains”, “value”: “{{created_by}}”} ], “limit”: 100, “cursor”: “next_cursor_value”, “fields”: [ “OrignType”, “TipoConversa”, “Created By”, “Created Date”, “mensagem”]

8

Always better to use the ``` for JSON… forum replace the double quotes without that

What should be sent is the part for the constraints only. Actually, you are also mixing other keys (probably because you tried in JSON)

[{"key": "Created Date","constraint_type":"greater than or equal to","value": "{{date}}T00:00:00"},{"key": "Created Date", "constraint_type": "less than or equal to","value": "{{date}}T23:59:59"},{"key": "OrignType", "constraint_type": "text contains", "value": "{{orign_type}}"}, {"key":"TipoConversa", "constraint_type": "text contains", "value": "{{tipo_conversa}}"},{"key": "Created By", "constraint_type": "text contains", "value": "{{created_by}}"} ]

Is what need to be sent in constraints key

https://agksystem.com/api/1.1/obj/conversas?limit=50&cursor=0&constraints=%5B%7B%22key%22%3A%20%22Created%20Date%22%2C%22constraint_type%22%3A%22greater%20than%20or%20equal%20to%22%2C%22value%22%3A%20%22%7B%7Bdate%7D%7DT00%3A00%3A00%22%7D%2C%7B%22key%22%3A%20%22Created%20Date%22%2C%20%22constraint_type%22%3A%20%22less%20than%20or%20equal%20to%22%2C%22value%22%3A%20%22%7B%7Bdate%7D%7DT23%3A59%3A59%22%7D%2C%7B%22key%22%3A%20%22OrignType%22%2C%20%22constraint_type%22%3A%20%22text%20contains%22%2C%20%22value%22%3A%20%22%7B%7Borign_type%7D%7D%22%7D%2C%20%7B%22key%22%3A%22TipoConversa%22%2C%20%22constraint_type%22%3A%20%22text%20contains%22%2C%20%22value%22%3A%20%22%7B%7Btipo_conversa%7D%7D%22%7D%2C%7B%22key%22%3A%20%22Created%20By%22%2C%20%22constraint_type%22%3A%20%22text%20contains%22%2C%20%22value%22%3A%20%22%7B%7Bcreated_by%7D%7D%22%7D%20%5D

However, I cannot really test since I don’t have real values (instead of your placeholders)

by the way, greater than or equal does’t exist as an operator. You need to use greater than…

Example with the create date only set:
and that is working:
https://agksystem.com/api/1.1/obj/conversas?limit=50&cursor=0&constraints=[{"key"%3A%20"Created%20Date"%2C"constraint_type"%3A"greater%20than"%2C"value"%3A%20"2021-01-01T00%3A00%3A00"}%20]

9

I fixed the problems about the variables I did not see before.
The json was this way:

{“constraints”: [{“key”: “Created Date”,“constraint_type”: “greater than”,“value”: “2025-03-13T00:00:00”},{“key”: “Created Date”,“constraint_type”: “less than”,“value”: “2025-03-13T23:59:59”},{“key”: “OrignType”,“constraint_type”: “text contains”,“value”: “Pre-Loading”},{“key”: “TipoConversa”,“constraint_type”: “text contains”,“value”: “Conversa”},{“key”: “Created By”,“constraint_type”: “text contains”,“value”: “Julia”}],“limit”: 10,“cursor”: “next_cursor_value”,“fields”: [“OrignType”,“TipoConversa”,“Created By”,“Created Date”,“mensagem”]}

I change the date filter with “greater than” and “less than”.
“Less Then” exists?

I change the date to 2025-03-13 in your example and worked here.
https://agksystem.com/api/1.1/obj/conversas?limit=50&cursor=0&constraints=[{"key"%3A%20"Created%20Date"%2C"constraint_type"%3A"greater%20than"%2C"value"%3A%20"2025-03-13T00%3A00%3A00"}%20]

I will test the other filters to see the results.
Thanks

10

Constraints type here:

With possible value. less than exist.