LIVE Vs EXTRACT on connection Detremination

[rsareen23]

We are trying to determine the Connection type - LIVE vs EXTRACT on the connection in the workbook?.We are currently connecting to Database. However server.workbooks.populate_connections(getworkbook) and connection_type is giving the Database type, also embed is returning true for both extract and LIVE connection . So, how can we make this determination?. Could you please help?.

[jorwoods]

You can use the metadata API and GraphQL to find out if the workbook has extracts.

query extracts{
  workbooks(filter:{name:"Superstore"}){
    luid
    embeddedDatasources{
      name
      id
      hasExtracts
    }
  }
}

[rsareen23]

Thank you @jorwoods , I'll update my code. Thank you once again