OLE DB or ODBC error: [Expression.Error] We cannot convert the value to type table

[Anonymous]

We are trying to convert JSON string to columns and everyting is text in it but still gives this error and not sure for which record it fails and why. Please let us know how to debug and fix this issue to import data.

OLE DB or ODBC error: [Expression.Error] We cannot convert the value "[{"name": "TDEP", "d..." to type Table..

let
Source = Odbc.Query("dsn=MongoDb Demo", "SELECT filename,full_path,file_extension,file_size,Wellname,BUID,UWI,checksum,#(lf)LOGCurves,LOGWellHeader FROM filecollection WHERE LOGCurves is not null #(lf)AND LOGWellHeader is not null AND location='Well_Data_GOM';"),
#"Parsed JSON" = Table.TransformColumns(Source,{{"LOGCurves", Json.Document}}),
#"Expanded LOGCurves" = Table.ExpandListColumn(#"Parsed JSON", "LOGCurves"),
#"Expanded LOGCurves1" = Table.ExpandRecordColumn(#"Expanded LOGCurves", "LOGCurves", {"description", "family", "main_family", "name", "unit"}, {"description", "family", "main_family", "name", "unit"}),
#"Parsed JSON1" = Table.TransformColumns(#"Expanded LOGCurves1",{{"LOGWellHeader", Json.Document}}),
#"Expanded LOGWellHeader" = Table.ExpandRecordColumn(#"Parsed JSON1", "LOGWellHeader", {"API", "COMPANY", "INDEX_TYPE", "STOP", "STRT", "UWI", "WELL"}, {"API", "COMPANY", "INDEX_TYPE", "STOP", "STRT", "UWI.1", "WELL"})
in
#"Expanded LOGWellHeader"

Error Message : 

DataMashup.Trace Error: 24579 : {"Start":"2020-06-17T04:20:03.2999807Z","Action":"TracingRowset/IRowset.GetNextRows","Exception":"Exception:\r\nExceptionType: Microsoft.Mashup.Engine1.Runtime.ValueException, Microsoft.MashupEngine, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35\r\nMessage: [Expression.Error] We cannot convert the value \"[{\"name\": \"TDEP\", \"d...\" to type Table.\r\nStackTrace:\n at Microsoft.Mashup.Host.ProviderShared.MashupFileHost.TranslatePageException(ISerializedException error)\r\n at Microsoft.Mashup.OleDbProvider.DataHost.NonBufferingMashupEvaluator.MashupEvaluation.ExceptionResolverPageReader.Read(IPage page)\r\n at Microsoft.Mashup.Common.IPageReaderExtensions.NotifyingPageReader.Read(IPage page)\r\n at Microsoft.Mashup.Engine.Interface.Tracing.TracingPageReader.Read(IPage page)\r\n at Microsoft.Mashup.Common.IPageReaderExtensions.NotifyingPageReader.Read(IPage page)\r\n at Microsoft.OleDb.Serialization.PageReaderRowset.Microsoft.OleDb.IRowset.GetNextRows(HCHAPTER hchapter, DBROWOFFSET lRowsOffset, DBROWCOUNT cRows, DBCOUNTITEM& countRowsObtained, HROW** pRows)\r\n at Microsoft.OleDb.Rowset.Microsoft.OleDb.IRowset.GetNextRows(HCHAPTER hReserved, DBROWOFFSET lRowsOffset, DBROWCOUNT cRows, DBCOUNTITEM& countRowsObtained, HROW** pRows)\r\n at Microsoft.Mashup.OleDbProvider.TracingRowset.Microsoft.OleDb.IRowset.GetNextRows(HCHAPTER hReserved, DBROWOFFSET lRowsOffset, DBROWCOUNT cRows, DBCOUNTITEM& countRowsObtained, HROW** pRows)\r\n\r\n\r\n","ProductVersion":"2.79.5768.1082 (20.03)","ActivityId":"00000000-0000-0000-0000-000000000000","Process":"msmdsrv","Pid":29084,"Tid":22,"Duration":"00:00:00.0002118"}

[v-alq-msft]

Hi, @Anonymous 

Based on your dsecription, I created data to reproduce your scenario. The pbix file is attached in the end.

Here is the codes in 'Advanced Editor'.

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMlTSUaqOUfJLzE2NUbKKUXKMUdIBkukgnqFBrVKsTrSSEZoaJ2Q1hhA1xmhqnJHVGAHVxAIA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Key = _t, JsonResult = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Key", Int64.Type}, {"JsonResult", type text}}),
    #"Added Custom" = Table.AddColumn(#"Changed Type", "New", each Json.Document([JsonResult])),
    #"Expanded New" = Table.ExpandRecordColumn(#"Added Custom", "New", {"Name", "Age"}, {"New.Name", "New.Age"})
in
    #"Expanded New"

Result:

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

we tried to replace the source in the code provided but still getting an error, it reads around 300 records give the below error 

Query used:

let

Source = Odbc.Query("dsn=MongoDb Demo", "SELECT filename,full_path,file_extension,file_size,Wellname,BUID,UWI,checksum,#(lf)LOGCurves,LOGWellHeader FROM filecollection WHERE LOGCurves is not null #(lf)AND LOGWellHeader is not null AND location='Well_Data_GOM';" ),

Source1 = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText(Source, BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [filename = _t,LOGCurves = _t]),

#"Parsed JSON" = Table.TransformColumns(Source1,{{"LOGCurves", Json.Document}}),

#"Expanded LOGCurves" = Table.ExpandListColumn(#"Parsed JSON", "LOGCurves"),

#"Expanded LOGCurves1" = Table.ExpandRecordColumn(#"Expanded LOGCurves", "LOGCurves", {"description", "family", "main_family", "name", "unit"}, {"description", "family", "main_family", "name", "unit"})

in

#"Expanded LOGCurves1"

Error Message:

Expression.Error: We cannot convert a value of type Table to type Text.

Details:

    Value=[Table]

    Type=[Type]

[FarhanAhmed]

Can you please make sure that you are passing valid JSON ?

Can you please share the sample JSON?

[Anonymous]

the JSON is valid, it imports around 30000 to 40000 rows and then give this error. we have around 100K plus JSON records to import and not sure for which record its failing and why its failing.

here is the sample for one record and like this we have 1000K plus json , it has description, family, main_family, name and unit columns. 

[{"description": "1 Depth Index", "family": "", "main_family": "", "name": "DEPT", "unit": "F"}, {"description": "2 (RT) (DNMWORKFLOW) (6IN) TRUE VERTICAL DEPTH (Input; WR160_YETI_LWD_6315-26716_DEPTH LAS_RM.las-TVD,6315.0 to 26715.0 WR160_YETI_LWD_6315-26716_DEPTH _RM-comp.las-TVD,58", "family": "", "main_family": "", "name": "TVD", "unit": "FT"}, {"description": "3 (RT) (DRILLING_SURFACE) (6IN) RATE OF PENETRATION (Input; WR160_YETI_LWD_6315-26716_DEPTH LAS_RM.las-ROP,6315.0 to 26715.0 )", "family": "", "main_family": "", "name": "ROP", "unit": "FT/H"}, {"description": "4 (RT) (DRILLING_SURFACE) (6IN) RATE OF PENETRATION AVERAGED OVER THE LAST 5 FT (1.5 M) (Input; WR160_YETI_LWD_6315-26716_DEPTH LAS_RM.las-ROP5,6315.0 to 26715.0 )", "family": "", "main_family": "", "name": "ROP5", "unit": "FT/H"}, {"description": "5 (RM) (ARC[1]) (6IN) CALIBRATED GAMMA RAY (Input; WR160_YETI_LWD_6315-26716_DEPTH LAS_RM.las-GR_ARC_FILT,6315.0 to 26715.0 )", "family": "", "main_family": "", "name": "GR_ARC_FILT", "unit": "GAPI"}, {"description": "6 (RM) (ARC[1]) (6IN) BLENDED ATTENUATION RESISTIVITY 16 INCH (Input; WR160_YETI_LWD_6315-26716_DEPTH LAS_RM.las-A16B,6315.0 to 26715.0 )", "family": "", "main_family": "", "name": "A16B", "unit": "OHM.M"}, {"description": "7 (RM) (ARC[1]) (6IN) BLENDED ATTENUATION RESISTIVITY 22 INCH (Input; WR160_YETI_LWD_6315-26716_DEPTH LAS_RM.las-A22B,6315.0 to 26715.0 )", "family": "", "main_family": "", "name": "A22B", "unit": "OHM.M"}, {"description": "8 (RM) (ARC[1]) (6IN) BLENDED ATTENUATION RESISTIVITY 28 INCH (Input; WR160_YETI_LWD_6315-26716_DEPTH LAS_RM.las-A28B,6315.0 to 26715.0 )", "family": "", "main_family": "", "name": "A28B", "unit": "OHM.M"}, {"description": "9 (RM) (ARC[1]) (6IN) BLENDED ATTENUATION RESISTIVITY 34 INCH (Input; WR160_YETI_LWD_6315-26716_DEPTH LAS_RM.las-A34B,6315.0 to 26715.0 )", "family": "", "main_family": "", "name": "A34B", "unit": "OHM.M"}, {"description": "10 (RM) (ARC[1]) (6IN) BLENDED ATTENUATION RESISTIVITY 40 INCH (Input; WR160_YETI_LWD_6315-26716_DEPTH LAS_RM.las-A40B,6315.0 to 26715.0 )", "family": "", "main_family": "", "name": "A40B", "unit": "OHM.M"}, {"description": "11 (RM) (ARC[1]) (6IN) BLENDED PHASE SHIFT RESISTIVITY 16 INCH (Input; WR160_YETI_LWD_6315-26716_DEPTH LAS_RM.las-P16B,6315.0 to 26715.0 )", "family": "", "main_family": "", "name": "P16B", "unit": "OHM.M"}, {"description": "12 (RM) (ARC[1]) (6IN) BLENDED PHASE SHIFT RESISTIVITY 22 INCH (Input; WR160_YETI_LWD_6315-26716_DEPTH LAS_RM.las-P22B,6315.0 to 26715.0 )", "family": "", "main_family": "", "name": "P22B", "unit": "OHM.M"}, {"description": "13 (RM) (ARC[1]) (6IN) BLENDED PHASE SHIFT RESISTIVITY 28 INCH (Input; WR160_YETI_LWD_6315-26716_DEPTH LAS_RM.las-P28B,6315.0 to 26715.0 )", "family": "", "main_family": "", "name": "P28B", "unit": "OHM.M"}, {"description": "14 (RM) (ARC[1]) (6IN) BLENDED PHASE SHIFT RESISTIVITY 34 INCH (Input; WR160_YETI_LWD_6315-26716_DEPTH LAS_RM.las-P34B,6315.0 to 26715.0 )", "family": "", "main_family": "", "name": "P34B", "unit": "OHM.M"}, {"description": "15 (RM) (ARC[1]) (6IN) BLENDED PHASE SHIFT RESISTIVITY 40 INCH (Input; WR160_YETI_LWD_6315-26716_DEPTH LAS_RM.las-P40B,6315.0 to 26715.0 )", "family": "", "main_family": "", "name": "P40B", "unit": "OHM.M"}, {"description": "16 (RM) (ARC[1]) (6IN) ATTENUATION RESISTIVITY 16 INCH SPACING AT 2 MHZ, ENVIRONMENTALLY CORRECTED (Input; WR160_YETI_LWD_6315-26716_DEPTH LAS_RM.las-A16H,6315.0 to 26", "family": "", "main_family": "", "name": "A16H", "unit": "OHM.M"}, {"description": "17 (RM) (ARC[1]) (6IN) ATTENUATION RESISTIVITY 22 INCH SPACING AT 2 MHZ, ENVIRONMENTALLY CORRECTED (Input; WR160_YETI_LWD_6315-26716_DEPTH LAS_RM.las-A22H,6315.0 to 26", "family": "", "main_family": "", "name": "A22H", "unit": "OHM.M"}, {"description": "18 (RM) (ARC[1]) (6IN) ATTENUATION RESISTIVITY 28 INCH SPACING AT 2 MHZ, ENVIRONMENTALLY CORRECTED (Input; WR160_YETI_LWD_6315-26716_DEPTH LAS_RM.las-A28H,6315.0 to 26", "family": "", "main_family": "", "name": "A28H", "unit": "OHM.M"}, {"description": "19 (RM) (ARC[1]) (6IN) ATTENUATION RESISTIVITY 34 INCH SPACING AT 2 MHZ, ENVIRONMENTALLY CORRECTED (Input; WR160_YETI_LWD_6315-26716_DEPTH LAS_RM.las-A34H,6315.0 to 26", "family": "", "main_family": "", "name": "A34H", "unit": "OHM.M"}, {"description": "20 (RM) (ARC[1]) (6IN) ATTENUATION RESISTIVITY 40 INCH SPACING AT 2 MHZ, ENVIRONMENTALLY CORRECTED. (Input; WR160_YETI_LWD_6315-26716_DEPTH LAS_RM.las-A40H,6315.0 to 2", "family": "", "main_family": "", "name": "A40H", "unit": "OHM.M"}, {"description": "21 (RM) (ARC[1]) (6IN) PHASE SHIFT RESISTIVITY 16 INCH SPACING AT 2 MHZ, ENVIRONMENTALLY CORRECTED. (Input; WR160_YETI_LWD_6315-26716_DEPTH LAS_RM.las-P16H,6315.0 to 2", "family": "", "main_family": "", "name": "P16H", "unit": "OHM.M"}, {"description": "22 (RM) (ARC[1]) (6IN) PHASE SHIFT RESISTIVITY 22 INCH SPACING AT 2 MHZ, ENVIRONMENTALLY CORRECTED. (Input; WR160_YETI_LWD_6315-26716_DEPTH LAS_RM.las-P22H,6315.0 to 2", "family": "", "main_family": "", "name": "P22H", "unit": "OHM.M"}, {"description": "23 (RM) (ARC[1]) (6IN) PHASE SHIFT RESISTIVITY 28 INCH SPACING AT 2 MHZ, ENVIRONMENTALLY CORRECTED. (Input; WR160_YETI_LWD_6315-26716_DEPTH LAS_RM.las-P28H,6315.0 to 2", "family": "", "main_family": "", "name": "P28H", "unit": "OHM.M"}, {"description": "24 (RM) (ARC[1]) (6IN) PHASE SHIFT RESISTIVITY 34 INCH SPACING AT 2 MHZ, ENVIRONMENTALLY CORRECTED. (Input; WR160_YETI_LWD_6315-26716_DEPTH LAS_RM.las-P34H,6315.0 to 2", "family": "", "main_family": "", "name": "P34H", "unit": "OHM.M"}, {"description": "25 (RM) (ARC[1]) (6IN) PHASE SHIFT RESISTIVITY 40 INCH SPACING AT 2 MHZ, ENVIRONMENTALLY CORRECTED. (Input; WR160_YETI_LWD_6315-26716_DEPTH LAS_RM.las-P40H,6315.0 to 2", "family": "", "main_family": "", "name": "P40H", "unit": "OHM.M"}, {"description": "26 (RM) (ARC[1]) (6IN) ATTENUATION RESISTIVITY 16 INCH SPACING AT 400 KHZ, ENVIRONMENTALLY CORRECTED (Input; WR160_YETI_LWD_6315-26716_DEPTH LAS_RM.las-A16L,6315.0 to", "family": "", "main_family": "", "name": "A16L", "unit": "OHM.M"}, {"description": "27 (RM) (ARC[1]) (6IN) ATTENUATION RESISTIVITY 22 INCH SPACING AT 400 KHZ, ENVIRONMENTALLY CORRECTED (Input; WR160_YETI_LWD_6315-26716_DEPTH LAS_RM.las-A22L,6315.0 to", "family": "", "main_family": "", "name": "A22L", "unit": "OHM.M"}, {"description": "28 (RM) (ARC[1]) (6IN) ATTENUATION RESISTIVITY 28 INCH SPACING AT 400 KHZ, ENVIRONMENTALLY CORRECTED (Input; WR160_YETI_LWD_6315-26716_DEPTH LAS_RM.las-A28L,6315.0 to", "family": "", "main_family": "", "name": "A28L", "unit": "OHM.M"}, {"description": "29 (RM) (ARC[1]) (6IN) ATTENUATION RESISTIVITY 34 INCH SPACING AT 400 KHZ, ENVIRONMENTALLY CORRECTED (Input; WR160_YETI_LWD_6315-26716_DEPTH LAS_RM.las-A34L,6315.0 to", "family": "", "main_family": "", "name": "A34L", "unit": "OHM.M"}, {"description": "30 (RM) (ARC[1]) (6IN) ATTENUATION RESISTIVITY 40 INCH SPACING AT 400 KHZ, ENVIRONMENTALLY CORRECTED (Input; WR160_YETI_LWD_6315-26716_DEPTH LAS_RM.las-A40L,6315.0 to", "family": "", "main_family": "", "name": "A40L", "unit": "OHM.M"}, {"description": "31 (RM) (ARC[1]) (6IN) PHASE SHIFT RESISTIVITY 16 INCH SPACING AT 400 KHZ, ENVIRONMENTALLY CORRECTED. (Input; WR160_YETI_LWD_6315-26716_DEPTH LAS_RM.las-P16L,6315.0 to", "family": "", "main_family": "", "name": "P16L", "unit": "OHM.M"}, {"description": "32 (RM) (ARC[1]) (6IN) PHASE SHIFT RESISTIVITY 22 INCH SPACING AT 400 KHZ, ENVIRONMENTALLY CORRECTED. (Input; WR160_YETI_LWD_6315-26716_DEPTH LAS_RM.las-P22L,6315.0 to", "family": "", "main_family": "", "name": "P22L", "unit": "OHM.M"}, {"description": "33 (RM) (ARC[1]) (6IN) PHASE SHIFT RESISTIVITY 28 INCH SPACING AT 400 KHZ, ENVIRONMENTALLY CORRECTED. (Input; WR160_YETI_LWD_6315-26716_DEPTH LAS_RM.las-P28L,6315.0 to", "family": "", "main_family": "", "name": "P28L", "unit": "OHM.M"}, {"description": "34 (RM) (ARC[1]) (6IN) PHASE SHIFT RESISTIVITY 34 INCH SPACING AT 400 KHZ, ENVIRONMENTALLY CORRECTED. (Input; WR160_YETI_LWD_6315-26716_DEPTH LAS_RM.las-P34L,6315.0 to", "family": "", "main_family": "", "name": "P34L", "unit": "OHM.M"}, {"description": "35 (RM) (ARC[1]) (6IN) PHASE SHIFT RESISTIVITY 40 INCH SPACING AT 400 KHZ, ENVIRONMENTALLY CORRECTED. (Input; WR160_YETI_LWD_6315-26716_DEPTH LAS_RM.las-P40L,6315.0 to", "family": "", "main_family": "", "name": "P40L", "unit": "OHM.M"}, {"description": "36 (RM) (ARC[1]) (6IN) ATTENUATION CONDUCTIVITY 40 INCH SPACING AT 400 KHZ (Input; WR160_YETI_LWD_6315-26716_DEPTH LAS_RM.las-A40L_COND,6315.0 to 26715.0 )", "family": "", "main_family": "", "name": "A40L_COND", "unit": "MS/M"}, {"description": "37 (ARC[1]) (6IN) GAMMA RAY TIME AFTER BIT (Input; WR160_YETI_LWD_6315-26716_DEPTH LAS_RM.las-TAB_GR,6315.0 to 26715.0 )", "family": "", "main_family": "", "name": "TAB_GR", "unit": "H"}, {"description": "38 (ARC[1]) (6IN) RESISTIVITY TIME AFTER BIT (Input; WR160_YETI_LWD_6315-26716_DEPTH LAS_RM.las-ARTM,6315.0 to 26715.0 )", "family": "", "main_family": "", "name": "ARTM", "unit": "H"}, {"description": "39 (RM) (ARC[1]) (6IN) DOWNHOLE ANNULUS PRESSURE (Input; WR160_YETI_LWD_6315-26716_DEPTH LAS_RM.las-APRS,6315.0 to 26715.0 )", "family": "", "main_family": "", "name": "APRS", "unit": "PSI"}, {"description": "40 (RM) (ARC[1]) (6IN) DOWNHOLE ANNULUS TEMPERATURE (Input; WR160_YETI_LWD_6315-26716_DEPTH LAS_RM.las-ATMP,6315.0 to 26715.0 )", "family": "", "main_family": "", "name": "ATMP", "unit": "DEGF"}, {"description": "41 (RM) (ARC[1]) (6IN) EQUIVALENT CIRCULATING DENSITY (Input; WR160_YETI_LWD_6315-26716_DEPTH LAS_RM.las-ECD,6315.0 to 26715.0 )", "family": "", "main_family": "", "name": "ECD", "unit": "LBM/GAL"}, {"description": "42 (RM) (ADN[1]) (6IN) BULK DENSITY CORRECTION, BOTTOM (Input; WR160_YETI_LWD_6315-26716_DEPTH LAS_RM.las-DRHB,6315.0 to 26715.0 )", "family": "", "main_family": "", "name": "DRHB", "unit": "G/CM3"}, {"description": "43 (RM) (ADN[1]) (6IN) THERMAL NEUTRON POROSITY (RATIO METHOD) IN SELECTED LITHOLOGY (Input; WR160_YETI_LWD_6315-26716_DEPTH LAS_RM.las-TNPH,6315.0 to 26715.0 )", "family": "", "main_family": "", "name": "TNPH", "unit": "PU"}, {"description": "44 (RM) (ADN[1]) (6IN) DENSITY CALIPER, AVERAGE (Input; WR160_YETI_LWD_6315-26716_DEPTH LAS_RM.las-DCAV,6315.0 to 26715.0 )", "family": "", "main_family": "", "name": "DCAV", "unit": "IN"}, {"description": "45 (RM) (ADN[1]) (6IN) IMAGE DERIVED DENSITY CORRECTION (Input; WR160_YETI_LWD_6315-26716_DEPTH LAS_RM.las-IDDR,6315.0 to 26715.0 )", "family": "", "main_family": "", "name": "IDDR", "unit": "G/CM3"}, {"description": "46 (RM) (ADN[1]) (6IN) IMAGE DERIVED DENSITY (Input; WR160_YETI_LWD_6315-26716_DEPTH LAS_RM.las-IDRO,6315.0 to 26715.0 )", "family": "", "main_family": "", "name": "IDRO", "unit": "G/CM3"}, {"description": "47 (RM) (TELESCOPE[1]) (6IN) COLLAR ROTATIONAL SPEED (Input; WR160_YETI_LWD_6315-26716_DEPTH LAS_RM.las-CRPM,6315.0 to 26715.0 )", "family": "", "main_family": "", "name": "CRPM", "unit": "C/MIN"}, {"description": "48 (RM) (ADN[1]) (6IN) BULK DENSITY, BOTTOM (Input; WR160_YETI_LWD_6315-26716_DEPTH LAS_RM.las-ROBB,6315.0 to 26715.0 )", "family": "", "main_family": "", "name": "ROBB", "unit": "G/CM3"}, {"description": "49 (RM) (SONICSCOPE[1]) (6IN) DELTA-T COMPRESSIONAL (Input; WR160_YETI_LWD_6315-26716_DEPTH LAS_RM.las-DTCO,6315.0 to 26715.0 )", "family": "", "main_family": "", "name": "DTCO", "unit": "US/FT"}, {"description": "50 (RM) (SONICSCOPE[1]) (6IN) DELTA-T SHEAR (Input; WR160_YETI_LWD_6315-26716_DEPTH LAS_RM.las-DTSM,6315.0 to 26715.0 )", "family": "", "main_family": "", "name": "DTSM", "unit": "US/FT"}, {"description": "51 (ADN[1]) (6IN) DENSITY TIME AFTER BIT (Input; WR160_YETI_LWD_6315-26716_DEPTH LAS_RM.las-TAB_DEN,6315.0 to 26715.0 )", "family": "", "main_family": "", "name": "TAB_DEN", "unit": "H"}, {"description": "52 (ADN[1]) (6IN) NEUTRON TIME AFTER BIT (Input; WR160_YETI_LWD_6315-26716_DEPTH LAS_RM.las-TAB_NEU,6315.0 to 26715.0 )", "family": "", "main_family": "", "name": "TAB_NEU", "unit": "H"}, {"description": "53 (RM) (ADN[1]) (6IN) PHOTOELECTRIC FACTOR, BOTTOM (Input; WR160_YETI_LWD_6315-26716_DEPTH LAS_RM.las-PEB,6315.0 to 26715.0 )", "family": "", "main_family": "", "name": "PEB", "unit": ""}, {"description": "54 (RM) (ADN[1]) (6IN) PHOTOELECTRIC FACTOR (Input; WR160_YETI_LWD_6315-26716_DEPTH LAS_RM.las-PEF,6315.0 to 26715.0 )", "family": "", "main_family": "", "name": "PEF", "unit": ""}, {"description": "55 (RT) (DRILLING_SURFACE) (6IN) ROTATIONAL SPEED (INPUT; WR160_YETI_DRILLING_MECHANICS_RUN01_RM.LAS-RPM,5883.0 TO 9519.5 WR160_YETI_DRILLING_MECHANICS_RUN02_RM.LAS-RPM,9519.5 T", "family": "", "main_family": "", "name": "RPM", "unit": "C/MIN"}, {"description": "56 (RT) (BOREHOLE) (6IN) MEASURED DENSITY OF MUD GOING INTO HOLE (INPUT; WR160_YETI_DRILLING_MECHANICS_RUN01_RM.LAS-MWTI,5883.0 TO 9519.5 WR160_YETI_DRILLING_MECHANICS_R", "family": "", "main_family": "", "name": "MWTI", "unit": "LBM/GAL"}, {"description": "57 ADN ROTATIONAL SPEED {F13.4} (INPUT; WR160_YETI_LWD_6315-26716_DEPTH _RM_REV2.LAS-RPM_ADN,6315.0 TO 26715.5 ) (Input; WR160_YETI_LWD_6315-26716_DEPTH _RM-comp.las-RPM_ADN,5883.0 to 26715.5 )", "family": "", "main_family": "", "name": "RPM_ADN", "unit": "RPM"}]