Company Data API
Added Companies API
Filtering and sorting
Filtering
Alerts API provides capabilities to filter and sort its output. It's achieved by using the
where argument on the alerts node of the Craft API.where allows constructing an expression that will be matched against the available Alerts and filter. The general syntax is to use the field from the Alert entity and compare it with a certain value using a specific operator.1
alerts(
2
where: {
3
field: { operator: value }
4
}
5
)
Copied!
Please, see the AlertBoolExpression type definition for all of the available fields and operators available.
It's also possible to specify multiple fields which will be combined with a logical "AND":
1
alerts(
2
where: {
3
firstField: { operator: value },
4
secondField: { operator: value }
5
}
6
)
Copied!
In such case, API will return Alerts where
firstField and secondField are matching provided values.Filter examples
1
query GetAlerts($where: AlertsBoolExpression!) {
2
alerts(where: $where) {
3
id
4
company {
5
id
6
}
7
text
8
title
9
}
10
}
Copied!
For the query above,
$where variable may have following shapes:1
[
2
{
3
// Will filter by either "company.id"
4
// or "relatedCompanies.id"
5
company: { id: { eq: 429 } }
6
},
7
{
8
// String | Int can be used interchangeably for
9
// the ID type
10
company: { id: { eq: "429" } }
11
},
12
{
13
// Find alerts for any of the listed companies
14
company: { id: { in: ["429", "229"] } }
15
},
16
{
17
// Will find Alerts where the Company id is 429
18
// and dataset is either "jobs" or "pnl"
19
company: { id: { eq: 429 } },
20
dataset: { in: ["jobs", "pnl"] }
21
},
22
{
23
// Will find all "positive" Alerts with the
24
// given class code
25
polarity: { gt: 0 },
26
class: { code: { eq: "awards" } }
27
},
28
{
29
publishedAt: {
30
// Multiple operators can be combined together
31
// and will be executed with logical "AND".
32
// This filter will find alerts published
33
// between the given dates.
34
gte: "2022-02-01",
35
lt: "2022-03-01"
36
}
37
}
38
]
Copied!
Sorting
By default Alerts API output is sorted chronologically by
publishedAt field in descending (most recent Alerts first) order. To change the order to ascending order (oldest published Alerts first), it's possible to specify the orderBy argument on the alerts node:1
query GetAlerts {
2
alerts(
3
orderBy: { publishedAt: ASC }
4
)
5
}
Copied!
Last modified 1mo ago