{"id":"chatcmpl-Bx3YQ5MuGecfv0R1GG5cs8UdKqm95","object":"chat.completion","created":1753414714,"model":"gpt-4o-2024-08-06","system_fingerprint":"fp_a288987b44","choices":[{"index":0,"message":{"role":"assistant","content":"Here's a table with all the date text extracted from the lab report:\n\n```markdown\n| Date | Context |\n|------------|-------------------------------|\n| June 05, 2024 | Received |\n| June 05, 2024 to June 10, 2024 | Analysis Date |\n| June 10, 2024 | Reported |\n```"},"finish_reason":"stop"}],"usage":{"prompt_tokens":1231,"completion_tokens":77,"total_tokens":1308,"prompt_tokens_details":{"cached_tokens":1152,"audio_tokens":0},"completion_tokens_details":{"reasoning_tokens":0,"accepted_prediction_tokens":0,"rejected_prediction_tokens":0,"audio_tokens":0}}}
{"prompt":"\n I have table of dates from a lab report of a cannabis product in markdown format:\n Here's a table with all the date text extracted from the lab report:\n\n```markdown\n| Date | Context |\n|------------|-------------------------------|\n| June 05, 2024 | Received |\n| June 05, 2024 to June 10, 2024 | Analysis Date |\n| June 10, 2024 | Reported |\n``` \n\n Convert all the date values in this table to standard ISO Format (yyyy-mm-dd)\n "}
{"id":"chatcmpl-Bx3YVS7ASUhv6yLPHzSF9nezDYjHq","object":"chat.completion","created":1753414719,"model":"gpt-4o-2024-08-06","system_fingerprint":"fp_07871e2ad8","choices":[{"index":0,"message":{"role":"assistant","content":"Certainly! Here is the table with all the date values converted to ISO format:\n\n```markdown\n| Date | Context |\n|----------------------|-------------------|\n| 2024-06-05 | Received |\n| 2024-06-05 to 2024-06-10 | Analysis Date |\n| 2024-06-10 | Reported |\n```"},"finish_reason":"stop"}],"usage":{"prompt_tokens":138,"completion_tokens":82,"total_tokens":220,"prompt_tokens_details":{"cached_tokens":0,"audio_tokens":0},"completion_tokens_details":{"reasoning_tokens":0,"accepted_prediction_tokens":0,"rejected_prediction_tokens":0,"audio_tokens":0}}}
{"prompt":[{"role":"system","content":"You are a lab report analyst that can extract correct dates"},{"role":"user","content":"\n I have table of dates from a lab report of a cannabis product in markdown format:\n Certainly! Here is the table with all the date values converted to ISO format:\n\n```markdown\n| Date | Context |\n|----------------------|-------------------|\n| 2024-06-05 | Received |\n| 2024-06-05 to 2024-06-10 | Analysis Date |\n| 2024-06-10 | Reported |\n``` \n Give me the extraction date and give me the expiry date.\n \n The extraction date in the table can be similar to\n Date,Reported,Completion Date,Date Issued,Completed Date,Date Collected,Production Date,Date Completed\n \n The expiry date in the table can be similar to\n Expires,Expiry date,Expiry,Expiration Date\n "}],"jsonSchema":{"name":"extract_correct_dates","strict":false,"schema":{"type":"object","properties":{"expiryDate":{"type":"string","description":"Expiry date of the lab report."},"reportDate":{"type":"string","description":"The date the report was created or the date the sample was extracted"}},"required":[],"additionalProperties":false}}}
{"json":{"pages":[{"page":1,"md":"\nISO\/IEC 17025:2017 Accredited \nHemp Potency Analysis by High Performance Liquid Chromatography \n\n# Testing Accreditation #: 77802\n\n| Client Name, Sample Details | Test Conditions | Sample ID#: 1489119 |\n|-----------------------------|-----------------|---------------------|\n| Not Your Bakery <br> Delray Beach, FL 33445 <br> Sample: Papaya Runtz Vape <br> License: MI-HOU-02248 <br> Type: Hemp Vape Cart <br> Method: FE04U12 HPLC-UV | PrepSheet ID#: MIP240822b <br> Scale: XS205-M12 <br> Temp: 21.9 \u00b0C <br> Baro Pressure: 980.1 hPa <br> Analyst: MEH <br> Technician: ARH | Harvest\/Process Date: 08\/22\/2024 <br> Serving Size (g): 1 <br> Date Received: 08\/22\/2024 <br> Test Date: 08\/22\/2024 <br> Valid Through: 08\/23\/2025 <br> Report Issued: 08\/23\/2024 |\n\nTest Certificate #: 1489119-001\n\n| Test Compounds | \u03949-THC | THCA | \u03948-THC | CBD | CBDA | CBG | CBGA | CBN | CBC | CBL | THCV | CBDV | Total Cannabinoids* | Total THC | Total CBD | Calc Max Total Cannabinoids* |\n|----------------|--------|------|--------|-----|------|-----|------|-----|-----|-----|------|------|---------------------|-----------|----------|-----------------------------|\n| Amount (%) | 0.1 | 87.5 | 0.8 | N\/D | N\/D | N\/D | N\/D | N\/D | N\/D | N\/D | N\/D | N\/D | 88.5 | 0.9 | N\/D | 98.9 |\n| Amount (mg\/g) | 1.2 | 875 | 8.1 | N\/D | N\/D | N\/D | N\/D | N\/D | N\/D | N\/D | N\/D | N\/D | 885 | 9.0 | N\/D | 989 |\n| Amount per Serving (mg) | 1.2 | 875 | 8.1 | N\/D | N\/D | N\/D | N\/D | N\/D | N\/D | N\/D | N\/D | N\/D | 885 | 9.0 | N\/D | 989 |\n\nLOQ (mg\/g) \n0.8% 2.6% 5.2% 4.3% 1.5% 1.9% 5.2% 5.4% 6.1% 10.8% 2.7% 1.2% 6.0% 12.0%\n\n*LOQ = Limit of Quantitation; %RPD = Relative Percent Deviation; %RSD = Relative Standard Deviation; N\/D = Not Detected \n**Designates values that are not currently included in the accredited scope of Iron Laboratories \nFE-4 Designates test used to include FE-4.5.5 as performed using AOAC 968.07 and 32.004-32.009 \nFE-4.5 has relative expanded (k=2) uncertainty of \u00b110% for moisture, \u00b11.4% for water activity for unprocessed plant materials, and 13.10% for water activity for infused products. \nVitamin E acetate analysis has a relative expanded (k=2) uncertainty of \u00b18.0%. \nTotal THC and CBD is calculated using the formula: THC = 0.877 to the THCA or CBDA value. \nThese values are calculated by applying a molar correction factor of 0.877 to the THCA or CBDA value. \nCalc Max Total Cannabinoids is the sum of Total THC, Total CBD, CBN, Total CBG, CBC, THCV, CBDV, and CBL. \nTotal CBG is calculated as CBGA plus CBG*0.878 (the molar correction factor for CBGA to CBG conversion). \n%Decarb. THC and CBD refer to the percentage of \u03949-THC or CBD relative to THCA or CBDA, respectively.\n\nThis sample has undergone random sampling and has been tested for compliant state, batch representative testing.\n\nResults apply to the sample as received.\n\nThis certificate shall not be reproduced except in full, without written approval of Iron Laboratories, LLC.\n\n----\n\nAmanda Heidler \nAmanda Heidler, Lab Manager\n\nMac Hyman \nMacKenzie L. Hyman, Quality Manager\n\nIron Laboratories, LLC is an ISO\/IEC 17025:2017 Testing Laboratory laboratory accredited by (PJLA) PerryJohnson Laboratory Accreditation, Certificate No. 77802\n\nTested by Iron Laboratories Michigan, 1825 E. West Maple Walled Lake, MI 48390\n\nPage 1 of 2\n\n","images":[{"name":"page_1.jpg","height":0,"width":0,"x":0,"y":0,"type":"full_page_screenshot"}],"charts":[],"items":[{"type":"text","value":"ISO\/IEC 17025:2017 Accredited \nHemp Potency Analysis by High Performance Liquid Chromatography","md":"ISO\/IEC 17025:2017 Accredited \nHemp Potency Analysis by High Performance Liquid Chromatography"},{"type":"heading","lvl":1,"value":"Testing Accreditation : 77802","md":"# Testing Accreditation #: 77802"},{"type":"table","rows":[["Client Name, Sample Details","Test Conditions","Sample ID#: 1489119"],["Not Your Bakery <br> Delray Beach, FL 33445 <br> Sample: Papaya Runtz Vape <br> License: MI-HOU-02248 <br> Type: Hemp Vape Cart <br> Method: FE04U12 HPLC-UV","PrepSheet ID#: MIP240822b <br> Scale: XS205-M12 <br> Temp: 21.9 \u00b0C <br> Baro Pressure: 980.1 hPa <br> Analyst: MEH <br> Technician: ARH","Harvest\/Process Date: 08\/22\/2024 <br> Serving Size (g): 1 <br> Date Received: 08\/22\/2024 <br> Test Date: 08\/22\/2024 <br> Valid Through: 08\/23\/2025 <br> Report Issued: 08\/23\/2024"]],"md":"| Client Name, Sample Details | Test Conditions | Sample ID#: 1489119 |\n| ------------------------------------------------------------------------------------------------------------------------------------------------------------ | --------------------------------------------------------------------------------------------------------------------------------------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |\n| Not Your Bakery <br> Delray Beach, FL 33445 <br> Sample: Papaya Runtz Vape <br> License: MI-HOU-02248 <br> Type: Hemp Vape Cart <br> Method: FE04U12 HPLC-UV | PrepSheet ID#: MIP240822b <br> Scale: XS205-M12 <br> Temp: 21.9 \u00b0C <br> Baro Pressure: 980.1 hPa <br> Analyst: MEH <br> Technician: ARH | Harvest\/Process Date: 08\/22\/2024 <br> Serving Size (g): 1 <br> Date Received: 08\/22\/2024 <br> Test Date: 08\/22\/2024 <br> Valid Through: 08\/23\/2025 <br> Report Issued: 08\/23\/2024 |","isPerfectTable":false,"csv":"\"Client Name, Sample Details\",\"Test Conditions\",\"Sample ID#: 1489119\"\n\"Not Your Bakery <br> Delray Beach, FL 33445 <br> Sample: Papaya Runtz Vape <br> License: MI-HOU-02248 <br> Type: Hemp Vape Cart <br> Method: FE04U12 HPLC-UV\",\"PrepSheet ID#: MIP240822b <br> Scale: XS205-M12 <br> Temp: 21.9 \u00b0C <br> Baro Pressure: 980.1 hPa <br> Analyst: MEH <br> Technician: ARH\",\"Harvest\/Process Date: 08\/22\/2024 <br> Serving Size (g): 1 <br> Date Received: 08\/22\/2024 <br> Test Date: 08\/22\/2024 <br> Valid Through: 08\/23\/2025 <br> Report Issued: 08\/23\/2024\""},{"type":"text","value":"Test Certificate #: 1489119-001","md":"Test Certificate #: 1489119-001"},{"type":"table","rows":[["Test Compounds","\u03949-THC","THCA","\u03948-THC","CBD","CBDA","CBG","CBGA","CBN","CBC","CBL","THCV","CBDV","Total Cannabinoids*","Total THC","Total CBD","Calc Max Total Cannabinoids*"],["Amount (%)","0.1","87.5","0.8","N\/D","N\/D","N\/D","N\/D","N\/D","N\/D","N\/D","N\/D","N\/D","88.5","0.9","N\/D","98.9"],["Amount (mg\/g)","1.2","875","8.1","N\/D","N\/D","N\/D","N\/D","N\/D","N\/D","N\/D","N\/D","N\/D","885","9.0","N\/D","989"],["Amount per Serving (mg)","1.2","875","8.1","N\/D","N\/D","N\/D","N\/D","N\/D","N\/D","N\/D","N\/D","N\/D","885","9.0","N\/D","989"]],"md":"| Test Compounds | \u03949-THC | THCA | \u03948-THC | CBD | CBDA | CBG | CBGA | CBN | CBC | CBL | THCV | CBDV | Total Cannabinoids\\* | Total THC | Total CBD | Calc Max Total Cannabinoids\\* |\n| ----------------------- | ------ | ---- | ------ | --- | ---- | --- | ---- | --- | --- | --- | ---- | ---- | -------------------- | --------- | --------- | ----------------------------- |\n| Amount (%) | 0.1 | 87.5 | 0.8 | N\/D | N\/D | N\/D | N\/D | N\/D | N\/D | N\/D | N\/D | N\/D | 88.5 | 0.9 | N\/D | 98.9 |\n| Amount (mg\/g) | 1.2 | 875 | 8.1 | N\/D | N\/D | N\/D | N\/D | N\/D | N\/D | N\/D | N\/D | N\/D | 885 | 9.0 | N\/D | 989 |\n| Amount per Serving (mg) | 1.2 | 875 | 8.1 | N\/D | N\/D | N\/D | N\/D | N\/D | N\/D | N\/D | N\/D | N\/D | 885 | 9.0 | N\/D | 989 |","isPerfectTable":false,"csv":"\"Test Compounds\",\"\u03949-THC\",\"THCA\",\"\u03948-THC\",\"CBD\",\"CBDA\",\"CBG\",\"CBGA\",\"CBN\",\"CBC\",\"CBL\",\"THCV\",\"CBDV\",\"Total Cannabinoids*\",\"Total THC\",\"Total CBD\",\"Calc Max Total Cannabinoids*\"\n\"Amount (%)\",\"0.1\",\"87.5\",\"0.8\",\"N\/D\",\"N\/D\",\"N\/D\",\"N\/D\",\"N\/D\",\"N\/D\",\"N\/D\",\"N\/D\",\"N\/D\",\"88.5\",\"0.9\",\"N\/D\",\"98.9\"\n\"Amount (mg\/g)\",\"1.2\",\"875\",\"8.1\",\"N\/D\",\"N\/D\",\"N\/D\",\"N\/D\",\"N\/D\",\"N\/D\",\"N\/D\",\"N\/D\",\"N\/D\",\"885\",\"9.0\",\"N\/D\",\"989\"\n\"Amount per Serving (mg)\",\"1.2\",\"875\",\"8.1\",\"N\/D\",\"N\/D\",\"N\/D\",\"N\/D\",\"N\/D\",\"N\/D\",\"N\/D\",\"N\/D\",\"N\/D\",\"885\",\"9.0\",\"N\/D\",\"989\""},{"type":"text","value":"LOQ (mg\/g) \n0.8% 2.6% 5.2% 4.3% 1.5% 1.9% 5.2% 5.4% 6.1% 10.8% 2.7% 1.2% 6.0% 12.0%\n\n*LOQ = Limit of Quantitation; %RPD = Relative Percent Deviation; %RSD = Relative Standard Deviation; N\/D = Not Detected \n**Designates values that are not currently included in the accredited scope of Iron Laboratories \nFE-4 Designates test used to include FE-4.5.5 as performed using AOAC 968.07 and 32.004-32.009 \nFE-4.5 has relative expanded (k=2) uncertainty of \u00b110% for moisture, \u00b11.4% for water activity for unprocessed plant materials, and 13.10% for water activity for infused products. \nVitamin E acetate analysis has a relative expanded (k=2) uncertainty of \u00b18.0%. \nTotal THC and CBD is calculated using the formula: THC = 0.877 to the THCA or CBDA value. \nThese values are calculated by applying a molar correction factor of 0.877 to the THCA or CBDA value. \nCalc Max Total Cannabinoids is the sum of Total THC, Total CBD, CBN, Total CBG, CBC, THCV, CBDV, and CBL. \nTotal CBG is calculated as CBGA plus CBG*0.878 (the molar correction factor for CBGA to CBG conversion). \n%Decarb. THC and CBD refer to the percentage of \u03949-THC or CBD relative to THCA or CBDA, respectively.\n\nThis sample has undergone random sampling and has been tested for compliant state, batch representative testing.\n\nResults apply to the sample as received.\n\nThis certificate shall not be reproduced except in full, without written approval of Iron Laboratories, LLC.\n\n----\n\nAmanda Heidler \nAmanda Heidler, Lab Manager\n\nMac Hyman \nMacKenzie L. Hyman, Quality Manager\n\nIron Laboratories, LLC is an ISO\/IEC 17025:2017 Testing Laboratory laboratory accredited by (PJLA) PerryJohnson Laboratory Accreditation, Certificate No. 77802\n\nTested by Iron Laboratories Michigan, 1825 E. West Maple Walled Lake, MI 48390\n\nPage 1 of 2","md":"LOQ (mg\/g) \n0.8% 2.6% 5.2% 4.3% 1.5% 1.9% 5.2% 5.4% 6.1% 10.8% 2.7% 1.2% 6.0% 12.0%\n\n*LOQ = Limit of Quantitation; %RPD = Relative Percent Deviation; %RSD = Relative Standard Deviation; N\/D = Not Detected \n**Designates values that are not currently included in the accredited scope of Iron Laboratories \nFE-4 Designates test used to include FE-4.5.5 as performed using AOAC 968.07 and 32.004-32.009 \nFE-4.5 has relative expanded (k=2) uncertainty of \u00b110% for moisture, \u00b11.4% for water activity for unprocessed plant materials, and 13.10% for water activity for infused products. \nVitamin E acetate analysis has a relative expanded (k=2) uncertainty of \u00b18.0%. \nTotal THC and CBD is calculated using the formula: THC = 0.877 to the THCA or CBDA value. \nThese values are calculated by applying a molar correction factor of 0.877 to the THCA or CBDA value. \nCalc Max Total Cannabinoids is the sum of Total THC, Total CBD, CBN, Total CBG, CBC, THCV, CBDV, and CBL. \nTotal CBG is calculated as CBGA plus CBG*0.878 (the molar correction factor for CBGA to CBG conversion). \n%Decarb. THC and CBD refer to the percentage of \u03949-THC or CBD relative to THCA or CBDA, respectively.\n\nThis sample has undergone random sampling and has been tested for compliant state, batch representative testing.\n\nResults apply to the sample as received.\n\nThis certificate shall not be reproduced except in full, without written approval of Iron Laboratories, LLC.\n\n----\n\nAmanda Heidler \nAmanda Heidler, Lab Manager\n\nMac Hyman \nMacKenzie L. Hyman, Quality Manager\n\nIron Laboratories, LLC is an ISO\/IEC 17025:2017 Testing Laboratory laboratory accredited by (PJLA) PerryJohnson Laboratory Accreditation, Certificate No. 77802\n\nTested by Iron Laboratories Michigan, 1825 E. West Maple Walled Lake, MI 48390\n\nPage 1 of 2"}],"status":"OK","originalOrientationAngle":0,"links":[],"triggeredAutoMode":false,"parsingMode":"multimodal-openai-gpt4o","structuredData":null,"noStructuredContent":false,"noTextContent":false,"pageHeaderMarkdown":"\nISO\/IEC 17025:2017 Accredited \nHemp Potency Analysis by High Performance Liquid Chromatography \n","pageFooterMarkdown":"\n"}],"job_metadata":{"credits_used":0,"job_credits_usage":0,"job_pages":1,"job_auto_mode_triggered_pages":0,"job_is_cache_hit":false}},"markdown":"\nISO\/IEC 17025:2017 Accredited \nHemp Potency Analysis by High Performance Liquid Chromatography \n\n# Testing Accreditation #: 77802\n\n| Client Name, Sample Details | Test Conditions | Sample ID#: 1489119 |\n|-----------------------------|-----------------|---------------------|\n| Not Your Bakery <br> Delray Beach, FL 33445 <br> Sample: Papaya Runtz Vape <br> License: MI-HOU-02248 <br> Type: Hemp Vape Cart <br> Method: FE04U12 HPLC-UV | PrepSheet ID#: MIP240822b <br> Scale: XS205-M12 <br> Temp: 21.9 \u00b0C <br> Baro Pressure: 980.1 hPa <br> Analyst: MEH <br> Technician: ARH | Harvest\/Process Date: 08\/22\/2024 <br> Serving Size (g): 1 <br> Date Received: 08\/22\/2024 <br> Test Date: 08\/22\/2024 <br> Valid Through: 08\/23\/2025 <br> Report Issued: 08\/23\/2024 |\n\nTest Certificate #: 1489119-001\n\n| Test Compounds | \u03949-THC | THCA | \u03948-THC | CBD | CBDA | CBG | CBGA | CBN | CBC | CBL | THCV | CBDV | Total Cannabinoids* | Total THC | Total CBD | Calc Max Total Cannabinoids* |\n|----------------|--------|------|--------|-----|------|-----|------|-----|-----|-----|------|------|---------------------|-----------|----------|-----------------------------|\n| Amount (%) | 0.1 | 87.5 | 0.8 | N\/D | N\/D | N\/D | N\/D | N\/D | N\/D | N\/D | N\/D | N\/D | 88.5 | 0.9 | N\/D | 98.9 |\n| Amount (mg\/g) | 1.2 | 875 | 8.1 | N\/D | N\/D | N\/D | N\/D | N\/D | N\/D | N\/D | N\/D | N\/D | 885 | 9.0 | N\/D | 989 |\n| Amount per Serving (mg) | 1.2 | 875 | 8.1 | N\/D | N\/D | N\/D | N\/D | N\/D | N\/D | N\/D | N\/D | N\/D | 885 | 9.0 | N\/D | 989 |\n\nLOQ (mg\/g) \n0.8% 2.6% 5.2% 4.3% 1.5% 1.9% 5.2% 5.4% 6.1% 10.8% 2.7% 1.2% 6.0% 12.0%\n\n*LOQ = Limit of Quantitation; %RPD = Relative Percent Deviation; %RSD = Relative Standard Deviation; N\/D = Not Detected \n**Designates values that are not currently included in the accredited scope of Iron Laboratories \nFE-4 Designates test used to include FE-4.5.5 as performed using AOAC 968.07 and 32.004-32.009 \nFE-4.5 has relative expanded (k=2) uncertainty of \u00b110% for moisture, \u00b11.4% for water activity for unprocessed plant materials, and 13.10% for water activity for infused products. \nVitamin E acetate analysis has a relative expanded (k=2) uncertainty of \u00b18.0%. \nTotal THC and CBD is calculated using the formula: THC = 0.877 to the THCA or CBDA value. \nThese values are calculated by applying a molar correction factor of 0.877 to the THCA or CBDA value. \nCalc Max Total Cannabinoids is the sum of Total THC, Total CBD, CBN, Total CBG, CBC, THCV, CBDV, and CBL. \nTotal CBG is calculated as CBGA plus CBG*0.878 (the molar correction factor for CBGA to CBG conversion). \n%Decarb. THC and CBD refer to the percentage of \u03949-THC or CBD relative to THCA or CBDA, respectively.\n\nThis sample has undergone random sampling and has been tested for compliant state, batch representative testing.\n\nResults apply to the sample as received.\n\nThis certificate shall not be reproduced except in full, without written approval of Iron Laboratories, LLC.\n\n----\n\nAmanda Heidler \nAmanda Heidler, Lab Manager\n\nMac Hyman \nMacKenzie L. Hyman, Quality Manager\n\nIron Laboratories, LLC is an ISO\/IEC 17025:2017 Testing Laboratory laboratory accredited by (PJLA) PerryJohnson Laboratory Accreditation, Certificate No. 77802\n\nTested by Iron Laboratories Michigan, 1825 E. West Maple Walled Lake, MI 48390\n\nPage 1 of 2\n\n","jobDetails":{"webhook_configurations":null,"job_name":"parse_raw_file_job","partitions":{"file_parsing_id_partition":"95dae49a-5144-4119-9818-a5feaea1dab3"},"parameters":{"priority":null,"custom_metadata":null,"resource_info":null,"languages":["en"],"parsing_instruction":"","disable_ocr":false,"annotate_links":false,"adaptive_long_table":false,"compact_markdown_table":false,"disable_reconstruction":false,"disable_image_extraction":false,"invalidate_cache":false,"outlined_table_extraction":false,"merge_tables_across_pages_in_markdown":false,"output_pdf_of_document":false,"do_not_cache":false,"fast_mode":false,"skip_diagonal_text":false,"preserve_layout_alignment_across_pages":false,"preserve_very_small_text":false,"gpt4o_mode":false,"do_not_unroll_columns":false,"extract_layout":false,"high_res_ocr":false,"html_make_all_elements_visible":false,"html_remove_navigation_elements":false,"html_remove_fixed_elements":false,"guess_xlsx_sheet_name":false,"page_separator":null,"bounding_box":"","bbox_top":null,"bbox_right":null,"bbox_bottom":null,"bbox_left":null,"target_pages":"","use_vendor_multimodal_model":true,"vendor_multimodal_model_name":"openai-gpt4o","model":"","page_prefix":"","page_suffix":"","webhook_url":"","preset":"","take_screenshot":false,"is_formatting_instruction":true,"premium_mode":false,"continuous_mode":false,"input_s3_path":"s3:\/\/llama-platform-file-parsing\/fb_iKieaLfVCeTaHV3IzxdANsa7NAD2\/95dae49a-5144-4119-9818-a5feaea1dab3\/input.png","input_s3_region":"us-east-1","output_s3_path_prefix":"s3:\/\/llama-platform-file-parsing\/fb_iKieaLfVCeTaHV3IzxdANsa7NAD2\/95dae49a-5144-4119-9818-a5feaea1dab3","output_s3_region":"us-east-1","project_id":"983c7754-5052-4149-b409-986d83545a50","azure_openai_deployment_name":null,"azure_openai_endpoint":null,"azure_openai_api_version":null,"input_url":null,"http_proxy":null,"auto_mode":false,"auto_mode_trigger_on_regexp_in_page":null,"auto_mode_trigger_on_text_in_page":null,"auto_mode_trigger_on_table_in_page":false,"auto_mode_trigger_on_image_in_page":false,"auto_mode_configuration_json":null,"structured_output":false,"structured_output_json_schema":null,"structured_output_json_schema_name":null,"max_pages":null,"max_pages_enforced":0,"extract_charts":false,"formatting_instruction":null,"complemental_formatting_instruction":null,"content_guideline_instruction":null,"spreadsheet_extract_sub_tables":true,"job_timeout_in_seconds":null,"job_timeout_extra_time_per_page_in_seconds":null,"strict_mode_image_extraction":false,"strict_mode_image_ocr":false,"strict_mode_reconstruction":false,"strict_mode_buggy_font":false,"save_images":true,"hide_headers":false,"hide_footers":false,"page_header_prefix":null,"page_header_suffix":null,"page_footer_prefix":null,"page_footer_suffix":null,"ignore_document_elements_for_layout_detection":false,"output_tables_as_HTML":false,"internal_is_screenshot_job":false,"parse_mode":null,"system_prompt":"","system_prompt_append":"","user_prompt":"","page_error_tolerance":0.05,"replace_failed_page_mode":null,"replace_failed_page_with_error_message_prefix":"","replace_failed_page_with_error_message_suffix":"","markdown_table_multiline_header_separator":null,"type":"parse","file_name":"LabReportImage.png","original_file_name":"LabReportImage.png","file_key":"s3:\/\/llama-platform-file-parsing\/fb_iKieaLfVCeTaHV3IzxdANsa7NAD2\/95dae49a-5144-4119-9818-a5feaea1dab3\/input.png","lang":"en","outputBucket":null,"file_id":null,"pipeline_id":null},"session_id":null,"correlation_id":null,"parent_job_execution_id":null,"user_id":"fb:iKieaLfVCeTaHV3IzxdANsa7NAD2","created_at":"2025-07-25T03:38:31.543000Z","project_id":"983c7754-5052-4149-b409-986d83545a50","id":"fff63d89-8f27-413b-965b-d4e15ee6c3ed","status":"SUCCESS","error_code":null,"error_message":null,"attempts":1,"started_at":"2025-07-25T03:38:31.597000Z","ended_at":"2025-07-25T03:39:52.857000Z","updated_at":"2025-07-25T03:39:52.869000Z","jobInfo":{"status":"success","info":"multimodal","model":"openai-gpt4o","pages":1,"options":{"adaptiveLongTable":false,"annotateLinks":null,"autoMode":false,"autoModeConfigurationJson":null,"autoModeTriggerOnImageInPage":false,"autoModeTriggerOnRegexpInPage":null,"autoModeTriggerOnTableInPage":false,"autoModeTriggerOnTextInPage":null,"azureOpenAiApiVersion":null,"azureOpenAiDeploymentName":null,"azureOpenAiEndpoint":null,"azureOpenAiKey":null,"bboxBottom":null,"bboxLeft":null,"bboxRight":null,"bboxTop":null,"boundingBox":null,"compactMarkdownTable":false,"complementalFormattingInstruction":null,"contentGuidelineInstruction":null,"disableImageExtraction":false,"disableOcr":false,"doNotCache":false,"doNotUnrollColumns":false,"extractCharts":false,"extractLayout":false,"fileId":null,"fileName":"LabReportImage.png","formattingInstruction":null,"guessXLSXSheetName":false,"hideFooters":false,"hideHeaders":false,"highResOcr":false,"htmlMakeAllElementsVisible":false,"htmlRemoveFixedElements":false,"htmlRemoveNavigationElements":false,"httpProxy":null,"ignoreDocumentElementsForLayoutDetection":false,"inputS3Path":"s3:\/\/llama-platform-file-parsing\/fb_iKieaLfVCeTaHV3IzxdANsa7NAD2\/95dae49a-5144-4119-9818-a5feaea1dab3\/input.png","inputS3Region":"us-east-1","inputUrl":null,"invalidateCache":false,"isFormattingInstruction":true,"isOurOwnS3Bucket":true,"jobTimeoutExtraTimePerPageInSeconds":2,"jobTimeoutInSeconds":null,"language":"en","logFiles":false,"markdownTableMultilineHeaderSeparator":"<br\/>","maxPages":701,"mergeTablesAcrossPagesInMarkdown":false,"model":"openai-gpt4o","multimodalPipeline":true,"outlinedTableExtraction":false,"outputPDFOfDocument":false,"outputS3PathPrefix":"s3:\/\/llama-platform-file-parsing\/fb_iKieaLfVCeTaHV3IzxdANsa7NAD2\/95dae49a-5144-4119-9818-a5feaea1dab3","outputS3Region":"us-east-1","outputTablesAsHTML":false,"pageErrorTolerance":0.05,"pageFooterPrefix":null,"pageFooterSuffix":null,"pageHeaderPrefix":null,"pageHeaderSuffix":null,"pagePrefix":null,"pageSeparator":"\n---\n","pageSuffix":null,"parseMode":"parse_page_with_lvm","preserveLayoutAlignmentAcrossPages":false,"preserveVerySmallText":false,"replaceFailedPageMode":"raw_text","replaceFailedPageWithErrorMessagePrefix":null,"replaceFailedPageWithErrorMessageSuffix":null,"saveImages":true,"skipDiagonalText":false,"spreadSheetExtractSubTables":true,"strictModeBuggyFont":false,"strictModeImageExtraction":false,"strictModeImageOCR":false,"strictModeReconstruction":false,"structuredOutput":false,"structuredOutputJSONSchema":null,"structuredOutputJSONSchemaName":null,"structuredOutputSchema":null,"takeScreenshot":false,"targetPages":null,"template":null,"vendorAPIKey":"[User provided key]","webhookUrl":null,"job_record_id":"fff63d89-8f27-413b-965b-d4e15ee6c3ed","jobOutOfQueueTimestamp":1753414711616,"jobCreatedAtTimestamp":1753414711616,"legacy_job_name":"parse_raw_file_job","legacy_file_parsing_id_partition":"95dae49a-5144-4119-9818-a5feaea1dab3","legacy_session_id":null,"legacy_correlation_id":null,"legacy_parent_job_execution_id":null,"user_id":"fb:iKieaLfVCeTaHV3IzxdANsa7NAD2","project_id":"983c7754-5052-4149-b409-986d83545a50","created_at":"2025-07-25T03:38:31.543000Z","temporal_run_id":null,"temporal_workflow_id":null,"documentAborter":[]},"metadata":{"pdf-pages":1,"pdf-real-pages":1,"pdf-mdLength":3427,"pdf-multimodal-time":78570,"pdf-multimodal-pdf2Image":296,"pdf-inputTokens":1133,"pdf-outputTokens":1105,"pdf-model":"openai-gpt4o"},"images":["page_1.jpg"],"charts":[]}}}
{"prompt":[{"role":"user","content":"\n This is a markdown for a cannabis product lab report:\n ---START MARKDOWN HERE---\n \"\\nISO\\\/IEC 17025:2017 Accredited \\nHemp Potency Analysis by High Performance Liquid Chromatography \\n\\n# Testing Accreditation #: 77802\\n\\n| Client Name, Sample Details | Test Conditions | Sample ID#: 1489119 |\\n|-----------------------------|-----------------|---------------------|\\n| Not Your Bakery <br> Delray Beach, FL 33445 <br> Sample: Papaya Runtz Vape <br> License: MI-HOU-02248 <br> Type: Hemp Vape Cart <br> Method: FE04U12 HPLC-UV | PrepSheet ID#: MIP240822b <br> Scale: XS205-M12 <br> Temp: 21.9 \\u00b0C <br> Baro Pressure: 980.1 hPa <br> Analyst: MEH <br> Technician: ARH | Harvest\\\/Process Date: 08\\\/22\\\/2024 <br> Serving Size (g): 1 <br> Date Received: 08\\\/22\\\/2024 <br> Test Date: 08\\\/22\\\/2024 <br> Valid Through: 08\\\/23\\\/2025 <br> Report Issued: 08\\\/23\\\/2024 |\\n\\nTest Certificate #: 1489119-001\\n\\n| Test Compounds | \\u03949-THC | THCA | \\u03948-THC | CBD | CBDA | CBG | CBGA | CBN | CBC | CBL | THCV | CBDV | Total Cannabinoids* | Total THC | Total CBD | Calc Max Total Cannabinoids* |\\n|----------------|--------|------|--------|-----|------|-----|------|-----|-----|-----|------|------|---------------------|-----------|----------|-----------------------------|\\n| Amount (%) | 0.1 | 87.5 | 0.8 | N\\\/D | N\\\/D | N\\\/D | N\\\/D | N\\\/D | N\\\/D | N\\\/D | N\\\/D | N\\\/D | 88.5 | 0.9 | N\\\/D | 98.9 |\\n| Amount (mg\\\/g) | 1.2 | 875 | 8.1 | N\\\/D | N\\\/D | N\\\/D | N\\\/D | N\\\/D | N\\\/D | N\\\/D | N\\\/D | N\\\/D | 885 | 9.0 | N\\\/D | 989 |\\n| Amount per Serving (mg) | 1.2 | 875 | 8.1 | N\\\/D | N\\\/D | N\\\/D | N\\\/D | N\\\/D | N\\\/D | N\\\/D | N\\\/D | N\\\/D | 885 | 9.0 | N\\\/D | 989 |\\n\\nLOQ (mg\\\/g) \\n0.8% 2.6% 5.2% 4.3% 1.5% 1.9% 5.2% 5.4% 6.1% 10.8% 2.7% 1.2% 6.0% 12.0%\\n\\n*LOQ = Limit of Quantitation; %RPD = Relative Percent Deviation; %RSD = Relative Standard Deviation; N\\\/D = Not Detected \\n**Designates values that are not currently included in the accredited scope of Iron Laboratories \\nFE-4 Designates test used to include FE-4.5.5 as performed using AOAC 968.07 and 32.004-32.009 \\nFE-4.5 has relative expanded (k=2) uncertainty of \\u00b110% for moisture, \\u00b11.4% for water activity for unprocessed plant materials, and 13.10% for water activity for infused products. \\nVitamin E acetate analysis has a relative expanded (k=2) uncertainty of \\u00b18.0%. \\nTotal THC and CBD is calculated using the formula: THC = 0.877 to the THCA or CBDA value. \\nThese values are calculated by applying a molar correction factor of 0.877 to the THCA or CBDA value. \\nCalc Max Total Cannabinoids is the sum of Total THC, Total CBD, CBN, Total CBG, CBC, THCV, CBDV, and CBL. \\nTotal CBG is calculated as CBGA plus CBG*0.878 (the molar correction factor for CBGA to CBG conversion). \\n%Decarb. THC and CBD refer to the percentage of \\u03949-THC or CBD relative to THCA or CBDA, respectively.\\n\\nThis sample has undergone random sampling and has been tested for compliant state, batch representative testing.\\n\\nResults apply to the sample as received.\\n\\nThis certificate shall not be reproduced except in full, without written approval of Iron Laboratories, LLC.\\n\\n----\\n\\nAmanda Heidler \\nAmanda Heidler, Lab Manager\\n\\nMac Hyman \\nMacKenzie L. Hyman, Quality Manager\\n\\nIron Laboratories, LLC is an ISO\\\/IEC 17025:2017 Testing Laboratory laboratory accredited by (PJLA) PerryJohnson Laboratory Accreditation, Certificate No. 77802\\n\\nTested by Iron Laboratories Michigan, 1825 E. West Maple Walled Lake, MI 48390\\n\\nPage 1 of 2\\n\\n\"\n ---END OF MARKDOWN---\n \n Act like you are a cannabis lab analyst\n Extract the cannabis product name, product type, sample matrix\/product type and the laboratory name.\n The product type can be cannabis, kratom or mushroom\n "}],"jsonSchema":{"name":"lab_report_data","strict":false,"schema":{"type":"object","properties":{"lab_name":{"type":"string","description":"The laboratory that conducted the analysis"},"product_name":{"type":"string","description":"The name of the cannabis product"},"product_type":{"type":"string","description":"The type of the product","enum":["cannabis","kratom","mushroom"]},"sample_matrix":{"type":"string","description":"The sample matrix also known as the type of the product"}},"required":[],"additionalProperties":false}}}
{"prompt":[{"role":"user","content":"\n This is a markdown for a cannabis product lab report:\n ---START MARKDOWN HERE---\n \"\\nISO\\\/IEC 17025:2017 Accredited \\nHemp Potency Analysis by High Performance Liquid Chromatography \\n\\n# Testing Accreditation #: 77802\\n\\n| Client Name, Sample Details | Test Conditions | Sample ID#: 1489119 |\\n|-----------------------------|-----------------|---------------------|\\n| Not Your Bakery <br> Delray Beach, FL 33445 <br> Sample: Papaya Runtz Vape <br> License: MI-HOU-02248 <br> Type: Hemp Vape Cart <br> Method: FE04U12 HPLC-UV | PrepSheet ID#: MIP240822b <br> Scale: XS205-M12 <br> Temp: 21.9 \\u00b0C <br> Baro Pressure: 980.1 hPa <br> Analyst: MEH <br> Technician: ARH | Harvest\\\/Process Date: 08\\\/22\\\/2024 <br> Serving Size (g): 1 <br> Date Received: 08\\\/22\\\/2024 <br> Test Date: 08\\\/22\\\/2024 <br> Valid Through: 08\\\/23\\\/2025 <br> Report Issued: 08\\\/23\\\/2024 |\\n\\nTest Certificate #: 1489119-001\\n\\n| Test Compounds | \\u03949-THC | THCA | \\u03948-THC | CBD | CBDA | CBG | CBGA | CBN | CBC | CBL | THCV | CBDV | Total Cannabinoids* | Total THC | Total CBD | Calc Max Total Cannabinoids* |\\n|----------------|--------|------|--------|-----|------|-----|------|-----|-----|-----|------|------|---------------------|-----------|----------|-----------------------------|\\n| Amount (%) | 0.1 | 87.5 | 0.8 | N\\\/D | N\\\/D | N\\\/D | N\\\/D | N\\\/D | N\\\/D | N\\\/D | N\\\/D | N\\\/D | 88.5 | 0.9 | N\\\/D | 98.9 |\\n| Amount (mg\\\/g) | 1.2 | 875 | 8.1 | N\\\/D | N\\\/D | N\\\/D | N\\\/D | N\\\/D | N\\\/D | N\\\/D | N\\\/D | N\\\/D | 885 | 9.0 | N\\\/D | 989 |\\n| Amount per Serving (mg) | 1.2 | 875 | 8.1 | N\\\/D | N\\\/D | N\\\/D | N\\\/D | N\\\/D | N\\\/D | N\\\/D | N\\\/D | N\\\/D | 885 | 9.0 | N\\\/D | 989 |\\n\\nLOQ (mg\\\/g) \\n0.8% 2.6% 5.2% 4.3% 1.5% 1.9% 5.2% 5.4% 6.1% 10.8% 2.7% 1.2% 6.0% 12.0%\\n\\n*LOQ = Limit of Quantitation; %RPD = Relative Percent Deviation; %RSD = Relative Standard Deviation; N\\\/D = Not Detected \\n**Designates values that are not currently included in the accredited scope of Iron Laboratories \\nFE-4 Designates test used to include FE-4.5.5 as performed using AOAC 968.07 and 32.004-32.009 \\nFE-4.5 has relative expanded (k=2) uncertainty of \\u00b110% for moisture, \\u00b11.4% for water activity for unprocessed plant materials, and 13.10% for water activity for infused products. \\nVitamin E acetate analysis has a relative expanded (k=2) uncertainty of \\u00b18.0%. \\nTotal THC and CBD is calculated using the formula: THC = 0.877 to the THCA or CBDA value. \\nThese values are calculated by applying a molar correction factor of 0.877 to the THCA or CBDA value. \\nCalc Max Total Cannabinoids is the sum of Total THC, Total CBD, CBN, Total CBG, CBC, THCV, CBDV, and CBL. \\nTotal CBG is calculated as CBGA plus CBG*0.878 (the molar correction factor for CBGA to CBG conversion). \\n%Decarb. THC and CBD refer to the percentage of \\u03949-THC or CBD relative to THCA or CBDA, respectively.\\n\\nThis sample has undergone random sampling and has been tested for compliant state, batch representative testing.\\n\\nResults apply to the sample as received.\\n\\nThis certificate shall not be reproduced except in full, without written approval of Iron Laboratories, LLC.\\n\\n----\\n\\nAmanda Heidler \\nAmanda Heidler, Lab Manager\\n\\nMac Hyman \\nMacKenzie L. Hyman, Quality Manager\\n\\nIron Laboratories, LLC is an ISO\\\/IEC 17025:2017 Testing Laboratory laboratory accredited by (PJLA) PerryJohnson Laboratory Accreditation, Certificate No. 77802\\n\\nTested by Iron Laboratories Michigan, 1825 E. West Maple Walled Lake, MI 48390\\n\\nPage 1 of 2\\n\\n\"\n ---END OF MARKDOWN---\n \n Act like you are a lab analyst that can extract cannabinoids data from a lab report\n Give me the cannabinoids and potency results table. Give me the result in a markdown format\n "}]}
{"prompt":[{"role":"system","content":"You are a cannabis lab analyst"},{"role":"user","content":"\n I have the markdown of a cannabis product lab results : Certainly! Below is the extracted **Cannabinoids and Potency Results Table** from the provided lab report, formatted in **markdown** as requested:\n\n```markdown\n# Cannabinoids and Potency Results\n\n| Test Compounds | \u03949-THC | THCA | \u03948-THC | CBD | CBDA | CBG | CBGA | CBN | CBC | CBL | THCV | CBDV | Total Cannabinoids* | Total THC | Total CBD | Calc Max Total Cannabinoids* |\n|-------------------------|--------|-------|--------|-------|-------|-------|-------|-------|-------|-------|-------|-------|----------------------|-----------|----------|------------------------------|\n| **Amount (%)** | 0.1 | 87.5 | 0.8 | N\/D | N\/D | N\/D | N\/D | N\/D | N\/D | N\/D | N\/D | N\/D | 88.5 | 0.9 | N\/D | 98.9 |\n| **Amount (mg\/g)** | 1.2 | 875 | 8.1 | N\/D | N\/D | N\/D | N\/D | N\/D | N\/D | N\/D | N\/D | N\/D | 885 | 9.0 | N\/D | 989 |\n| **Amount per Serving (mg)** | 1.2 | 875 | 8.1 | N\/D | N\/D | N\/D | N\/D | N\/D | N\/D | N\/D | N\/D | N\/D | 885 | 9.0 | N\/D | 989 |\n\n*Note: \n1. **N\/D** = Not Detected \n2. *LOQ = Limit of Quantitation* \n3. Total Cannabinoids and THC\/CBD values are calculated using correction factors as described in the analysis methodology.\n```\n\nThis table includes the percentage, weight per gram in mg, and total amounts of cannabinoids per serving. Let me know if you need further assistance!.\n Give me the total thc percentage, the delta 9 percentage and the thca percentage from the given lab report.\n The results are found in the results percentage column.\n \n The different possibilities of writing delta 9 in the lab report is similar to: \n\n \u03949-THC,Delta 9-THC,D9-THC,\u03949-TETRAHYDROCANNABINOL,\u03949-TETRAHYDROCANNABINOL (D9-THC),D9-Tetrahydrocannabinol,D9-Tetrahydrocannabinol (D9-THC),\u0394-9 THC,\u0394-9-Tetrahydrocannabinol (\u0394-9 THC),Tetrahydrocannabinol (\u03949-THC),delta 9-Tetrahydrocannabinol,delta 9-Tetrahydrocannabinol (THC),d9-THC*,\u03949-Tetrahydrocannabinol (\u03949-THC);\n \n The different possibilities of writing thca in the lab report is similar to: \n\n THCA,Tetrahydrocannabinolic Acid,Tetrahydrocannabinolic Acid (THCA),\u0394-9-Tetrahydrocannabinolic Acid,THCA-A,\u0394-9-Tetrahydrocannabinolic Acid (THCA-A),\u03949-THC Acid,\u03949-THC Acid (THCA),\u03949-THCA,THCa,\u03949-TETRAHYDROCANNABINOLIC ACID,\u03949-TETRAHYDROCANNABINOLIC ACID (THCA),D9-Tetrahydrocannabinolic acid,D9-Tetrahydrocannabinolic acid (THCa),delta-9-Tetrahydrocannabinolic Acid, delta-9-Tetrahydrocannabinolic Acid(THC-A),THC-A,\u03949-Tetrahydrocannabinolic Acid (\u03949-THCA);\n "}],"jsonSchema":{"name":"lab_report_analyte_information","strict":false,"schema":{"type":"object","properties":{"totalThcPercentage":{"type":"number","description":"The total thc or total active thc percentage of the product"},"delta9Percentage":{"type":"number","description":"The delta 9 percentage \/ thc 9 percentage of the product"},"thcaPercentage":{"type":"number","description":"The thca percentage of the product"}},"required":[],"additionalProperties":false}}}
{"prompt":[{"role":"user","content":"\n This is a markdown for a cannabis product lab report:\n ---START MARKDOWN HERE---\n \"\\nISO\\\/IEC 17025:2017 Accredited \\nHemp Potency Analysis by High Performance Liquid Chromatography \\n\\n# Testing Accreditation #: 77802\\n\\n| Client Name, Sample Details | Test Conditions | Sample ID#: 1489119 |\\n|-----------------------------|-----------------|---------------------|\\n| Not Your Bakery <br> Delray Beach, FL 33445 <br> Sample: Papaya Runtz Vape <br> License: MI-HOU-02248 <br> Type: Hemp Vape Cart <br> Method: FE04U12 HPLC-UV | PrepSheet ID#: MIP240822b <br> Scale: XS205-M12 <br> Temp: 21.9 \\u00b0C <br> Baro Pressure: 980.1 hPa <br> Analyst: MEH <br> Technician: ARH | Harvest\\\/Process Date: 08\\\/22\\\/2024 <br> Serving Size (g): 1 <br> Date Received: 08\\\/22\\\/2024 <br> Test Date: 08\\\/22\\\/2024 <br> Valid Through: 08\\\/23\\\/2025 <br> Report Issued: 08\\\/23\\\/2024 |\\n\\nTest Certificate #: 1489119-001\\n\\n| Test Compounds | \\u03949-THC | THCA | \\u03948-THC | CBD | CBDA | CBG | CBGA | CBN | CBC | CBL | THCV | CBDV | Total Cannabinoids* | Total THC | Total CBD | Calc Max Total Cannabinoids* |\\n|----------------|--------|------|--------|-----|------|-----|------|-----|-----|-----|------|------|---------------------|-----------|----------|-----------------------------|\\n| Amount (%) | 0.1 | 87.5 | 0.8 | N\\\/D | N\\\/D | N\\\/D | N\\\/D | N\\\/D | N\\\/D | N\\\/D | N\\\/D | N\\\/D | 88.5 | 0.9 | N\\\/D | 98.9 |\\n| Amount (mg\\\/g) | 1.2 | 875 | 8.1 | N\\\/D | N\\\/D | N\\\/D | N\\\/D | N\\\/D | N\\\/D | N\\\/D | N\\\/D | N\\\/D | 885 | 9.0 | N\\\/D | 989 |\\n| Amount per Serving (mg) | 1.2 | 875 | 8.1 | N\\\/D | N\\\/D | N\\\/D | N\\\/D | N\\\/D | N\\\/D | N\\\/D | N\\\/D | N\\\/D | 885 | 9.0 | N\\\/D | 989 |\\n\\nLOQ (mg\\\/g) \\n0.8% 2.6% 5.2% 4.3% 1.5% 1.9% 5.2% 5.4% 6.1% 10.8% 2.7% 1.2% 6.0% 12.0%\\n\\n*LOQ = Limit of Quantitation; %RPD = Relative Percent Deviation; %RSD = Relative Standard Deviation; N\\\/D = Not Detected \\n**Designates values that are not currently included in the accredited scope of Iron Laboratories \\nFE-4 Designates test used to include FE-4.5.5 as performed using AOAC 968.07 and 32.004-32.009 \\nFE-4.5 has relative expanded (k=2) uncertainty of \\u00b110% for moisture, \\u00b11.4% for water activity for unprocessed plant materials, and 13.10% for water activity for infused products. \\nVitamin E acetate analysis has a relative expanded (k=2) uncertainty of \\u00b18.0%. \\nTotal THC and CBD is calculated using the formula: THC = 0.877 to the THCA or CBDA value. \\nThese values are calculated by applying a molar correction factor of 0.877 to the THCA or CBDA value. \\nCalc Max Total Cannabinoids is the sum of Total THC, Total CBD, CBN, Total CBG, CBC, THCV, CBDV, and CBL. \\nTotal CBG is calculated as CBGA plus CBG*0.878 (the molar correction factor for CBGA to CBG conversion). \\n%Decarb. THC and CBD refer to the percentage of \\u03949-THC or CBD relative to THCA or CBDA, respectively.\\n\\nThis sample has undergone random sampling and has been tested for compliant state, batch representative testing.\\n\\nResults apply to the sample as received.\\n\\nThis certificate shall not be reproduced except in full, without written approval of Iron Laboratories, LLC.\\n\\n----\\n\\nAmanda Heidler \\nAmanda Heidler, Lab Manager\\n\\nMac Hyman \\nMacKenzie L. Hyman, Quality Manager\\n\\nIron Laboratories, LLC is an ISO\\\/IEC 17025:2017 Testing Laboratory laboratory accredited by (PJLA) PerryJohnson Laboratory Accreditation, Certificate No. 77802\\n\\nTested by Iron Laboratories Michigan, 1825 E. West Maple Walled Lake, MI 48390\\n\\nPage 1 of 2\\n\\n\"\n ---END OF MARKDOWN---\n \n Act like you are an ai that can extract all dates from a lab report\n Give me all the date text from this report in a table markdown format and do not derive any dates\n "}]}
{"id":"chatcmpl-Bx3ZsHTIsJE5c8W3IA1AAxKHoxY9v","object":"chat.completion","created":1753414804,"model":"gpt-4o-2024-11-20","choices":[{"index":0,"message":{"role":"assistant","content":"Here is a table containing all the date text extracted directly from the lab report:\n\n| Date Text | Description |\n|---------------------|------------------------------------|\n| 08\/22\/2024 | Harvest\/Process Date |\n| 08\/22\/2024 | Date Received |\n| 08\/22\/2024 | Test Date |\n| 08\/23\/2025 | Valid Through |\n| 08\/23\/2024 | Report Issued |"},"finish_reason":"stop"}],"usage":{"prompt_tokens":1279,"completion_tokens":104,"total_tokens":1383,"prompt_tokens_details":{"cached_tokens":1152,"audio_tokens":0},"completion_tokens_details":{"reasoning_tokens":0,"accepted_prediction_tokens":0,"rejected_prediction_tokens":0,"audio_tokens":0}}}
{"prompt":"\n I have table of dates from a lab report of a cannabis product in markdown format:\n Here is a table containing all the date text extracted directly from the lab report:\n\n| Date Text | Description |\n|---------------------|------------------------------------|\n| 08\/22\/2024 | Harvest\/Process Date |\n| 08\/22\/2024 | Date Received |\n| 08\/22\/2024 | Test Date |\n| 08\/23\/2025 | Valid Through |\n| 08\/23\/2024 | Report Issued | \n\n Convert all the date values in this table to standard ISO Format (yyyy-mm-dd)\n "}
{"id":"chatcmpl-Bx3Zu22Nmjpf2prFpQxqYICso6kEB","object":"chat.completion","created":1753414806,"model":"gpt-4o-2024-11-20","choices":[{"index":0,"message":{"role":"assistant","content":"Here's your updated table with the date values converted to ISO format:\n\n| Date Text | Description |\n|---------------------|------------------------------------|\n| 2024-08-22 | Harvest\/Process Date |\n| 2024-08-22 | Date Received |\n| 2024-08-22 | Test Date |\n| 2025-08-23 | Valid Through |\n| 2024-08-23 | Report Issued |"},"finish_reason":"stop"}],"usage":{"prompt_tokens":165,"completion_tokens":101,"total_tokens":266,"prompt_tokens_details":{"cached_tokens":0,"audio_tokens":0},"completion_tokens_details":{"reasoning_tokens":0,"accepted_prediction_tokens":0,"rejected_prediction_tokens":0,"audio_tokens":0}}}
{"prompt":[{"role":"system","content":"You are a lab report analyst that can extract correct dates"},{"role":"user","content":"\n I have table of dates from a lab report of a cannabis product in markdown format:\n Here's your updated table with the date values converted to ISO format:\n\n| Date Text | Description |\n|---------------------|------------------------------------|\n| 2024-08-22 | Harvest\/Process Date |\n| 2024-08-22 | Date Received |\n| 2024-08-22 | Test Date |\n| 2025-08-23 | Valid Through |\n| 2024-08-23 | Report Issued | \n Give me the extraction date and give me the expiry date.\n \n The extraction date in the table can be similar to\n Date,Reported,Completion Date,Date Issued,Completed Date,Date Collected,Production Date,Date Completed\n \n The expiry date in the table can be similar to\n Expires,Expiry date,Expiry,Expiration Date\n "}],"jsonSchema":{"name":"extract_correct_dates","strict":false,"schema":{"type":"object","properties":{"expiryDate":{"type":"string","description":"Expiry date of the lab report."},"reportDate":{"type":"string","description":"The date the report was created or the date the sample was extracted"}},"required":[],"additionalProperties":false}}}
{"json":{"pages":[{"page":1,"md":"\nISO\/IEC 17025:2017 Accredited \nHemp Potency Analysis by High Performance Liquid Chromatography \nTest Certificate #: 148191-001\n\n# Testing Accreditation #: 77802\n\n| Client Name, Sample Details | Test Conditions | Sample ID#: 148191 |\n|-----------------------------|-----------------|--------------------|\n| Not Your Bakery | Prep\/Sheet ID#: MIP240822b | Harvest\/Process Date: 08\/22\/2024 |\n| Delray Beach, FL 33445 | Scale: XS205-M12 | Serving Size (g): 1 |\n| Sample: Papaya Runtz Vape | Temp: 21.9 \u00b0C | Date Received: 08\/22\/2024 |\n| License: MI-HOU2248 | Baro Pressure: 980.1 hPa | Test Date: 08\/22\/2024 |\n| Type: Hemp Vape Cart | Analyst: MEH | Valid Through: 08\/23\/2025 |\n| Method: FE04U12 HPLC-UV | Technician: ARH | Report Issued: 08\/23\/2024 |\n\n| Test Compounds | \u03949-THC | THCA | \u03948-THC | CBD | CBDA | CBC | CBGA | CBN | CBC | CBL | THCV | CBDV | Total Cannabinoids | Total THC | Total CBD | Calc Max Total Cannabinoids |\n|----------------|--------|------|--------|-----|------|-----|------|-----|-----|-----|------|------|--------------------|-----------|----------|-----------------------------|\n| Amount (%) | 0.1 | 87.5 | 0.8 | N\/D | N\/D | N\/D | N\/D | N\/D | N\/D | N\/D | N\/D | N\/D | 89.3 | 0.9 | N\/D | 89.3 |\n| Amount (mg\/g) | 1.2 | 875 | 8.1 | N\/D | N\/D | N\/D | N\/D | N\/D | N\/D | N\/D | N\/D | N\/D | 893 | 9.0 | N\/D | 893 |\n| Amount per Serving (mg) | 1.2 | 875 | 8.1 | N\/D | N\/D | N\/D | N\/D | N\/D | N\/D | N\/D | N\/D | N\/D | 893 | 9.0 | N\/D | 893 |\n| LOQ (mg\/g) | - | - | - | - | - | - | 2.95 | - | - | - | 2.95 | 2.95 | 2.95 | - | - | - |\n\n- LOD = Limit of Quantitation; %RPD = Relative Percent Deviation; %RSD = Relative Standard Deviation; N\/D = Not Detected\n- *Designates values that are not currently included in the accredited scope of Iron Laboratories\n- FE-45 designates tests that use the method FE-45. FE-45 is performed using AOAC 968.07 and 32.004-32.009\n- FE-45 has a relative expanded (k=2) uncertainty of \u00b110% for moisture, \u00b11.4% for water activity for unprocessed plant materials, and 13.10% for water activity for infused products. Vitamin E acetate analysis has a relative expanded (k=2) uncertainty of \u00b18.8%\n- Total THC and CBD is calculated using the formula: THC = (0.877 * THCA) + \u03949-THC. This is the amount of THC or CBD derived from THCA or CBDA, respectively.\n- These values are calculated by applying a molar correction factor of 0.877 to the THCA or the CBDA value\n- Calc Max Total Cannabinoids is the sum of Total THC, Total CBD, CBN, Total CBG, CBC, THCV, CBDV, and CBL.\n- Total CBG is calculated as CBG plus CBGA * 0.878 (the molar correction factor for CBGA to CBG conversion).\n- %Decarb. THC and CBD refer to the percentage of \u03949-THC or CBD relative to THCA or CBDA, respectively.\n\n**This sample has undergone random sampling and has been tested for compliant state, batch representative testing.**\n\nResults apply to the sample as received.\n\nThis certificate shall not be reproduced except in full, without written approval of Iron Laboratories, LLC.\n\n----\n\nAmanda Heidler \nAmanda Heidler, Lab Manager\n\nMac Hyman \nMacKenzie L. Hyman, Quality Manager\n\nIron Laboratories, LLC is an ISO\/IEC 17025:2017 Testing Laboratory laboratory accredited by (PJLA) Perry Johnson Laboratory Accreditation, Certificate No. 77802\n\nTested by Iron Laboratories Michigan, 1825 E. West Maple Walled Lake, MI 48390\n\nPage 1 of 2","images":[{"name":"page_1.jpg","height":0,"width":0,"x":0,"y":0,"type":"full_page_screenshot"}],"charts":[],"items":[{"type":"text","value":"ISO\/IEC 17025:2017 Accredited \nHemp Potency Analysis by High Performance Liquid Chromatography \nTest Certificate #: 148191-001","md":"ISO\/IEC 17025:2017 Accredited \nHemp Potency Analysis by High Performance Liquid Chromatography \nTest Certificate #: 148191-001"},{"type":"heading","lvl":1,"value":"Testing Accreditation : 77802","md":"# Testing Accreditation #: 77802"},{"type":"table","rows":[["Client Name, Sample Details","Test Conditions","Sample ID#: 148191"],["Not Your Bakery","Prep\/Sheet ID#: MIP240822b","Harvest\/Process Date: 08\/22\/2024"],["Delray Beach, FL 33445","Scale: XS205-M12","Serving Size (g): 1"],["Sample: Papaya Runtz Vape","Temp: 21.9 \u00b0C","Date Received: 08\/22\/2024"],["License: MI-HOU2248","Baro Pressure: 980.1 hPa","Test Date: 08\/22\/2024"],["Type: Hemp Vape Cart","Analyst: MEH","Valid Through: 08\/23\/2025"],["Method: FE04U12 HPLC-UV","Technician: ARH","Report Issued: 08\/23\/2024"]],"md":"| Client Name, Sample Details | Test Conditions | Sample ID#: 148191 |\n| --------------------------- | -------------------------- | -------------------------------- |\n| Not Your Bakery | Prep\/Sheet ID#: MIP240822b | Harvest\/Process Date: 08\/22\/2024 |\n| Delray Beach, FL 33445 | Scale: XS205-M12 | Serving Size (g): 1 |\n| Sample: Papaya Runtz Vape | Temp: 21.9 \u00b0C | Date Received: 08\/22\/2024 |\n| License: MI-HOU2248 | Baro Pressure: 980.1 hPa | Test Date: 08\/22\/2024 |\n| Type: Hemp Vape Cart | Analyst: MEH | Valid Through: 08\/23\/2025 |\n| Method: FE04U12 HPLC-UV | Technician: ARH | Report Issued: 08\/23\/2024 |","isPerfectTable":false,"csv":"\"Client Name, Sample Details\",\"Test Conditions\",\"Sample ID#: 148191\"\n\"Not Your Bakery\",\"Prep\/Sheet ID#: MIP240822b\",\"Harvest\/Process Date: 08\/22\/2024\"\n\"Delray Beach, FL 33445\",\"Scale: XS205-M12\",\"Serving Size (g): 1\"\n\"Sample: Papaya Runtz Vape\",\"Temp: 21.9 \u00b0C\",\"Date Received: 08\/22\/2024\"\n\"License: MI-HOU2248\",\"Baro Pressure: 980.1 hPa\",\"Test Date: 08\/22\/2024\"\n\"Type: Hemp Vape Cart\",\"Analyst: MEH\",\"Valid Through: 08\/23\/2025\"\n\"Method: FE04U12 HPLC-UV\",\"Technician: ARH\",\"Report Issued: 08\/23\/2024\""},{"type":"table","rows":[["Test Compounds","\u03949-THC","THCA","\u03948-THC","CBD","CBDA","CBC","CBGA","CBN","CBC","CBL","THCV","CBDV","Total Cannabinoids","Total THC","Total CBD","Calc Max Total Cannabinoids"],["Amount (%)","0.1","87.5","0.8","N\/D","N\/D","N\/D","N\/D","N\/D","N\/D","N\/D","N\/D","N\/D","89.3","0.9","N\/D","89.3"],["Amount (mg\/g)","1.2","875","8.1","N\/D","N\/D","N\/D","N\/D","N\/D","N\/D","N\/D","N\/D","N\/D","893","9.0","N\/D","893"],["Amount per Serving (mg)","1.2","875","8.1","N\/D","N\/D","N\/D","N\/D","N\/D","N\/D","N\/D","N\/D","N\/D","893","9.0","N\/D","893"],["LOQ (mg\/g)","-","-","-","-","-","-","2.95","-","-","-","2.95","2.95","2.95","-","-","-"]],"md":"| Test Compounds | \u03949-THC | THCA | \u03948-THC | CBD | CBDA | CBC | CBGA | CBN | CBC | CBL | THCV | CBDV | Total Cannabinoids | Total THC | Total CBD | Calc Max Total Cannabinoids |\n| ----------------------- | ------ | ---- | ------ | --- | ---- | --- | ---- | --- | --- | --- | ---- | ---- | ------------------ | --------- | --------- | --------------------------- |\n| Amount (%) | 0.1 | 87.5 | 0.8 | N\/D | N\/D | N\/D | N\/D | N\/D | N\/D | N\/D | N\/D | N\/D | 89.3 | 0.9 | N\/D | 89.3 |\n| Amount (mg\/g) | 1.2 | 875 | 8.1 | N\/D | N\/D | N\/D | N\/D | N\/D | N\/D | N\/D | N\/D | N\/D | 893 | 9.0 | N\/D | 893 |\n| Amount per Serving (mg) | 1.2 | 875 | 8.1 | N\/D | N\/D | N\/D | N\/D | N\/D | N\/D | N\/D | N\/D | N\/D | 893 | 9.0 | N\/D | 893 |\n| LOQ (mg\/g) | - | - | - | - | - | - | 2.95 | - | - | - | 2.95 | 2.95 | 2.95 | - | - | - |","isPerfectTable":false,"csv":"\"Test Compounds\",\"\u03949-THC\",\"THCA\",\"\u03948-THC\",\"CBD\",\"CBDA\",\"CBC\",\"CBGA\",\"CBN\",\"CBC\",\"CBL\",\"THCV\",\"CBDV\",\"Total Cannabinoids\",\"Total THC\",\"Total CBD\",\"Calc Max Total Cannabinoids\"\n\"Amount (%)\",\"0.1\",\"87.5\",\"0.8\",\"N\/D\",\"N\/D\",\"N\/D\",\"N\/D\",\"N\/D\",\"N\/D\",\"N\/D\",\"N\/D\",\"N\/D\",\"89.3\",\"0.9\",\"N\/D\",\"89.3\"\n\"Amount (mg\/g)\",\"1.2\",\"875\",\"8.1\",\"N\/D\",\"N\/D\",\"N\/D\",\"N\/D\",\"N\/D\",\"N\/D\",\"N\/D\",\"N\/D\",\"N\/D\",\"893\",\"9.0\",\"N\/D\",\"893\"\n\"Amount per Serving (mg)\",\"1.2\",\"875\",\"8.1\",\"N\/D\",\"N\/D\",\"N\/D\",\"N\/D\",\"N\/D\",\"N\/D\",\"N\/D\",\"N\/D\",\"N\/D\",\"893\",\"9.0\",\"N\/D\",\"893\"\n\"LOQ (mg\/g)\",\"-\",\"-\",\"-\",\"-\",\"-\",\"-\",\"2.95\",\"-\",\"-\",\"-\",\"2.95\",\"2.95\",\"2.95\",\"-\",\"-\",\"-\""},{"type":"text","value":"- LOD = Limit of Quantitation; %RPD = Relative Percent Deviation; %RSD = Relative Standard Deviation; N\/D = Not Detected\n- *Designates values that are not currently included in the accredited scope of Iron Laboratories\n- FE-45 designates tests that use the method FE-45. FE-45 is performed using AOAC 968.07 and 32.004-32.009\n- FE-45 has a relative expanded (k=2) uncertainty of \u00b110% for moisture, \u00b11.4% for water activity for unprocessed plant materials, and 13.10% for water activity for infused products. Vitamin E acetate analysis has a relative expanded (k=2) uncertainty of \u00b18.8%\n- Total THC and CBD is calculated using the formula: THC = (0.877 * THCA) + \u03949-THC. This is the amount of THC or CBD derived from THCA or CBDA, respectively.\n- These values are calculated by applying a molar correction factor of 0.877 to the THCA or the CBDA value\n- Calc Max Total Cannabinoids is the sum of Total THC, Total CBD, CBN, Total CBG, CBC, THCV, CBDV, and CBL.\n- Total CBG is calculated as CBG plus CBGA * 0.878 (the molar correction factor for CBGA to CBG conversion).\n- %Decarb. THC and CBD refer to the percentage of \u03949-THC or CBD relative to THCA or CBDA, respectively.\n\n**This sample has undergone random sampling and has been tested for compliant state, batch representative testing.**\n\nResults apply to the sample as received.\n\nThis certificate shall not be reproduced except in full, without written approval of Iron Laboratories, LLC.\n\n----\n\nAmanda Heidler \nAmanda Heidler, Lab Manager\n\nMac Hyman \nMacKenzie L. Hyman, Quality Manager\n\nIron Laboratories, LLC is an ISO\/IEC 17025:2017 Testing Laboratory laboratory accredited by (PJLA) Perry Johnson Laboratory Accreditation, Certificate No. 77802\n\nTested by Iron Laboratories Michigan, 1825 E. West Maple Walled Lake, MI 48390\n\nPage 1 of 2","md":"- LOD = Limit of Quantitation; %RPD = Relative Percent Deviation; %RSD = Relative Standard Deviation; N\/D = Not Detected\n- *Designates values that are not currently included in the accredited scope of Iron Laboratories\n- FE-45 designates tests that use the method FE-45. FE-45 is performed using AOAC 968.07 and 32.004-32.009\n- FE-45 has a relative expanded (k=2) uncertainty of \u00b110% for moisture, \u00b11.4% for water activity for unprocessed plant materials, and 13.10% for water activity for infused products. Vitamin E acetate analysis has a relative expanded (k=2) uncertainty of \u00b18.8%\n- Total THC and CBD is calculated using the formula: THC = (0.877 * THCA) + \u03949-THC. This is the amount of THC or CBD derived from THCA or CBDA, respectively.\n- These values are calculated by applying a molar correction factor of 0.877 to the THCA or the CBDA value\n- Calc Max Total Cannabinoids is the sum of Total THC, Total CBD, CBN, Total CBG, CBC, THCV, CBDV, and CBL.\n- Total CBG is calculated as CBG plus CBGA * 0.878 (the molar correction factor for CBGA to CBG conversion).\n- %Decarb. THC and CBD refer to the percentage of \u03949-THC or CBD relative to THCA or CBDA, respectively.\n\n**This sample has undergone random sampling and has been tested for compliant state, batch representative testing.**\n\nResults apply to the sample as received.\n\nThis certificate shall not be reproduced except in full, without written approval of Iron Laboratories, LLC.\n\n----\n\nAmanda Heidler \nAmanda Heidler, Lab Manager\n\nMac Hyman \nMacKenzie L. Hyman, Quality Manager\n\nIron Laboratories, LLC is an ISO\/IEC 17025:2017 Testing Laboratory laboratory accredited by (PJLA) Perry Johnson Laboratory Accreditation, Certificate No. 77802\n\nTested by Iron Laboratories Michigan, 1825 E. West Maple Walled Lake, MI 48390\n\nPage 1 of 2"}],"status":"OK","originalOrientationAngle":0,"links":[],"triggeredAutoMode":false,"parsingMode":"multimodal-openai-gpt4o","structuredData":null,"noStructuredContent":false,"noTextContent":false,"pageHeaderMarkdown":"\nISO\/IEC 17025:2017 Accredited \nHemp Potency Analysis by High Performance Liquid Chromatography \nTest Certificate #: 148191-001\n","pageFooterMarkdown":""}],"job_metadata":{"credits_used":0,"job_credits_usage":0,"job_pages":1,"job_auto_mode_triggered_pages":0,"job_is_cache_hit":false}},"markdown":"\nISO\/IEC 17025:2017 Accredited \nHemp Potency Analysis by High Performance Liquid Chromatography \nTest Certificate #: 148191-001\n\n# Testing Accreditation #: 77802\n\n| Client Name, Sample Details | Test Conditions | Sample ID#: 148191 |\n|-----------------------------|-----------------|--------------------|\n| Not Your Bakery | Prep\/Sheet ID#: MIP240822b | Harvest\/Process Date: 08\/22\/2024 |\n| Delray Beach, FL 33445 | Scale: XS205-M12 | Serving Size (g): 1 |\n| Sample: Papaya Runtz Vape | Temp: 21.9 \u00b0C | Date Received: 08\/22\/2024 |\n| License: MI-HOU2248 | Baro Pressure: 980.1 hPa | Test Date: 08\/22\/2024 |\n| Type: Hemp Vape Cart | Analyst: MEH | Valid Through: 08\/23\/2025 |\n| Method: FE04U12 HPLC-UV | Technician: ARH | Report Issued: 08\/23\/2024 |\n\n| Test Compounds | \u03949-THC | THCA | \u03948-THC | CBD | CBDA | CBC | CBGA | CBN | CBC | CBL | THCV | CBDV | Total Cannabinoids | Total THC | Total CBD | Calc Max Total Cannabinoids |\n|----------------|--------|------|--------|-----|------|-----|------|-----|-----|-----|------|------|--------------------|-----------|----------|-----------------------------|\n| Amount (%) | 0.1 | 87.5 | 0.8 | N\/D | N\/D | N\/D | N\/D | N\/D | N\/D | N\/D | N\/D | N\/D | 89.3 | 0.9 | N\/D | 89.3 |\n| Amount (mg\/g) | 1.2 | 875 | 8.1 | N\/D | N\/D | N\/D | N\/D | N\/D | N\/D | N\/D | N\/D | N\/D | 893 | 9.0 | N\/D | 893 |\n| Amount per Serving (mg) | 1.2 | 875 | 8.1 | N\/D | N\/D | N\/D | N\/D | N\/D | N\/D | N\/D | N\/D | N\/D | 893 | 9.0 | N\/D | 893 |\n| LOQ (mg\/g) | - | - | - | - | - | - | 2.95 | - | - | - | 2.95 | 2.95 | 2.95 | - | - | - |\n\n- LOD = Limit of Quantitation; %RPD = Relative Percent Deviation; %RSD = Relative Standard Deviation; N\/D = Not Detected\n- *Designates values that are not currently included in the accredited scope of Iron Laboratories\n- FE-45 designates tests that use the method FE-45. FE-45 is performed using AOAC 968.07 and 32.004-32.009\n- FE-45 has a relative expanded (k=2) uncertainty of \u00b110% for moisture, \u00b11.4% for water activity for unprocessed plant materials, and 13.10% for water activity for infused products. Vitamin E acetate analysis has a relative expanded (k=2) uncertainty of \u00b18.8%\n- Total THC and CBD is calculated using the formula: THC = (0.877 * THCA) + \u03949-THC. This is the amount of THC or CBD derived from THCA or CBDA, respectively.\n- These values are calculated by applying a molar correction factor of 0.877 to the THCA or the CBDA value\n- Calc Max Total Cannabinoids is the sum of Total THC, Total CBD, CBN, Total CBG, CBC, THCV, CBDV, and CBL.\n- Total CBG is calculated as CBG plus CBGA * 0.878 (the molar correction factor for CBGA to CBG conversion).\n- %Decarb. THC and CBD refer to the percentage of \u03949-THC or CBD relative to THCA or CBDA, respectively.\n\n**This sample has undergone random sampling and has been tested for compliant state, batch representative testing.**\n\nResults apply to the sample as received.\n\nThis certificate shall not be reproduced except in full, without written approval of Iron Laboratories, LLC.\n\n----\n\nAmanda Heidler \nAmanda Heidler, Lab Manager\n\nMac Hyman \nMacKenzie L. Hyman, Quality Manager\n\nIron Laboratories, LLC is an ISO\/IEC 17025:2017 Testing Laboratory laboratory accredited by (PJLA) Perry Johnson Laboratory Accreditation, Certificate No. 77802\n\nTested by Iron Laboratories Michigan, 1825 E. West Maple Walled Lake, MI 48390\n\nPage 1 of 2","jobDetails":{"webhook_configurations":null,"job_name":"parse_raw_file_job","partitions":{"file_parsing_id_partition":"bd1dc514-9509-4b68-a693-af6b2e309927"},"parameters":{"priority":null,"custom_metadata":null,"resource_info":null,"languages":["en"],"parsing_instruction":"","disable_ocr":false,"annotate_links":false,"adaptive_long_table":false,"compact_markdown_table":false,"disable_reconstruction":false,"disable_image_extraction":false,"invalidate_cache":false,"outlined_table_extraction":false,"merge_tables_across_pages_in_markdown":false,"output_pdf_of_document":false,"do_not_cache":false,"fast_mode":false,"skip_diagonal_text":false,"preserve_layout_alignment_across_pages":false,"preserve_very_small_text":false,"gpt4o_mode":false,"do_not_unroll_columns":false,"extract_layout":false,"high_res_ocr":false,"html_make_all_elements_visible":false,"html_remove_navigation_elements":false,"html_remove_fixed_elements":false,"guess_xlsx_sheet_name":false,"page_separator":null,"bounding_box":"","bbox_top":null,"bbox_right":null,"bbox_bottom":null,"bbox_left":null,"target_pages":"","use_vendor_multimodal_model":true,"vendor_multimodal_model_name":"openai-gpt4o","model":"","page_prefix":"","page_suffix":"","webhook_url":"","preset":"","take_screenshot":false,"is_formatting_instruction":true,"premium_mode":false,"continuous_mode":false,"input_s3_path":"s3:\/\/llama-platform-file-parsing\/fb_iKieaLfVCeTaHV3IzxdANsa7NAD2\/bd1dc514-9509-4b68-a693-af6b2e309927\/input.png","input_s3_region":"us-east-1","output_s3_path_prefix":"s3:\/\/llama-platform-file-parsing\/fb_iKieaLfVCeTaHV3IzxdANsa7NAD2\/bd1dc514-9509-4b68-a693-af6b2e309927","output_s3_region":"us-east-1","project_id":"983c7754-5052-4149-b409-986d83545a50","azure_openai_deployment_name":null,"azure_openai_endpoint":null,"azure_openai_api_version":null,"input_url":null,"http_proxy":null,"auto_mode":false,"auto_mode_trigger_on_regexp_in_page":null,"auto_mode_trigger_on_text_in_page":null,"auto_mode_trigger_on_table_in_page":false,"auto_mode_trigger_on_image_in_page":false,"auto_mode_configuration_json":null,"structured_output":false,"structured_output_json_schema":null,"structured_output_json_schema_name":null,"max_pages":null,"max_pages_enforced":0,"extract_charts":false,"formatting_instruction":null,"complemental_formatting_instruction":null,"content_guideline_instruction":null,"spreadsheet_extract_sub_tables":true,"job_timeout_in_seconds":null,"job_timeout_extra_time_per_page_in_seconds":null,"strict_mode_image_extraction":false,"strict_mode_image_ocr":false,"strict_mode_reconstruction":false,"strict_mode_buggy_font":false,"save_images":true,"hide_headers":false,"hide_footers":false,"page_header_prefix":null,"page_header_suffix":null,"page_footer_prefix":null,"page_footer_suffix":null,"ignore_document_elements_for_layout_detection":false,"output_tables_as_HTML":false,"internal_is_screenshot_job":false,"parse_mode":null,"system_prompt":"","system_prompt_append":"","user_prompt":"","page_error_tolerance":0.05,"replace_failed_page_mode":null,"replace_failed_page_with_error_message_prefix":"","replace_failed_page_with_error_message_suffix":"","markdown_table_multiline_header_separator":null,"type":"parse","file_name":"LabReportImage.png","original_file_name":"LabReportImage.png","file_key":"s3:\/\/llama-platform-file-parsing\/fb_iKieaLfVCeTaHV3IzxdANsa7NAD2\/bd1dc514-9509-4b68-a693-af6b2e309927\/input.png","lang":"en","outputBucket":null,"file_id":null,"pipeline_id":null},"session_id":null,"correlation_id":null,"parent_job_execution_id":null,"user_id":"fb:iKieaLfVCeTaHV3IzxdANsa7NAD2","created_at":"2025-07-25T03:39:04.493000Z","project_id":"983c7754-5052-4149-b409-986d83545a50","id":"b7829196-e451-4529-b76c-d8fa2c0caae7","status":"SUCCESS","error_code":null,"error_message":null,"attempts":1,"started_at":"2025-07-25T03:39:04.544000Z","ended_at":"2025-07-25T03:40:10.224000Z","updated_at":"2025-07-25T03:40:10.232000Z","jobInfo":{"status":"success","info":"multimodal","model":"openai-gpt4o","pages":1,"options":{"adaptiveLongTable":false,"annotateLinks":null,"autoMode":false,"autoModeConfigurationJson":null,"autoModeTriggerOnImageInPage":false,"autoModeTriggerOnRegexpInPage":null,"autoModeTriggerOnTableInPage":false,"autoModeTriggerOnTextInPage":null,"azureOpenAiApiVersion":null,"azureOpenAiDeploymentName":null,"azureOpenAiEndpoint":null,"azureOpenAiKey":null,"bboxBottom":null,"bboxLeft":null,"bboxRight":null,"bboxTop":null,"boundingBox":null,"compactMarkdownTable":false,"complementalFormattingInstruction":null,"contentGuidelineInstruction":null,"disableImageExtraction":false,"disableOcr":false,"doNotCache":false,"doNotUnrollColumns":false,"extractCharts":false,"extractLayout":false,"fileId":null,"fileName":"LabReportImage.png","formattingInstruction":null,"guessXLSXSheetName":false,"hideFooters":false,"hideHeaders":false,"highResOcr":false,"htmlMakeAllElementsVisible":false,"htmlRemoveFixedElements":false,"htmlRemoveNavigationElements":false,"httpProxy":null,"ignoreDocumentElementsForLayoutDetection":false,"inputS3Path":"s3:\/\/llama-platform-file-parsing\/fb_iKieaLfVCeTaHV3IzxdANsa7NAD2\/bd1dc514-9509-4b68-a693-af6b2e309927\/input.png","inputS3Region":"us-east-1","inputUrl":null,"invalidateCache":false,"isFormattingInstruction":true,"isOurOwnS3Bucket":true,"jobTimeoutExtraTimePerPageInSeconds":2,"jobTimeoutInSeconds":null,"language":"en","logFiles":false,"markdownTableMultilineHeaderSeparator":"<br\/>","maxPages":701,"mergeTablesAcrossPagesInMarkdown":false,"model":"openai-gpt4o","multimodalPipeline":true,"outlinedTableExtraction":false,"outputPDFOfDocument":false,"outputS3PathPrefix":"s3:\/\/llama-platform-file-parsing\/fb_iKieaLfVCeTaHV3IzxdANsa7NAD2\/bd1dc514-9509-4b68-a693-af6b2e309927","outputS3Region":"us-east-1","outputTablesAsHTML":false,"pageErrorTolerance":0.05,"pageFooterPrefix":null,"pageFooterSuffix":null,"pageHeaderPrefix":null,"pageHeaderSuffix":null,"pagePrefix":null,"pageSeparator":"\n---\n","pageSuffix":null,"parseMode":"parse_page_with_lvm","preserveLayoutAlignmentAcrossPages":false,"preserveVerySmallText":false,"replaceFailedPageMode":"raw_text","replaceFailedPageWithErrorMessagePrefix":null,"replaceFailedPageWithErrorMessageSuffix":null,"saveImages":true,"skipDiagonalText":false,"spreadSheetExtractSubTables":true,"strictModeBuggyFont":false,"strictModeImageExtraction":false,"strictModeImageOCR":false,"strictModeReconstruction":false,"structuredOutput":false,"structuredOutputJSONSchema":null,"structuredOutputJSONSchemaName":null,"structuredOutputSchema":null,"takeScreenshot":false,"targetPages":null,"template":null,"vendorAPIKey":"[User provided key]","webhookUrl":null,"job_record_id":"b7829196-e451-4529-b76c-d8fa2c0caae7","jobOutOfQueueTimestamp":1753414744560,"jobCreatedAtTimestamp":1753414744560,"legacy_job_name":"parse_raw_file_job","legacy_file_parsing_id_partition":"bd1dc514-9509-4b68-a693-af6b2e309927","legacy_session_id":null,"legacy_correlation_id":null,"legacy_parent_job_execution_id":null,"user_id":"fb:iKieaLfVCeTaHV3IzxdANsa7NAD2","project_id":"983c7754-5052-4149-b409-986d83545a50","created_at":"2025-07-25T03:39:04.493000Z","temporal_run_id":null,"temporal_workflow_id":null,"documentAborter":[]},"metadata":{"pdf-pages":1,"pdf-real-pages":1,"pdf-mdLength":3600,"pdf-multimodal-time":63131,"pdf-multimodal-pdf2Image":302,"pdf-inputTokens":1133,"pdf-outputTokens":1091,"pdf-model":"openai-gpt4o"},"images":["page_1.jpg"],"charts":[]}}}
{"prompt":[{"role":"user","content":"\n This is a markdown for a cannabis product lab report:\n ---START MARKDOWN HERE---\n \"\\nISO\\\/IEC 17025:2017 Accredited \\nHemp Potency Analysis by High Performance Liquid Chromatography \\nTest Certificate #: 148191-001\\n\\n# Testing Accreditation #: 77802\\n\\n| Client Name, Sample Details | Test Conditions | Sample ID#: 148191 |\\n|-----------------------------|-----------------|--------------------|\\n| Not Your Bakery | Prep\\\/Sheet ID#: MIP240822b | Harvest\\\/Process Date: 08\\\/22\\\/2024 |\\n| Delray Beach, FL 33445 | Scale: XS205-M12 | Serving Size (g): 1 |\\n| Sample: Papaya Runtz Vape | Temp: 21.9 \\u00b0C | Date Received: 08\\\/22\\\/2024 |\\n| License: MI-HOU2248 | Baro Pressure: 980.1 hPa | Test Date: 08\\\/22\\\/2024 |\\n| Type: Hemp Vape Cart | Analyst: MEH | Valid Through: 08\\\/23\\\/2025 |\\n| Method: FE04U12 HPLC-UV | Technician: ARH | Report Issued: 08\\\/23\\\/2024 |\\n\\n| Test Compounds | \\u03949-THC | THCA | \\u03948-THC | CBD | CBDA | CBC | CBGA | CBN | CBC | CBL | THCV | CBDV | Total Cannabinoids | Total THC | Total CBD | Calc Max Total Cannabinoids |\\n|----------------|--------|------|--------|-----|------|-----|------|-----|-----|-----|------|------|--------------------|-----------|----------|-----------------------------|\\n| Amount (%) | 0.1 | 87.5 | 0.8 | N\\\/D | N\\\/D | N\\\/D | N\\\/D | N\\\/D | N\\\/D | N\\\/D | N\\\/D | N\\\/D | 89.3 | 0.9 | N\\\/D | 89.3 |\\n| Amount (mg\\\/g) | 1.2 | 875 | 8.1 | N\\\/D | N\\\/D | N\\\/D | N\\\/D | N\\\/D | N\\\/D | N\\\/D | N\\\/D | N\\\/D | 893 | 9.0 | N\\\/D | 893 |\\n| Amount per Serving (mg) | 1.2 | 875 | 8.1 | N\\\/D | N\\\/D | N\\\/D | N\\\/D | N\\\/D | N\\\/D | N\\\/D | N\\\/D | N\\\/D | 893 | 9.0 | N\\\/D | 893 |\\n| LOQ (mg\\\/g) | - | - | - | - | - | - | 2.95 | - | - | - | 2.95 | 2.95 | 2.95 | - | - | - |\\n\\n- LOD = Limit of Quantitation; %RPD = Relative Percent Deviation; %RSD = Relative Standard Deviation; N\\\/D = Not Detected\\n- *Designates values that are not currently included in the accredited scope of Iron Laboratories\\n- FE-45 designates tests that use the method FE-45. FE-45 is performed using AOAC 968.07 and 32.004-32.009\\n- FE-45 has a relative expanded (k=2) uncertainty of \\u00b110% for moisture, \\u00b11.4% for water activity for unprocessed plant materials, and 13.10% for water activity for infused products. Vitamin E acetate analysis has a relative expanded (k=2) uncertainty of \\u00b18.8%\\n- Total THC and CBD is calculated using the formula: THC = (0.877 * THCA) + \\u03949-THC. This is the amount of THC or CBD derived from THCA or CBDA, respectively.\\n- These values are calculated by applying a molar correction factor of 0.877 to the THCA or the CBDA value\\n- Calc Max Total Cannabinoids is the sum of Total THC, Total CBD, CBN, Total CBG, CBC, THCV, CBDV, and CBL.\\n- Total CBG is calculated as CBG plus CBGA * 0.878 (the molar correction factor for CBGA to CBG conversion).\\n- %Decarb. THC and CBD refer to the percentage of \\u03949-THC or CBD relative to THCA or CBDA, respectively.\\n\\n**This sample has undergone random sampling and has been tested for compliant state, batch representative testing.**\\n\\nResults apply to the sample as received.\\n\\nThis certificate shall not be reproduced except in full, without written approval of Iron Laboratories, LLC.\\n\\n----\\n\\nAmanda Heidler \\nAmanda Heidler, Lab Manager\\n\\nMac Hyman \\nMacKenzie L. Hyman, Quality Manager\\n\\nIron Laboratories, LLC is an ISO\\\/IEC 17025:2017 Testing Laboratory laboratory accredited by (PJLA) Perry Johnson Laboratory Accreditation, Certificate No. 77802\\n\\nTested by Iron Laboratories Michigan, 1825 E. West Maple Walled Lake, MI 48390\\n\\nPage 1 of 2\"\n ---END OF MARKDOWN---\n \n Act like you are a cannabis lab analyst\n Extract the cannabis product name, product type, sample matrix\/product type and the laboratory name.\n The product type can be cannabis, kratom or mushroom\n "}],"jsonSchema":{"name":"lab_report_data","strict":false,"schema":{"type":"object","properties":{"lab_name":{"type":"string","description":"The laboratory that conducted the analysis"},"product_name":{"type":"string","description":"The name of the cannabis product"},"product_type":{"type":"string","description":"The type of the product","enum":["cannabis","kratom","mushroom"]},"sample_matrix":{"type":"string","description":"The sample matrix also known as the type of the product"}},"required":[],"additionalProperties":false}}}
{"prompt":[{"role":"user","content":"\n This is a markdown for a cannabis product lab report:\n ---START MARKDOWN HERE---\n \"\\nISO\\\/IEC 17025:2017 Accredited \\nHemp Potency Analysis by High Performance Liquid Chromatography \\nTest Certificate #: 148191-001\\n\\n# Testing Accreditation #: 77802\\n\\n| Client Name, Sample Details | Test Conditions | Sample ID#: 148191 |\\n|-----------------------------|-----------------|--------------------|\\n| Not Your Bakery | Prep\\\/Sheet ID#: MIP240822b | Harvest\\\/Process Date: 08\\\/22\\\/2024 |\\n| Delray Beach, FL 33445 | Scale: XS205-M12 | Serving Size (g): 1 |\\n| Sample: Papaya Runtz Vape | Temp: 21.9 \\u00b0C | Date Received: 08\\\/22\\\/2024 |\\n| License: MI-HOU2248 | Baro Pressure: 980.1 hPa | Test Date: 08\\\/22\\\/2024 |\\n| Type: Hemp Vape Cart | Analyst: MEH | Valid Through: 08\\\/23\\\/2025 |\\n| Method: FE04U12 HPLC-UV | Technician: ARH | Report Issued: 08\\\/23\\\/2024 |\\n\\n| Test Compounds | \\u03949-THC | THCA | \\u03948-THC | CBD | CBDA | CBC | CBGA | CBN | CBC | CBL | THCV | CBDV | Total Cannabinoids | Total THC | Total CBD | Calc Max Total Cannabinoids |\\n|----------------|--------|------|--------|-----|------|-----|------|-----|-----|-----|------|------|--------------------|-----------|----------|-----------------------------|\\n| Amount (%) | 0.1 | 87.5 | 0.8 | N\\\/D | N\\\/D | N\\\/D | N\\\/D | N\\\/D | N\\\/D | N\\\/D | N\\\/D | N\\\/D | 89.3 | 0.9 | N\\\/D | 89.3 |\\n| Amount (mg\\\/g) | 1.2 | 875 | 8.1 | N\\\/D | N\\\/D | N\\\/D | N\\\/D | N\\\/D | N\\\/D | N\\\/D | N\\\/D | N\\\/D | 893 | 9.0 | N\\\/D | 893 |\\n| Amount per Serving (mg) | 1.2 | 875 | 8.1 | N\\\/D | N\\\/D | N\\\/D | N\\\/D | N\\\/D | N\\\/D | N\\\/D | N\\\/D | N\\\/D | 893 | 9.0 | N\\\/D | 893 |\\n| LOQ (mg\\\/g) | - | - | - | - | - | - | 2.95 | - | - | - | 2.95 | 2.95 | 2.95 | - | - | - |\\n\\n- LOD = Limit of Quantitation; %RPD = Relative Percent Deviation; %RSD = Relative Standard Deviation; N\\\/D = Not Detected\\n- *Designates values that are not currently included in the accredited scope of Iron Laboratories\\n- FE-45 designates tests that use the method FE-45. FE-45 is performed using AOAC 968.07 and 32.004-32.009\\n- FE-45 has a relative expanded (k=2) uncertainty of \\u00b110% for moisture, \\u00b11.4% for water activity for unprocessed plant materials, and 13.10% for water activity for infused products. Vitamin E acetate analysis has a relative expanded (k=2) uncertainty of \\u00b18.8%\\n- Total THC and CBD is calculated using the formula: THC = (0.877 * THCA) + \\u03949-THC. This is the amount of THC or CBD derived from THCA or CBDA, respectively.\\n- These values are calculated by applying a molar correction factor of 0.877 to the THCA or the CBDA value\\n- Calc Max Total Cannabinoids is the sum of Total THC, Total CBD, CBN, Total CBG, CBC, THCV, CBDV, and CBL.\\n- Total CBG is calculated as CBG plus CBGA * 0.878 (the molar correction factor for CBGA to CBG conversion).\\n- %Decarb. THC and CBD refer to the percentage of \\u03949-THC or CBD relative to THCA or CBDA, respectively.\\n\\n**This sample has undergone random sampling and has been tested for compliant state, batch representative testing.**\\n\\nResults apply to the sample as received.\\n\\nThis certificate shall not be reproduced except in full, without written approval of Iron Laboratories, LLC.\\n\\n----\\n\\nAmanda Heidler \\nAmanda Heidler, Lab Manager\\n\\nMac Hyman \\nMacKenzie L. Hyman, Quality Manager\\n\\nIron Laboratories, LLC is an ISO\\\/IEC 17025:2017 Testing Laboratory laboratory accredited by (PJLA) Perry Johnson Laboratory Accreditation, Certificate No. 77802\\n\\nTested by Iron Laboratories Michigan, 1825 E. West Maple Walled Lake, MI 48390\\n\\nPage 1 of 2\"\n ---END OF MARKDOWN---\n \n Act like you are a lab analyst that can extract cannabinoids data from a lab report\n Give me the cannabinoids and potency results table. Give me the result in a markdown format\n "}]}
{"prompt":[{"role":"system","content":"You are a cannabis lab analyst"},{"role":"user","content":"\n I have the markdown of a cannabis product lab results : Certainly! Below is the cannabinoids and potency results table extracted and formatted in Markdown:\n\n```markdown\n| Test Compounds | \u03949-THC | THCA | \u03948-THC | CBD | CBDA | CBC | CBGA | CBN | CBC | CBL | THCV | CBDV | Total Cannabinoids | Total THC | Total CBD | Calc Max Total Cannabinoids |\n|-------------------------|--------|-------|--------|------|------|------|------|------|------|------|------|------|--------------------|-----------|----------|-----------------------------|\n| Amount (%) | 0.1 | 87.5 | 0.8 | N\/D | N\/D | N\/D | N\/D | N\/D | N\/D | N\/D | N\/D | N\/D | 89.3 | 0.9 | N\/D | 89.3 |\n| Amount (mg\/g) | 1.2 | 875 | 8.1 | N\/D | N\/D | N\/D | N\/D | N\/D | N\/D | N\/D | N\/D | N\/D | 893 | 9.0 | N\/D | 893 |\n| Amount per Serving (mg) | 1.2 | 875 | 8.1 | N\/D | N\/D | N\/D | N\/D | N\/D | N\/D | N\/D | N\/D | N\/D | 893 | 9.0 | N\/D | 893 |\n```\nNote: N\/D stands for \"Not Detected.\".\n Give me the total thc percentage, the delta 9 percentage and the thca percentage from the given lab report.\n The results are found in the results percentage column.\n \n The different possibilities of writing delta 9 in the lab report is similar to: \n\n \u03949-THC,Delta 9-THC,D9-THC,\u03949-TETRAHYDROCANNABINOL,\u03949-TETRAHYDROCANNABINOL (D9-THC),D9-Tetrahydrocannabinol,D9-Tetrahydrocannabinol (D9-THC),\u0394-9 THC,\u0394-9-Tetrahydrocannabinol (\u0394-9 THC),Tetrahydrocannabinol (\u03949-THC),delta 9-Tetrahydrocannabinol,delta 9-Tetrahydrocannabinol (THC),d9-THC*,\u03949-Tetrahydrocannabinol (\u03949-THC);\n \n The different possibilities of writing thca in the lab report is similar to: \n\n THCA,Tetrahydrocannabinolic Acid,Tetrahydrocannabinolic Acid (THCA),\u0394-9-Tetrahydrocannabinolic Acid,THCA-A,\u0394-9-Tetrahydrocannabinolic Acid (THCA-A),\u03949-THC Acid,\u03949-THC Acid (THCA),\u03949-THCA,THCa,\u03949-TETRAHYDROCANNABINOLIC ACID,\u03949-TETRAHYDROCANNABINOLIC ACID (THCA),D9-Tetrahydrocannabinolic acid,D9-Tetrahydrocannabinolic acid (THCa),delta-9-Tetrahydrocannabinolic Acid, delta-9-Tetrahydrocannabinolic Acid(THC-A),THC-A,\u03949-Tetrahydrocannabinolic Acid (\u03949-THCA);\n "}],"jsonSchema":{"name":"lab_report_analyte_information","strict":false,"schema":{"type":"object","properties":{"totalThcPercentage":{"type":"number","description":"The total thc or total active thc percentage of the product"},"delta9Percentage":{"type":"number","description":"The delta 9 percentage \/ thc 9 percentage of the product"},"thcaPercentage":{"type":"number","description":"The thca percentage of the product"}},"required":[],"additionalProperties":false}}}
{"prompt":[{"role":"user","content":"\n This is a markdown for a cannabis product lab report:\n ---START MARKDOWN HERE---\n \"\\nISO\\\/IEC 17025:2017 Accredited \\nHemp Potency Analysis by High Performance Liquid Chromatography \\nTest Certificate #: 148191-001\\n\\n# Testing Accreditation #: 77802\\n\\n| Client Name, Sample Details | Test Conditions | Sample ID#: 148191 |\\n|-----------------------------|-----------------|--------------------|\\n| Not Your Bakery | Prep\\\/Sheet ID#: MIP240822b | Harvest\\\/Process Date: 08\\\/22\\\/2024 |\\n| Delray Beach, FL 33445 | Scale: XS205-M12 | Serving Size (g): 1 |\\n| Sample: Papaya Runtz Vape | Temp: 21.9 \\u00b0C | Date Received: 08\\\/22\\\/2024 |\\n| License: MI-HOU2248 | Baro Pressure: 980.1 hPa | Test Date: 08\\\/22\\\/2024 |\\n| Type: Hemp Vape Cart | Analyst: MEH | Valid Through: 08\\\/23\\\/2025 |\\n| Method: FE04U12 HPLC-UV | Technician: ARH | Report Issued: 08\\\/23\\\/2024 |\\n\\n| Test Compounds | \\u03949-THC | THCA | \\u03948-THC | CBD | CBDA | CBC | CBGA | CBN | CBC | CBL | THCV | CBDV | Total Cannabinoids | Total THC | Total CBD | Calc Max Total Cannabinoids |\\n|----------------|--------|------|--------|-----|------|-----|------|-----|-----|-----|------|------|--------------------|-----------|----------|-----------------------------|\\n| Amount (%) | 0.1 | 87.5 | 0.8 | N\\\/D | N\\\/D | N\\\/D | N\\\/D | N\\\/D | N\\\/D | N\\\/D | N\\\/D | N\\\/D | 89.3 | 0.9 | N\\\/D | 89.3 |\\n| Amount (mg\\\/g) | 1.2 | 875 | 8.1 | N\\\/D | N\\\/D | N\\\/D | N\\\/D | N\\\/D | N\\\/D | N\\\/D | N\\\/D | N\\\/D | 893 | 9.0 | N\\\/D | 893 |\\n| Amount per Serving (mg) | 1.2 | 875 | 8.1 | N\\\/D | N\\\/D | N\\\/D | N\\\/D | N\\\/D | N\\\/D | N\\\/D | N\\\/D | N\\\/D | 893 | 9.0 | N\\\/D | 893 |\\n| LOQ (mg\\\/g) | - | - | - | - | - | - | 2.95 | - | - | - | 2.95 | 2.95 | 2.95 | - | - | - |\\n\\n- LOD = Limit of Quantitation; %RPD = Relative Percent Deviation; %RSD = Relative Standard Deviation; N\\\/D = Not Detected\\n- *Designates values that are not currently included in the accredited scope of Iron Laboratories\\n- FE-45 designates tests that use the method FE-45. FE-45 is performed using AOAC 968.07 and 32.004-32.009\\n- FE-45 has a relative expanded (k=2) uncertainty of \\u00b110% for moisture, \\u00b11.4% for water activity for unprocessed plant materials, and 13.10% for water activity for infused products. Vitamin E acetate analysis has a relative expanded (k=2) uncertainty of \\u00b18.8%\\n- Total THC and CBD is calculated using the formula: THC = (0.877 * THCA) + \\u03949-THC. This is the amount of THC or CBD derived from THCA or CBDA, respectively.\\n- These values are calculated by applying a molar correction factor of 0.877 to the THCA or the CBDA value\\n- Calc Max Total Cannabinoids is the sum of Total THC, Total CBD, CBN, Total CBG, CBC, THCV, CBDV, and CBL.\\n- Total CBG is calculated as CBG plus CBGA * 0.878 (the molar correction factor for CBGA to CBG conversion).\\n- %Decarb. THC and CBD refer to the percentage of \\u03949-THC or CBD relative to THCA or CBDA, respectively.\\n\\n**This sample has undergone random sampling and has been tested for compliant state, batch representative testing.**\\n\\nResults apply to the sample as received.\\n\\nThis certificate shall not be reproduced except in full, without written approval of Iron Laboratories, LLC.\\n\\n----\\n\\nAmanda Heidler \\nAmanda Heidler, Lab Manager\\n\\nMac Hyman \\nMacKenzie L. Hyman, Quality Manager\\n\\nIron Laboratories, LLC is an ISO\\\/IEC 17025:2017 Testing Laboratory laboratory accredited by (PJLA) Perry Johnson Laboratory Accreditation, Certificate No. 77802\\n\\nTested by Iron Laboratories Michigan, 1825 E. West Maple Walled Lake, MI 48390\\n\\nPage 1 of 2\"\n ---END OF MARKDOWN---\n \n Act like you are an ai that can extract all dates from a lab report\n Give me all the date text from this report in a table markdown format and do not derive any dates\n "}]}
{"id":"chatcmpl-Bx3aJ4gLjerUiVuAEeRA5ohzKU2Q5","object":"chat.completion","created":1753414831,"model":"gpt-4o-2024-08-06","system_fingerprint":"fp_07871e2ad8","choices":[{"index":0,"message":{"role":"assistant","content":"Certainly! Here's a table markdown format that extracts all the date text from the provided lab report:\n\n```markdown\n| Description | Date |\n|------------------------|-------------|\n| Harvest\/Process Date | 08\/22\/2024 |\n| Date Received | 08\/22\/2024 |\n| Test Date | 08\/22\/2024 |\n| Valid Through | 08\/23\/2025 |\n| Report Issued | 08\/23\/2024 |\n```\n"},"finish_reason":"stop"}],"usage":{"prompt_tokens":1262,"completion_tokens":110,"total_tokens":1372,"prompt_tokens_details":{"cached_tokens":1152,"audio_tokens":0},"completion_tokens_details":{"reasoning_tokens":0,"accepted_prediction_tokens":0,"rejected_prediction_tokens":0,"audio_tokens":0}}}
{"prompt":"\n I have table of dates from a lab report of a cannabis product in markdown format:\n Certainly! Here's a table markdown format that extracts all the date text from the provided lab report:\n\n```markdown\n| Description | Date |\n|------------------------|-------------|\n| Harvest\/Process Date | 08\/22\/2024 |\n| Date Received | 08\/22\/2024 |\n| Test Date | 08\/22\/2024 |\n| Valid Through | 08\/23\/2025 |\n| Report Issued | 08\/23\/2024 |\n```\n \n\n Convert all the date values in this table to standard ISO Format (yyyy-mm-dd)\n "}
{"id":"chatcmpl-Bx3aM8RGC9spcR6EWnawwCTkjMd9O","object":"chat.completion","created":1753414834,"model":"gpt-4o-2024-08-06","system_fingerprint":"fp_07871e2ad8","choices":[{"index":0,"message":{"role":"assistant","content":"Certainly! Here's the table with all the date values converted to ISO format:\n\n```markdown\n| Description | Date |\n|------------------------|------------|\n| Harvest\/Process Date | 2024-08-22 |\n| Date Received | 2024-08-22 |\n| Test Date | 2024-08-22 |\n| Valid Through | 2025-08-23 |\n| Report Issued | 2024-08-23 |\n```"},"finish_reason":"stop"}],"usage":{"prompt_tokens":171,"completion_tokens":100,"total_tokens":271,"prompt_tokens_details":{"cached_tokens":0,"audio_tokens":0},"completion_tokens_details":{"reasoning_tokens":0,"accepted_prediction_tokens":0,"rejected_prediction_tokens":0,"audio_tokens":0}}}
{"prompt":[{"role":"system","content":"You are a lab report analyst that can extract correct dates"},{"role":"user","content":"\n I have table of dates from a lab report of a cannabis product in markdown format:\n Certainly! Here's the table with all the date values converted to ISO format:\n\n```markdown\n| Description | Date |\n|------------------------|------------|\n| Harvest\/Process Date | 2024-08-22 |\n| Date Received | 2024-08-22 |\n| Test Date | 2024-08-22 |\n| Valid Through | 2025-08-23 |\n| Report Issued | 2024-08-23 |\n``` \n Give me the extraction date and give me the expiry date.\n \n The extraction date in the table can be similar to\n Date,Reported,Completion Date,Date Issued,Completed Date,Date Collected,Production Date,Date Completed\n \n The expiry date in the table can be similar to\n Expires,Expiry date,Expiry,Expiration Date\n "}],"jsonSchema":{"name":"extract_correct_dates","strict":false,"schema":{"type":"object","properties":{"expiryDate":{"type":"string","description":"Expiry date of the lab report."},"reportDate":{"type":"string","description":"The date the report was created or the date the sample was extracted"}},"required":[],"additionalProperties":false}}}