# S&P Global

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

App · 7 actions. Web page: https://docs.lodol.com/docs/integrations/sp-global

## Actions

### Get API usage

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

**Inputs**

- As of date (`as_of_date`, date): Usage date. Leave empty for today.
- Start date (`start_date`, date): First day, at most 31 days before the last.
- End date (`end_date`, date): Last day.

**Outputs**: Value.

- `data` (object): Capital IQ responses, one entry per query.
- `has_more` (true/false): Whether another page is available.
- `next_cursor` (text): Continuation value, or empty at the end.

**Example output**

```json
{
  "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 (`identifier`, text, required): Capital IQ entity or security identifier, such as IBM:NYSE.
- Mnemonic (`mnemonic`, text, required): Data mnemonic licensed for your account. Grouped queries require a group mnemonic.
- Period type (`period_type`, text): Financial period, including offsets, such as IQ_FY or IQ_FY-1.
- As of date (`as_of_date`, date): Point-in-time date.
- Start date (`start_date`, date): First observation date.
- End date (`end_date`, date): Last observation date.
- Frequency (`frequency`, text): Observation frequency. One of: `Daily`, `Weekly`, `Monthly`, `Quarterly`, `Annual`.
- Properties (`properties`, object): Additional dataset-specific properties from your Capital IQ data dictionary.

**Outputs**: Value.

- `data` (object): Capital IQ responses, one entry per query.
- `has_more` (true/false): Whether another page is available.
- `next_cursor` (text): Continuation value, or empty at the end.

**Example output**

```json
{
  "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 (`identifier`, text, required): Capital IQ entity or security identifier, such as IBM:NYSE.
- Mnemonic (`mnemonic`, text, required): Data mnemonic licensed for your account. Grouped queries require a group mnemonic.
- Period type (`period_type`, text): Financial period, including offsets, such as IQ_FY or IQ_FY-1.
- As of date (`as_of_date`, date): Point-in-time date.
- Start date (`start_date`, date): First observation date.
- End date (`end_date`, date): Last observation date.
- Frequency (`frequency`, text): Observation frequency. One of: `Daily`, `Weekly`, `Monthly`, `Quarterly`, `Annual`.
- Properties (`properties`, object): Additional dataset-specific properties from your Capital IQ data dictionary.

**Outputs**: Value.

- `data` (object): Capital IQ responses, one entry per query.
- `has_more` (true/false): Whether another page is available.
- `next_cursor` (text): Continuation value, or empty at the end.

**Example output**

```json
{
  "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 (`identifier`, text, required): Capital IQ entity or security identifier, such as IBM:NYSE.
- Mnemonic (`mnemonic`, text, required): Data mnemonic licensed for your account. Grouped queries require a group mnemonic.
- Period type (`period_type`, text): Financial period, including offsets, such as IQ_FY or IQ_FY-1.
- As of date (`as_of_date`, date): Point-in-time date.
- Start date (`start_date`, date): First observation date.
- End date (`end_date`, date): Last observation date.
- Frequency (`frequency`, text): Observation frequency. One of: `Daily`, `Weekly`, `Monthly`, `Quarterly`, `Annual`.
- Properties (`properties`, object): Additional dataset-specific properties from your Capital IQ data dictionary.

**Outputs**: Value.

- `data` (object): Capital IQ responses, one entry per query.
- `has_more` (true/false): Whether another page is available.
- `next_cursor` (text): Continuation value, or empty at the end.

**Example output**

```json
{
  "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 (`identifier`, text, required): Capital IQ entity or security identifier, such as IBM:NYSE.
- Mnemonic (`mnemonic`, text, required): Data mnemonic licensed for your account. Grouped queries require a group mnemonic.
- Period type (`period_type`, text): Financial period, including offsets, such as IQ_FY or IQ_FY-1.
- As of date (`as_of_date`, date): Point-in-time date.
- Start date (`start_date`, date): First observation date.
- End date (`end_date`, date): Last observation date.
- Frequency (`frequency`, text): Observation frequency. One of: `Daily`, `Weekly`, `Monthly`, `Quarterly`, `Annual`.
- Properties (`properties`, object): Additional dataset-specific properties from your Capital IQ data dictionary.

**Outputs**: Value.

- `data` (object): Capital IQ responses, one entry per query.
- `has_more` (true/false): Whether another page is available.
- `next_cursor` (text): Continuation value, or empty at the end.

**Example output**

```json
{
  "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 (`identifier`, text, required): Capital IQ entity or security identifier, such as IBM:NYSE.
- Mnemonic (`mnemonic`, text, required): Data mnemonic licensed for your account. Grouped queries require a group mnemonic.
- Period type (`period_type`, text): Financial period, including offsets, such as IQ_FY or IQ_FY-1.
- As of date (`as_of_date`, date): Point-in-time date.
- Start date (`start_date`, date): First observation date.
- End date (`end_date`, date): Last observation date.
- Frequency (`frequency`, text): Observation frequency. One of: `Daily`, `Weekly`, `Monthly`, `Quarterly`, `Annual`.
- Properties (`properties`, object): Additional dataset-specific properties from your Capital IQ data dictionary.

**Outputs**: Value.

- `data` (object): Capital IQ responses, one entry per query.
- `has_more` (true/false): Whether another page is available.
- `next_cursor` (text): Continuation value, or empty at the end.

**Example output**

```json
{
  "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 (`identifier`, text, required): Capital IQ entity or security identifier, such as IBM:NYSE.
- Mnemonic (`mnemonic`, text, required): Data mnemonic licensed for your account. Grouped queries require a group mnemonic.
- Period type (`period_type`, text): Financial period, including offsets, such as IQ_FY or IQ_FY-1.
- As of date (`as_of_date`, date): Point-in-time date.
- Start date (`start_date`, date): First observation date.
- End date (`end_date`, date): Last observation date.
- Frequency (`frequency`, text): Observation frequency. One of: `Daily`, `Weekly`, `Monthly`, `Quarterly`, `Annual`.
- Properties (`properties`, object): Additional dataset-specific properties from your Capital IQ data dictionary.

**Outputs**: Value.

- `data` (object): Capital IQ responses, one entry per query.
- `has_more` (true/false): Whether another page is available.
- `next_cursor` (text): Continuation value, or empty at the end.

**Example output**

```json
{
  "data": {
    "GDSSDKResponse": [
      {
        "ErrMsg": "example",
        "Headers": [
          "example"
        ],
        "Identifier": "example",
        "Mnemonic": "example",
        "NumRows": 1,
        "Rows": [
          {}
        ]
      }
    ]
  },
  "has_more": false,
  "next_cursor": null
}
```
