Power Query – API – Record vs Text

Bonsoir, il me semble avoir réussi à faire ce que vous vouliez avec la version 2013 d’excel. Le fichier est en PJ.

Dans les étapes appliquées,
Etape 1
J’ai sélectionné la colonne/transformer/vers la table (avec aucun délimiteur)
Etape 2
J’ai développé.

Au niveau de l’éditeur avancé, ça donne ça:

let
Source = Json.Document(Web.Contents(“https://api.coingecko.com/api/v3/coins/markets?vs_currency=usd&order=market_cap_desc%2Cvolume_desc&per_page=250&page=1&sparkline=false&price_change_percentage=1h%2C24h%2C7d”)),
#”Converti en table” = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
#”Column1 développé” = Table.ExpandRecordColumn(#”Converti en table”, “Column1”, {“id”, “symbol”, “name”, “image”, “current_price”, “market_cap”, “market_cap_rank”, “fully_diluted_valuation”, “total_volume”, “high_24h”, “low_24h”, “price_change_24h”, “price_change_percentage_24h”, “market_cap_change_24h”, “market_cap_change_percentage_24h”, “circulating_supply”, “total_supply”, “max_supply”, “ath”, “ath_change_percentage”, “ath_date”, “atl”, “atl_change_percentage”, “atl_date”, “roi”, “last_updated”, “price_change_percentage_1h_in_currency”, “price_change_percentage_24h_in_currency”, “price_change_percentage_7d_in_currency”}, {“Column1.id”, “Column1.symbol”, “Column1.name”, “Column1.image”, “Column1.current_price”, “Column1.market_cap”, “Column1.market_cap_rank”, “Column1.fully_diluted_valuation”, “Column1.total_volume”, “Column1.high_24h”, “Column1.low_24h”, “Column1.price_change_24h”, “Column1.price_change_percentage_24h”, “Column1.market_cap_change_24h”, “Column1.market_cap_change_percentage_24h”, “Column1.circulating_supply”, “Column1.total_supply”, “Column1.max_supply”, “Column1.ath”, “Column1.ath_change_percentage”, “Column1.ath_date”, “Column1.atl”, “Column1.atl_change_percentage”, “Column1.atl_date”, “Column1.roi”, “Column1.last_updated”, “Column1.price_change_percentage_1h_in_currency”, “Column1.price_change_percentage_24h_in_currency”, “Column1.price_change_percentage_7d_in_currency”})
in
#”Column1 développé”

Bonne soirée, en France, il est tard…

Cordialement

Nicolas