Please help with API data formatting

Question

Hi Family,

I am facing a tricky issue with formatting the API Data

1. The data is not being correctly formatted.

This is how I am getting the data now.

data_parameters_asset_iddata_parameters_asset_keydata_parameters_columns_0data_parameters_columns_1data_parameters_enddata_parameters_formatdata_parameters_intervaldata_parameters_orderdata_parameters_startdata_parameters_timestamp_formatdata_schema_descriptiondata_schema_first_availabledata_schema_last_availabledata_schema_metric_iddata_schema_minimum_intervaldata_schema_source_attribution_0_namedata_schema_source_attribution_0_urldata_schema_source_attribution_1_namedata_schema_source_attribution_1_urldata_schema_source_attribution_2_namedata_schema_source_attribution_2_urldata_schema_source_attribution_3_namedata_schema_source_attribution_3_urldata_schema_values_schema_circulating_marketcapdata_schema_values_schema_timestampstatus_elapsedstatus_timestampJSON_NameJSON_ValueString51f8ea5e-f426-4f40-939a-db7e05495374usdttimestampcirculating_marketcap2020-05-01T00:00:00Zjson1dascending2019-01-01T00:00:00Zunix-millisecondsThe circulating marketcap is the price of the asset multiplied by the circulating supply. If no price is found for an asset because no trades occurred, the last price of the last trade is used. After 30 days with no trades, a marketcap of 0 is reported until trading resumes.2015-02-17T00:00:00Zmcap.circ1dMessarihttps://messari.ioKaikohttps://www.kaiko.com/Coinmetrics Community Datahttps://coinmetrics.io/community-network-data/Public BigQueryhttps://console.cloud.google.com/bigquery?p=bigquery-public-data&d=crypto_ethereum&page=datasetThe circulating marketcap in US dollars.Time in milliseconds since the epoch (1 January 1970 00:00:00 UTC)102020-05-28T01:07:04.084044342Z

I want the data to be:

status__elapsedstatus__timestampdata__parameters__asset_keydata__parameters__asset_iddata__parameters__startdata__parameters__enddata__parameters__intervaldata__parameters__orderdata__parameters__formatdata__parameters__timestamp_formatdata__parameters__columnsdata__schema__metric_iddata__schema__descriptiondata__schema__values_schema__timestampdata__schema__values_schema__circulating_marketcapdata__schema__minimum_intervaldata__schema__first_availabledata__schema__last_availabledata__schema__source_attribution__namedata__schema__source_attribution__urldata__values__001data__values__00282020-05-27T23:34:52.018414694Zusdt51f8ea5e-f426-4f40-939a-db7e054953742019-01-01T00:00:00Z2020-05-01T00:00:00Z1dascendingjsonunix-millisecondstimestampmcap.circThe circulating marketcap is the price of the asset multiplied by the circulating supply. If no price is found for an asset because no trades occurred, the last price of the last trade is used. After 30 days with no trades, a marketcap of 0 is reported until trading resumes.Time in milliseconds since the epoch (1 January 1970 00:00:00 UTC)The circulating marketcap in US dollars.1d2015-02-17T00:00:00ZnullMessarihttps://messari.io1.5463E+122620842097          circulating_marketcap     Kaikohttps://www.kaiko.com/1.54639E+122651080714                  Coinmetrics Community Datahttps://coinmetrics.io/community-network-data/1.54647E+122651794623                  Public BigQueryhttps://console.cloud.google.com/bigquery?p=bigquery-public-data&d=crypto_ethereum&page=dataset1.54656E+122656980637

How can I rearrange this?

2. If I have more than 1 linksto run into the API, I want them to be correctly identified e.g. This data is for USD or DAI:  "data__parameters__asset_key" column

How do I do it?

Thanks,

Harshad

From API.yxzp

seinchyiwoo · Accepted Answer

Hi,

Trying to wrap my head around your expected results and I'm guessing the URLs are the unique results that you have queried and data values are the values attributed to them?

Ultimately you will have to deal with them separately and piece them back at the end.

I created a quick example based on my assumption and here you go the workflow:

Is this close to what you have in mind?

Cheers,

Seinchyi

HBarge · Accepted Answer

Thanks all,

You were close to what I was looking for however, it was not the complete result.

I have gone beyond what we were looking for hence, please excuse if the solution is an out-of-bounds one.

Thanks,

Harshad