# API and queries mess

**URL:** <https://community.influxdata.com/t/api-and-queries-mess/14481>\
**Category:** InfluxDB 2\
**Tags:** query, influxdb-cloud-2-0\
**Created:** [May 23, 2020, 11:01am UTC](https://community.influxdata.com/t/api-and-queries-mess/14481 "2020-05-23T11:01:55Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Goldi\_rana](https://sea1.discourse-cdn.com/flex023/user_avatar/community.influxdata.com/goldi_rana/32/4996_2.png) [@Goldi\_rana](https://community.influxdata.com/u/Goldi_rana)\
**Post date:** [May 23, 2020, 11:01am UTC](https://community.influxdata.com/t/api-and-queries-mess/14481/1 "2020-05-23T11:01:55Z")

</div>

Hi, I used influxdb to store my data and i am using python with influxdb-client library to work out but to make a query like **show databases** it’s just simply don’t work. I am confused here is python only takes flux query or queries like sql can also be written in.  
**result = query\_api.query(“SELECT \* FROM measurement”**)

Here, I am trying to get the last updated record from the measurement. as per time new columns (segments) are adding so can’t specify the column name(segment) to get the last updated record.