Forum Discussion

jdchipps's avatar
jdchipps
Frequent Visitor
5 years ago

Looping API Call, restringir los resultados

Hola

Tengo la siguiente llamada a la API en bucle en el escritorio de PowerBI, ¿hay algo que pueda agregar/ cambiar para que se escriban en bucle para decir solo los primeros 1000 registros (10 páginas) en lugar de devolver todos los registros?

Dejar
ufnQuery (n) ?>
Dejar
jsonDoc Json.Document(
Web.Contents(
"[reemplazar esto con la dirección web]/?&start-" & Number.ToText(n))),
resultado: jsonDoc[result],
registros - resultado[registros],
tmpTbl á Table.FromList(records, Splitter.SplitByNothing(), null, null, ExtraValues.Error)
En
tmpTbl,

fnRecursivo (tbl, n) ->
if Table.RowCount(ufnQuery(n)) > 0 a continuación, @fnRecursive(Table.Combine('tbl,'ufnQuery(n)'), n+100) else tbl,

tbl - ufnQuery(0),
final- fnRecursive(tbl ,100),
"Columna expandida1" - Table.ExpandRecordColumn(final, "Column1", "id", "start", "answer", "end", "src", "dst", "from_number", "to_number", "from_name", "to_name", "billsec", "disposition", "lastapp", "userfield", "faxdata", "lastdata", "cost", "organization", "channel", "dstchannel", "app", "callclass", "dest_type", "duration", "dcontext", "dcontext", "type", "timezone", "id", "start", "answer", "end", "src", "dst", "from_number", "to_number", "from_name", "to_name", "billsec", "disposition", "lastapp", "userfield", "faxdata", "lastdata", "cost", "organization", "channel", "dstchannel", "app", "callclass", "dest_type", "duration", "dcontext", "pbxid", "type", "timezone"-)
En
"Columna expandida1"