S&P Global
App · 7 actions
Retrieve Capital IQ financial fundamentals, historical values, time series, vectors and usage.
Actions
| Action | What it does |
|---|---|
| Get API usage | Retrieve daily usage and hourly, daily and monthly account limits. |
| Get current vector | Get current vector using the GDSPV query function. |
| Get grouped data | Get grouped data using the GDSG query function. |
| Get historical values | Get historical values using the GDSHE query function. |
| Get historical vector | Get historical vector using the GDSHV query function. |
| Get point-in-time value | Get point-in-time value using the GDSP query function. |
| Get time series | Get time series using the GDST query function. |
Get API usage
Retrieve daily usage and hourly, daily and monthly account limits.
Inputs
- As of date
as_of_datedate - Usage date. Leave empty for today.
- Start date
start_datedate - First day, at most 31 days before the last.
- End date
end_datedate - Last day.
Outputs
Value.
dataobject- Capital IQ responses, one entry per query.
has_moretrue/false- Whether another page is available.
next_cursortext- Continuation value, or empty at the end.
Example output
{
"data": {
"GDSSDKResponse": [
{
"ErrMsg": "example",
"Headers": [
"example"
],
"Identifier": "example",
"Mnemonic": "example",
"NumRows": 1,
"Rows": [
{}
]
}
]
},
"has_more": false,
"next_cursor": null
}Get current vector
Get current vector using the GDSPV query function. Requires the corresponding dataset entitlement.
Inputs
- Identifier
identifiertextRequired - Capital IQ entity or security identifier, such as IBM:NYSE.
- Mnemonic
mnemonictextRequired - Data mnemonic licensed for your account. Grouped queries require a group mnemonic.
- Period type
period_typetext - Financial period, including offsets, such as IQ_FY or IQ_FY-1.
- As of date
as_of_datedate - Point-in-time date.
- Start date
start_datedate - First observation date.
- End date
end_datedate - Last observation date.
- Frequency
frequencytext - Observation frequency.One of:
Daily,Weekly,Monthly,Quarterly,Annual. - Properties
propertiesobject - Additional dataset-specific properties from your Capital IQ data dictionary.
Outputs
Value.
dataobject- Capital IQ responses, one entry per query.
has_moretrue/false- Whether another page is available.
next_cursortext- Continuation value, or empty at the end.
Example output
{
"data": {
"GDSSDKResponse": [
{
"ErrMsg": "example",
"Headers": [
"example"
],
"Identifier": "example",
"Mnemonic": "example",
"NumRows": 1,
"Rows": [
{}
]
}
]
},
"has_more": false,
"next_cursor": null
}Get grouped data
Get grouped data using the GDSG query function. Requires the corresponding dataset entitlement.
Inputs
- Identifier
identifiertextRequired - Capital IQ entity or security identifier, such as IBM:NYSE.
- Mnemonic
mnemonictextRequired - Data mnemonic licensed for your account. Grouped queries require a group mnemonic.
- Period type
period_typetext - Financial period, including offsets, such as IQ_FY or IQ_FY-1.
- As of date
as_of_datedate - Point-in-time date.
- Start date
start_datedate - First observation date.
- End date
end_datedate - Last observation date.
- Frequency
frequencytext - Observation frequency.One of:
Daily,Weekly,Monthly,Quarterly,Annual. - Properties
propertiesobject - Additional dataset-specific properties from your Capital IQ data dictionary.
Outputs
Value.
dataobject- Capital IQ responses, one entry per query.
has_moretrue/false- Whether another page is available.
next_cursortext- Continuation value, or empty at the end.
Example output
{
"data": {
"GDSSDKResponse": [
{
"ErrMsg": "example",
"Headers": [
"example"
],
"Identifier": "example",
"Mnemonic": "example",
"NumRows": 1,
"Rows": [
{}
]
}
]
},
"has_more": false,
"next_cursor": null
}Get historical values
Get historical values using the GDSHE query function. Requires the corresponding dataset entitlement.
Inputs
- Identifier
identifiertextRequired - Capital IQ entity or security identifier, such as IBM:NYSE.
- Mnemonic
mnemonictextRequired - Data mnemonic licensed for your account. Grouped queries require a group mnemonic.
- Period type
period_typetext - Financial period, including offsets, such as IQ_FY or IQ_FY-1.
- As of date
as_of_datedate - Point-in-time date.
- Start date
start_datedate - First observation date.
- End date
end_datedate - Last observation date.
- Frequency
frequencytext - Observation frequency.One of:
Daily,Weekly,Monthly,Quarterly,Annual. - Properties
propertiesobject - Additional dataset-specific properties from your Capital IQ data dictionary.
Outputs
Value.
dataobject- Capital IQ responses, one entry per query.
has_moretrue/false- Whether another page is available.
next_cursortext- Continuation value, or empty at the end.
Example output
{
"data": {
"GDSSDKResponse": [
{
"ErrMsg": "example",
"Headers": [
"example"
],
"Identifier": "example",
"Mnemonic": "example",
"NumRows": 1,
"Rows": [
{}
]
}
]
},
"has_more": false,
"next_cursor": null
}Get historical vector
Get historical vector using the GDSHV query function. Requires the corresponding dataset entitlement.
Inputs
- Identifier
identifiertextRequired - Capital IQ entity or security identifier, such as IBM:NYSE.
- Mnemonic
mnemonictextRequired - Data mnemonic licensed for your account. Grouped queries require a group mnemonic.
- Period type
period_typetext - Financial period, including offsets, such as IQ_FY or IQ_FY-1.
- As of date
as_of_datedate - Point-in-time date.
- Start date
start_datedate - First observation date.
- End date
end_datedate - Last observation date.
- Frequency
frequencytext - Observation frequency.One of:
Daily,Weekly,Monthly,Quarterly,Annual. - Properties
propertiesobject - Additional dataset-specific properties from your Capital IQ data dictionary.
Outputs
Value.
dataobject- Capital IQ responses, one entry per query.
has_moretrue/false- Whether another page is available.
next_cursortext- Continuation value, or empty at the end.
Example output
{
"data": {
"GDSSDKResponse": [
{
"ErrMsg": "example",
"Headers": [
"example"
],
"Identifier": "example",
"Mnemonic": "example",
"NumRows": 1,
"Rows": [
{}
]
}
]
},
"has_more": false,
"next_cursor": null
}Get point-in-time value
Get point-in-time value using the GDSP query function. Requires the corresponding dataset entitlement.
Inputs
- Identifier
identifiertextRequired - Capital IQ entity or security identifier, such as IBM:NYSE.
- Mnemonic
mnemonictextRequired - Data mnemonic licensed for your account. Grouped queries require a group mnemonic.
- Period type
period_typetext - Financial period, including offsets, such as IQ_FY or IQ_FY-1.
- As of date
as_of_datedate - Point-in-time date.
- Start date
start_datedate - First observation date.
- End date
end_datedate - Last observation date.
- Frequency
frequencytext - Observation frequency.One of:
Daily,Weekly,Monthly,Quarterly,Annual. - Properties
propertiesobject - Additional dataset-specific properties from your Capital IQ data dictionary.
Outputs
Value.
dataobject- Capital IQ responses, one entry per query.
has_moretrue/false- Whether another page is available.
next_cursortext- Continuation value, or empty at the end.
Example output
{
"data": {
"GDSSDKResponse": [
{
"ErrMsg": "example",
"Headers": [
"example"
],
"Identifier": "example",
"Mnemonic": "example",
"NumRows": 1,
"Rows": [
{}
]
}
]
},
"has_more": false,
"next_cursor": null
}Get time series
Get time series using the GDST query function. Requires the corresponding dataset entitlement.
Inputs
- Identifier
identifiertextRequired - Capital IQ entity or security identifier, such as IBM:NYSE.
- Mnemonic
mnemonictextRequired - Data mnemonic licensed for your account. Grouped queries require a group mnemonic.
- Period type
period_typetext - Financial period, including offsets, such as IQ_FY or IQ_FY-1.
- As of date
as_of_datedate - Point-in-time date.
- Start date
start_datedate - First observation date.
- End date
end_datedate - Last observation date.
- Frequency
frequencytext - Observation frequency.One of:
Daily,Weekly,Monthly,Quarterly,Annual. - Properties
propertiesobject - Additional dataset-specific properties from your Capital IQ data dictionary.
Outputs
Value.
dataobject- Capital IQ responses, one entry per query.
has_moretrue/false- Whether another page is available.
next_cursortext- Continuation value, or empty at the end.
Example output
{
"data": {
"GDSSDKResponse": [
{
"ErrMsg": "example",
"Headers": [
"example"
],
"Identifier": "example",
"Mnemonic": "example",
"NumRows": 1,
"Rows": [
{}
]
}
]
},
"has_more": false,
"next_cursor": null
}