Viewing Collection: oldaction


_id name datasource actionConfiguration pluginType executeOnLoad dynamicBindingPathList isValid invalids jsonPathKeys deleted policies _class organizationId pageId pluginId createdAt
5f50e96df747d027c17427b4
getSignupCount 
{
  "name": "Mock Database",
  "datasourceConfiguration": {
    "connection": {
      "mode": "READ_WRITE"
    },
    "endpoints": [
      {
        "host": "fake-api.cvuydmurdlas.us-east-1.rds.amazonaws.com",
        "port": 5432
      }
    ],
    "authentication": {
      "username": "fakeapi",
      "password": "LimitedAccess123#",
      "databaseName": "fakeapi"
    },
    "sshProxyEnabled": false
  },
  "invalids": [],
  "deleted": false,
  "policies": [],
  "pluginId": "5f50e96cf747d027c1742794",
  "organizationId": "5f50e96df747d027c17427ae",
  "_id": "5f50e96df747d027c17427af"
}
 
{
  "timeoutInMillisecond": 10000,
  "paginationType": "NONE",
  "body": "SELECT count(id), TO_CHAR(\"createdAt\" :: DATE, 'dd/mm/yyyy') as sign_up_date FROM users GROUP BY sign_up_date ORDER BY sign_up_date limit 31;\n"
}
DB
true
true
false
com.appsmith.server.domains.Action
5f50e96df747d027c17427ae
5f50e96df747d027c17427b3
Thu Sep 03 2020 13:02:37 GMT+0000 (UTC)
5f50e96df747d027c17427b7
getFilteredSignupCount 
{
  "name": "Mock Database",
  "datasourceConfiguration": {
    "connection": {
      "mode": "READ_WRITE"
    },
    "endpoints": [
      {
        "host": "fake-api.cvuydmurdlas.us-east-1.rds.amazonaws.com",
        "port": 5432
      }
    ],
    "authentication": {
      "username": "fakeapi",
      "password": "LimitedAccess123#",
      "databaseName": "fakeapi"
    },
    "sshProxyEnabled": false
  },
  "invalids": [],
  "deleted": false,
  "policies": [],
  "pluginId": "5f50e96cf747d027c1742794",
  "organizationId": "5f50e96df747d027c17427ae",
  "_id": "5f50e96df747d027c17427af"
}
 
{
  "timeoutInMillisecond": 10000,
  "paginationType": "NONE",
  "body": "SELECT count(id), TO_CHAR(\"createdAt\" :: DATE, 'dd/mm/yyyy') as sign_up_date FROM users where \"createdAt\" >= '{{startDatePicker.selectedDate}}' and \"createdAt\" <= '{{endDatePicker.selectedDate}}' GROUP BY sign_up_date ORDER BY sign_up_date;\n"
}
DB
true 
[
  {
    "key": "body"
  }
]
true
startDatePicker.selectedDate,endDatePicker.selectedDate
false
com.appsmith.server.domains.Action
5f50e96df747d027c17427ae
5f50e96df747d027c17427b6
Thu Sep 03 2020 13:02:37 GMT+0000 (UTC)
5f50e96df747d027c17427bb
Api1 
{
  "name": "https://api.razorpay.com",
  "datasourceConfiguration": {
    "url": "https://api.razorpay.com"
  },
  "invalids": [],
  "deleted": false,
  "policies": [],
  "pluginId": "5f50e96cf747d027c1742795",
  "organizationId": "5f50e96df747d027c17427ae"
}
 
{
  "timeoutInMillisecond": 10000,
  "paginationType": "NONE",
  "path": "/v1/payments/pay_29QQoUBi66xm2f/refund",
  "headers": [
    {
      "key": "Authorization",
      "value": "Basic cnpwX3Rlc3RfSVNsVXdaWmJXUzQ1Tlo6UFJFaTZSdzBEYVdlZEtnU3VOcU5LY3B5"
    },
    {
      "key": "Content-Type",
      "value": "application/json"
    }
  ],
  "queryParameters": [
    {
      "key": "",
      "value": ""
    },
    {
      "key": "",
      "value": ""
    }
  ],
  "body": "{  \"amount\": 2000}",
  "httpMethod": "POST"
}
API
true
false
com.appsmith.server.domains.Action
5f50e96df747d027c17427ae
5f50e96df747d027c17427ba
Thu Sep 03 2020 13:02:37 GMT+0000 (UTC)
5f50e96df747d027c17427bc
getOrderProducts 
{
  "name": "Mock Database",
  "datasourceConfiguration": {
    "connection": {
      "mode": "READ_WRITE"
    },
    "endpoints": [
      {
        "host": "fake-api.cvuydmurdlas.us-east-1.rds.amazonaws.com",
        "port": 5432
      }
    ],
    "authentication": {
      "username": "fakeapi",
      "password": "LimitedAccess123#",
      "databaseName": "fakeapi"
    },
    "sshProxyEnabled": false
  },
  "invalids": [],
  "deleted": false,
  "policies": [],
  "pluginId": "5f50e96cf747d027c1742794",
  "organizationId": "5f50e96df747d027c17427ae",
  "_id": "5f50e96df747d027c17427af"
}
 
{
  "timeoutInMillisecond": 10000,
  "paginationType": "NONE",
  "body": "SELECT products.* FROM products inner join \"orderProductMap\" on products.\"productId\" = \"orderProductMap\".\"productId\" where \"orderProductMap\".\"orderId\" = {{ordersTable.selectedRow.id}} ORDER BY id LIMIT 10;\n"
}
DB 
[
  {
    "key": "body"
  }
]
true
ordersTable.selectedRow.id
false
com.appsmith.server.domains.Action
5f50e96df747d027c17427ae
5f50e96df747d027c17427ba
Thu Sep 03 2020 13:02:37 GMT+0000 (UTC)
5f50e96df747d027c17427bd
getOrders 
{
  "name": "Mock Database",
  "datasourceConfiguration": {
    "connection": {
      "mode": "READ_WRITE"
    },
    "endpoints": [
      {
        "host": "fake-api.cvuydmurdlas.us-east-1.rds.amazonaws.com",
        "port": 5432
      }
    ],
    "authentication": {
      "username": "fakeapi",
      "password": "LimitedAccess123#",
      "databaseName": "fakeapi"
    },
    "sshProxyEnabled": false
  },
  "invalids": [],
  "deleted": false,
  "policies": [],
  "pluginId": "5f50e96cf747d027c1742794",
  "organizationId": "5f50e96df747d027c17427ae",
  "_id": "5f50e96df747d027c17427af"
}
 
{
  "timeoutInMillisecond": 10000,
  "paginationType": "NONE",
  "body": "SELECT * FROM orders where \"userId\"={{usersTable.selectedRow.id}} ORDER BY status LIMIT 10;\n"
}
DB 
[
  {
    "key": "body"
  }
]
true
usersTable.selectedRow.id
false
com.appsmith.server.domains.Action
5f50e96df747d027c17427ae
5f50e96df747d027c17427ba
Thu Sep 03 2020 13:02:37 GMT+0000 (UTC)
5f50e96df747d027c17427be
getUsers 
{
  "name": "Mock Database",
  "datasourceConfiguration": {
    "connection": {
      "mode": "READ_WRITE"
    },
    "endpoints": [
      {
        "host": "fake-api.cvuydmurdlas.us-east-1.rds.amazonaws.com",
        "port": 5432
      }
    ],
    "authentication": {
      "username": "fakeapi",
      "password": "LimitedAccess123#",
      "databaseName": "fakeapi"
    },
    "sshProxyEnabled": false
  },
  "invalids": [],
  "deleted": false,
  "policies": [],
  "pluginId": "5f50e96cf747d027c1742794",
  "organizationId": "5f50e96df747d027c17427ae",
  "_id": "5f50e96df747d027c17427af"
}
 
{
  "timeoutInMillisecond": 10000,
  "paginationType": "NONE",
  "body": "SELECT * FROM users where email ilike '%{{usersTable.searchText}}%' ORDER BY id LIMIT 10 offset {{(usersTable.pageNo - 1) * 10}}"
}
DB
true 
[
  {
    "key": "body"
  }
]
true
usersTable.searchText,(usersTable.pageNo - 1) * 10
false
com.appsmith.server.domains.Action
5f50e96df747d027c17427ae
5f50e96df747d027c17427ba
Thu Sep 03 2020 13:02:37 GMT+0000 (UTC)
5f50e96df747d027c17427bf
markOrderRefund 
{
  "name": "Mock Database",
  "datasourceConfiguration": {
    "connection": {
      "mode": "READ_WRITE"
    },
    "endpoints": [
      {
        "host": "fake-api.cvuydmurdlas.us-east-1.rds.amazonaws.com",
        "port": 5432
      }
    ],
    "authentication": {
      "username": "fakeapi",
      "password": "LimitedAccess123#",
      "databaseName": "fakeapi"
    },
    "sshProxyEnabled": false
  },
  "invalids": [],
  "deleted": false,
  "policies": [],
  "pluginId": "5f50e96cf747d027c1742794",
  "organizationId": "5f50e96df747d027c17427ae",
  "_id": "5f50e96df747d027c17427af"
}
 
{
  "timeoutInMillisecond": 10000,
  "paginationType": "NONE",
  "body": "UPDATE orders\n  SET status = 'REFUNDED'\n  WHERE id = {{ordersTable.selectedRow.id}};\n"
}
DB 
[
  {
    "key": "body"
  }
]
true
ordersTable.selectedRow.id
false
com.appsmith.server.domains.Action
5f50e96df747d027c17427ae
5f50e96df747d027c17427ba
Thu Sep 03 2020 13:02:37 GMT+0000 (UTC)
5f50e96df747d027c17427c0
refundAPI 
{
  "name": "https://api.razorpay.com",
  "datasourceConfiguration": {
    "url": "https://api.razorpay.com"
  },
  "invalids": [],
  "deleted": false,
  "policies": [],
  "pluginId": "5f50e96cf747d027c1742795",
  "organizationId": "5f50e96df747d027c17427ae"
}
 
{
  "timeoutInMillisecond": 10000,
  "paginationType": "NONE",
  "path": "/v1/payments/{{ordersTable.selectedRow.paymentId}}/refund",
  "headers": [
    {
      "key": "Authorization",
      "value": "Basic cnpwX3Rlc3RfSVNsVXdaWmJXUzQ1Tlo6UFJFaTZSdzBEYVdlZEtnU3VOcU5LY3B5"
    },
    {
      "key": "Content-Type",
      "value": "application/json"
    }
  ],
  "queryParameters": [
    {
      "key": "",
      "value": ""
    },
    {
      "key": "",
      "value": ""
    }
  ],
  "body": "{  \n\t\"amount\": \"{{ordersTable.selectedRow.orderAmount * 100}}\"\n}",
  "httpMethod": "POST"
}
API 
[
  {
    "key": "body"
  },
  {
    "key": "path"
  }
]
true
ordersTable.selectedRow.orderAmount * 100,ordersTable.selectedRow.paymentId
false
com.appsmith.server.domains.Action
5f50e96df747d027c17427ae
5f50e96df747d027c17427ba
Thu Sep 03 2020 13:02:37 GMT+0000 (UTC)
5f50e96df747d027c17427c1
updateUser 
{
  "name": "Mock Database",
  "datasourceConfiguration": {
    "connection": {
      "mode": "READ_WRITE"
    },
    "endpoints": [
      {
        "host": "fake-api.cvuydmurdlas.us-east-1.rds.amazonaws.com",
        "port": 5432
      }
    ],
    "authentication": {
      "username": "fakeapi",
      "password": "LimitedAccess123#",
      "databaseName": "fakeapi"
    },
    "sshProxyEnabled": false
  },
  "invalids": [],
  "deleted": false,
  "policies": [],
  "pluginId": "5f50e96cf747d027c1742794",
  "organizationId": "5f50e96df747d027c17427ae",
  "_id": "5f50e96df747d027c17427af"
}
 
{
  "timeoutInMillisecond": 10000,
  "paginationType": "NONE",
  "body": "UPDATE users SET name = '{{nameInput.text}}', address = '{{addressInput.text}}', email = '{{emailInput.text}}', \"phoneNo\" = '{{phoneInput.text}}' WHERE id = {{usersTable.selectedRow.id}}"
}
DB 
[
  {
    "key": "body"
  }
]
true
phoneInput.text,addressInput.text,nameInput.text,usersTable.selectedRow.id,emailInput.text
false
com.appsmith.server.domains.Action
5f50e96df747d027c17427ae
5f50e96df747d027c17427ba
Thu Sep 03 2020 13:02:37 GMT+0000 (UTC)
5f50e96df747d027c17427c4
getTickets 
{
  "name": "https://appsmithhelp.freshdesk.com",
  "datasourceConfiguration": {
    "url": "https://appsmithhelp.freshdesk.com"
  },
  "invalids": [],
  "deleted": false,
  "policies": [],
  "pluginId": "5f50e96cf747d027c1742795",
  "organizationId": "5f50e96df747d027c17427ae"
}
 
{
  "timeoutInMillisecond": 10000,
  "paginationType": "NONE",
  "path": "/api/v2/tickets",
  "headers": [
    {
      "key": "Authorization",
      "value": "Basic dG51cjdrUlk4MjRCM3l5eElaeTp0ZXN0"
    },
    {
      "key": "",
      "value": ""
    }
  ],
  "queryParameters": [
    {
      "key": "include",
      "value": "requester,description"
    },
    {
      "key": "",
      "value": ""
    }
  ],
  "httpMethod": "GET"
}
API
true
false
com.appsmith.server.domains.Action
5f50e96df747d027c17427ae
5f50e96df747d027c17427c3
Thu Sep 03 2020 13:02:37 GMT+0000 (UTC)

Rename Collection

ubos_prod .

Tools


Export Standard

Export --jsonArray

Export --csv

Reindex

Import

Compact

Collection Stats

Documents 434
Total doc size 5.86 MB
Average doc size 13.82 KB
Pre-allocated size 1.52 MB
Indexes 3
Total index size 60 KB
Padding factor
Extents

Indexes

Name Columns Size Attributes Actions
_id_
_id   ASC
20 KB
 DEL
createdAt
createdAt   ASC
16 KB
 DEL
action_page_compound_index
pageId   ASC
name   ASC
24 KB
unique:  true
 DEL