How to get all entities of a database?

Ideas & Features Automations
1

I have a list of to-be-deleted ids, but using

await deleteEntityBatch(type, ids)

doesn’t delete them. To double confirm I want to check whether an id string is in a database or not. I read the documentation and find nothing.

https://the.fibery.io/@public/User_Guide/Guide/Scripts-in-Automations-54

2

Simplest way is probably to use a graphql query.
https://the.fibery.io/@public/User_Guide/Guide/GraphQL-Queries-255

3

just for the sake of learning, what would be other ways?

4

A normal API entity query.

5

So I guess there is no way to query that in the automation script? Why is that?

6

Yeah, sure. It’s possible to make graphql and/or regular API calls from a script.
Use
graphql()
or
executeSingleCommand()
function.

https://the.fibery.io/@public/User_Guide/Guide/Scripts-in-Automations-54/anchor=Fibery-service-workspace-functions--86ec1778-15d4-42dc-a533-a57ec38bc855

7 
const fibery = context.getService("fibery");
const query = '{findKyPhis {id, name}}'
const graphql = await fibery.graphql("Kỳ phí", query)
console.log(graphql)

The result:

Failed to execute Action "Script": Request path contains unescaped characters

I’m not sure what path it’s referring to. Trying:

const query = '\{findKyPhis \{id, name\}\}'

doesn’t help either.

I mean, why there isn’t a native way to get that in the automation script? It seems to me that it’s better to use webhook instead of automation scripts.

8

:person_shrugging:
I guess there hasn’t been enough demand for it to warrant spending developer time on it.

But overall, I’m not sure what you’re trying to achieve.
You wrote

but that

Where did the list of ids to be deleted come from?
I’m curious how you can already have a list of ids to be deleted but not know whether or not there exist any entities with these ids?

9

If you need to delete all entities from one database, here is the trick

  1. Create new Space and move this database to this Space
  2. Click … near new Space name and select Delete all Data
  3. Move database back to original Space
  4. Delete just created space completely
1 Like
10

If you remember my previous question, in db A I have a many-to-one relation field with db B. So I get the list of ids of B entities my querying on A:

const bEntities  = (await fibery.getEntityById(dbA, aEntityId, ["field"]))["field"]
const ids = bEntities.map(({ Id }) => Id)

Any idea on how to fix this code?

11

I can’t immediately see what’s wrong with your code, but I’m wondering what the underlying problem to be solved is, and why you’re choosing to attempt a solution with scripting?

Is it not possible to solve with no-code automation actions?

12

Actually, the problem is almost certainly the non-english characters in your space name.

I tried with a space called "Ky phi" instead of "Kỳ phí" and it worked fine

1 Like
13

My problem is to recalculate the intervals of insurance payment. The A database is the contracts. One of its fields is the intervals (monthly, quarterly, semi-annually, annually), and another one is a relation field to B. The B database contains all the payment periods. (This is what “Kỳ phí” means). When I change the interval of a contract, outdated periods from previous calculation are deleted and updated periods are created.

The calculation is complex enough that no-code automation action can handle. So far I have written around 300 lines of code, not to mention test cases and bundle scripts.

I understand it now. However replacing the name with encodeURIComponent("Kỳ phí") results this new error:

Failed to execute Action "Script": There are no any databases for space [Kỳ phí]
14

I just tested as shown below, and it works fine for me.

image
image1204×305 20 KB

1 Like
15

Ah stupid me. I mistook the space name and the database name