S&P Global

App · 7 actions

Retrieve Capital IQ financial fundamentals, historical values, time series, vectors and usage.

Actions

ActionWhat it does
Get API usageRetrieve daily usage and hourly, daily and monthly account limits.
Get current vectorGet current vector using the GDSPV query function.
Get grouped dataGet grouped data using the GDSG query function.
Get historical valuesGet historical values using the GDSHE query function.
Get historical vectorGet historical vector using the GDSHV query function.
Get point-in-time valueGet point-in-time value using the GDSP query function.
Get time seriesGet time series using the GDST query function.

Get API usage

Retrieve daily usage and hourly, daily and monthly account limits.

Inputs

As of dateas_of_datedate
Usage date. Leave empty for today.
Start datestart_datedate
First day, at most 31 days before the last.
End dateend_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

IdentifieridentifiertextRequired
Capital IQ entity or security identifier, such as IBM:NYSE.
MnemonicmnemonictextRequired
Data mnemonic licensed for your account. Grouped queries require a group mnemonic.
Period typeperiod_typetext
Financial period, including offsets, such as IQ_FY or IQ_FY-1.
As of dateas_of_datedate
Point-in-time date.
Start datestart_datedate
First observation date.
End dateend_datedate
Last observation date.
Frequencyfrequencytext
Observation frequency.One of: Daily, Weekly, Monthly, Quarterly, Annual.
Propertiespropertiesobject
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

IdentifieridentifiertextRequired
Capital IQ entity or security identifier, such as IBM:NYSE.
MnemonicmnemonictextRequired
Data mnemonic licensed for your account. Grouped queries require a group mnemonic.
Period typeperiod_typetext
Financial period, including offsets, such as IQ_FY or IQ_FY-1.
As of dateas_of_datedate
Point-in-time date.
Start datestart_datedate
First observation date.
End dateend_datedate
Last observation date.
Frequencyfrequencytext
Observation frequency.One of: Daily, Weekly, Monthly, Quarterly, Annual.
Propertiespropertiesobject
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

IdentifieridentifiertextRequired
Capital IQ entity or security identifier, such as IBM:NYSE.
MnemonicmnemonictextRequired
Data mnemonic licensed for your account. Grouped queries require a group mnemonic.
Period typeperiod_typetext
Financial period, including offsets, such as IQ_FY or IQ_FY-1.
As of dateas_of_datedate
Point-in-time date.
Start datestart_datedate
First observation date.
End dateend_datedate
Last observation date.
Frequencyfrequencytext
Observation frequency.One of: Daily, Weekly, Monthly, Quarterly, Annual.
Propertiespropertiesobject
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

IdentifieridentifiertextRequired
Capital IQ entity or security identifier, such as IBM:NYSE.
MnemonicmnemonictextRequired
Data mnemonic licensed for your account. Grouped queries require a group mnemonic.
Period typeperiod_typetext
Financial period, including offsets, such as IQ_FY or IQ_FY-1.
As of dateas_of_datedate
Point-in-time date.
Start datestart_datedate
First observation date.
End dateend_datedate
Last observation date.
Frequencyfrequencytext
Observation frequency.One of: Daily, Weekly, Monthly, Quarterly, Annual.
Propertiespropertiesobject
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

IdentifieridentifiertextRequired
Capital IQ entity or security identifier, such as IBM:NYSE.
MnemonicmnemonictextRequired
Data mnemonic licensed for your account. Grouped queries require a group mnemonic.
Period typeperiod_typetext
Financial period, including offsets, such as IQ_FY or IQ_FY-1.
As of dateas_of_datedate
Point-in-time date.
Start datestart_datedate
First observation date.
End dateend_datedate
Last observation date.
Frequencyfrequencytext
Observation frequency.One of: Daily, Weekly, Monthly, Quarterly, Annual.
Propertiespropertiesobject
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

IdentifieridentifiertextRequired
Capital IQ entity or security identifier, such as IBM:NYSE.
MnemonicmnemonictextRequired
Data mnemonic licensed for your account. Grouped queries require a group mnemonic.
Period typeperiod_typetext
Financial period, including offsets, such as IQ_FY or IQ_FY-1.
As of dateas_of_datedate
Point-in-time date.
Start datestart_datedate
First observation date.
End dateend_datedate
Last observation date.
Frequencyfrequencytext
Observation frequency.One of: Daily, Weekly, Monthly, Quarterly, Annual.
Propertiespropertiesobject
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
}

On this page