GET Fetch Datasheet in CSV Format

Description

Using this API you can fetch all datapoints for a specific datasheet.


Request Format

GET https://app.daloopa.com/api/v1/export/{ticker}

Path Parameters

ItemData TypeDescription
tickerstringThe ticker symbol of the company.

Query Parameters

ItemData TypeDescription
real_timeboolIt can be True or False. If True, then it will return data that is incrementally updated and not yet available in the datasheet.

Example Request

curl --location 'https://app.daloopa.com/api/v1/export/AAPL?real_time=false' \
--header 'Authorization: Basic bWFy9NO284bXM5N2c=' \

Response

Status : 200

Output: Text - it is formatted as CSV so you can save response as CSV file

Response Schema

ItemData TypeDescription
calendar_periodstringCalendar period of datapoint in format of 2021Q2 or FY2020
categorystringSection under which the datapoint is grouped in model (e.g., Income Statement, Guidance)
company_namestringName of company
filing_datedateDate of filing from which datapoint is sourced
filing_typestringType of filing from which datapoint is sourced (e.g., 8-K, 10-Q)
fiscal_periodstringFiscal period of datapoint in format of 2021Q2 or FY2020
idintegerID of datapoint in Daloopa database
labelstringDescription of datapoint
restatedbooleanTrue or False
series_idintegerID of associated series in Daloopa database
series_id_relations-Relation to series ID (currently not used)
series_tag-Series tag in Daloopa database (currently not used)
source_linkstringLink to datapoint in source document
spanstringQuarterly or annual
tickerstringAssociated ticker
unitstringUnit of datapoint (billion, million, dollar, percent)
value_normalizedfloatNormalized value (e.g. converts annual to quarterly)
value_rawfloatRaw value
titlestringFull relationship of a datapoint withing Daloopa datasheet (e.g. KPIs | Customer Development | Internet users | Number of Internet user | Technology companies)