Data Factory: API data to Azure Table storage

[@temjim]

This is a perfect example. Thank you!

[@javibi]

Thank you to you

[@rockonyo100]

Thanks a lot. Easy to understand explanation.

[@javibi]

Thanks!

[@lucasjao91]

Thank you, Javi! Great work! Nice English!

[@javibi]

Thanks!

[@Nura853]

Very useful, thank you!

[@javibi]

Thanks!

[@aarontian5979]

Very useful, big thanks!

[@javibi]

Thank you!

[@reecenickol1241]

Excellent

[@javibi]

Thanks!

[@krishj8011]

Nice tutorial, well explained... thanks.

[@javibi]

Thanks!!

[@SaryChamsF]

Thanks, it helped me a lot!

[@javibi]

Thanks!

[@AMagicViewer]

👍

[@javibi]

Thanks!

[@tanmaykanse9351]

In Mapping Section, I don't have an option to tick mark data--->array(collection reference).
that's y i can load only first row... not the entire data.

[@javibi]

Hi Tammy, maybe data factory is not properly reading the mapping. Happens sometimes when arrays are present. Also Copy Activities are probably not the best method for arrays, there are some limitations.

[@VunnamNagaraju]

Thanks for uploading great video. I would like to know if we can do incremental read based on some date filter condition from Rest API source.

[@javibi]

Table storage accepts adding new data and doing updates based on a key field, but if you need to check the max date of your table storage, I don't think that's possible. You will need to get this date from somewhere else to be able to implement this kind of process.

[@osky7542]

Buen dia, te quiero hacer una consulta, ya que estoy trabajando con "Table Storage" y no encuentro la forma para que cada vez que se procese la información, primero trunque o borre todos los registros de la table Storage. Muchas gracias, muy bueno el video!

[@javibi]

Hi! I don't think that's possible.
If you need that, I would try a delete task prior to the copy activity, then it will recreate the table storage. Take care because the deletes on table storage are not instant and that could make your copy activity to fail. Probably you will also need to use a wait activity or another kind of process.

[@rum81]

Thank you can you also cover pagination
And writing to multiple tables from json

[@javibi]

Hi I take notes of your suggestion!

[@liliabarraza4881]

Hi, how would it be with a token authentication ?

[@javibi]

Hi, in case your API needs a token, you will need to all a Web activity before to get it, and then build the call to the API using the token as a parameter

[@tutourioste]

Excelente contenido, creo que deberias hacer enfasis en mejorar el ingles o hacerlo en español ya que tienes un publico expectante de este tipo de material

[@javibi]

Thanks!