{"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 Sure, here is the table with the dates converted to ISO format:\n\n```markdown\n| Date Description | Date |\n|-------------------|------------|\n| Date Received | 2025-06-04 |\n| Best By (BB) | 2025-06-26 | \n| Manufacture Date | 2025-06-06 |\n| Signature Date | 2025-06-09 |\n``` \n\nFor the \"Best By (BB)\" date, since only the month and day were provided, I assumed the year to be 2025, as it seems to match the context of the other dates. If the year is different, please adjust accordingly. \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":"\nCertificate of Analysis\n1 of 1\n\n# WILLIE'S REMEDY PASSIONFRUIT ORANGE GUAVA\n\n**Sample ID:** 505F1013.03 \n**Type:** Finished Product \n**Matrix:** Beverage \n**Unit Size:** 357.22g \n\n**Batch ID:** CPL250506 \n**Collected:** 6\/5\/2025 \n**Received:** 6\/5\/2025 \n**Completed:** 6\/6\/2025 \n\n**Client** \nMidwest Extraction Services \n507-214-3550 \nLic. #: 20211071 \n\n| Total THC | Total THC | Total Cannabinoids |\n|-----------|-----------|--------------------|\n| 5.37mg\/unit | 0.0% | 0.00% |\n\n## Cannabinoids by HPLC-UV\n\n<table>\n <thead>\n <tr>\n <th>Analyte<\/th>\n <th>LOQ (mg\/mL)<\/th>\n <th>Results (%)<\/th>\n <th>Results (mg\/unit)<\/th>\n <\/tr>\n <\/thead>\n <tbody>\n <tr>\n <td>CBDVA<\/td>\n <td>---<\/td>\n <td>0.00000<\/td>\n <td>0.00<\/td>\n <\/tr>\n <tr>\n <td>CBDV<\/td>\n <td>---<\/td>\n <td>0.00000<\/td>\n <td>0.00<\/td>\n <\/tr>\n <tr>\n <td>CBDA<\/td>\n <td>---<\/td>\n <td>0.00000<\/td>\n <td>0.00<\/td>\n <\/tr>\n <tr>\n <td>CBGA<\/td>\n <td>---<\/td>\n <td>0.00000<\/td>\n <td>0.00<\/td>\n <\/tr>\n <tr>\n <td>CBG<\/td>\n <td>0.0003<\/td>\n <td>0.00059<\/td>\n <td>2.12<\/td>\n <\/tr>\n <tr>\n <td>CBD<\/td>\n <td>0.0003<\/td>\n <td>0.00063<\/td>\n <td>2.25<\/td>\n <\/tr>\n <tr>\n <td>THCV<\/td>\n <td>---<\/td>\n <td>0.00000<\/td>\n <td>0.00<\/td>\n <\/tr>\n <tr>\n <td>THCVA<\/td>\n <td>---<\/td>\n <td>0.00000<\/td>\n <td>0.00<\/td>\n <\/tr>\n <tr>\n <td>CBN<\/td>\n <td>0.0003<\/td>\n <td>0.00050<\/td>\n <td>0.18<\/td>\n <\/tr>\n <tr>\n <td>d9-THC<\/td>\n <td>0.0003<\/td>\n <td>0.00155<\/td>\n <td>5.37<\/td>\n <\/tr>\n <tr>\n <td>d8-THC<\/td>\n <td>0.0003<\/td>\n <td>0.00000<\/td>\n <td>0.00<\/td>\n <\/tr>\n <tr>\n <td>CBC<\/td>\n <td>---<\/td>\n <td>0.00000<\/td>\n <td>0.00<\/td>\n <\/tr>\n <tr>\n <td>THCA<\/td>\n <td>---<\/td>\n <td>0.00000<\/td>\n <td>0.00<\/td>\n <\/tr>\n <tr>\n <td>CBCA<\/td>\n <td>---<\/td>\n <td>0.00000<\/td>\n <td>0.00<\/td>\n <\/tr>\n <tr>\n <td>Total<\/td>\n <td colspan=\"3\">0.003<\/td>\n <\/tr>\n <\/tbody>\n<\/table>\n\nLOQ = Limit of Quantification; Total THC = d9-THC + (0.877 x THCA); Total CBD = CBD + (0.877 x CBDA)\n\n----\n\nAnalyst: Johanna Holloway \nDate: 06\/06\/2025 \n\nFina Analytics \n2300 Brown Ave Ste 13 \nWaseca, MN 56093 \n(507)-214-3550 #6 \nanalytics@finaLabs.co \n\nThis item has been tested by Fina Analytics and the results relate only to the sample tested. Fina Analytics makes no claim as to the efficacy, safety or other risks associated with de or non-detected amounts of substances reported herein. The reported result is based on the sample weight. This Certificate of Analysis shall not be reproduced except in full, without approval of Fina Analytics. Validated testing methodologies with an ISO IEC 17025:2017 accredited quality system was used when an (*) is present on the Certificate of Analysis. Measurement of uncertainty is not used for pass\/fail conditions but available upon request.","images":[{"name":"page_1.jpg","height":0,"width":0,"x":0,"y":0,"type":"full_page_screenshot"}],"charts":[],"items":[{"type":"text","value":"Certificate of Analysis\n1 of 1","md":"Certificate of Analysis\n1 of 1"},{"type":"heading","lvl":1,"value":"WILLIE'S REMEDY PASSIONFRUIT ORANGE GUAVA","md":"# WILLIE'S REMEDY PASSIONFRUIT ORANGE GUAVA"},{"type":"text","value":"**Sample ID:** 505F1013.03 \n**Type:** Finished Product \n**Matrix:** Beverage \n**Unit Size:** 357.22g \n\n**Batch ID:** CPL250506 \n**Collected:** 6\/5\/2025 \n**Received:** 6\/5\/2025 \n**Completed:** 6\/6\/2025 \n\n**Client** \nMidwest Extraction Services \n507-214-3550 \nLic. #: 20211071","md":"**Sample ID:** 505F1013.03 \n**Type:** Finished Product \n**Matrix:** Beverage \n**Unit Size:** 357.22g \n\n**Batch ID:** CPL250506 \n**Collected:** 6\/5\/2025 \n**Received:** 6\/5\/2025 \n**Completed:** 6\/6\/2025 \n\n**Client** \nMidwest Extraction Services \n507-214-3550 \nLic. #: 20211071"},{"type":"table","rows":[["Total THC","Total THC","Total Cannabinoids"],["5.37mg\/unit","0.0%","0.00%"]],"md":"| Total THC | Total THC | Total Cannabinoids |\n| ----------- | --------- | ------------------ |\n| 5.37mg\/unit | 0.0% | 0.00% |","isPerfectTable":false,"csv":"\"Total THC\",\"Total THC\",\"Total Cannabinoids\"\n\"5.37mg\/unit\",\"0.0%\",\"0.00%\""},{"type":"heading","lvl":2,"value":"Cannabinoids by HPLC-UV","md":"## Cannabinoids by HPLC-UV"},{"type":"table","rows":[["Analyte","LOQ (mg\/mL)","Results (%)","Results (mg\/unit)"],["CBDVA","---","0.00000","0.00"],["CBDV","---","0.00000","0.00"],["CBDA","---","0.00000","0.00"],["CBGA","---","0.00000","0.00"],["CBG","0.0003","0.00059","2.12"],["CBD","0.0003","0.00063","2.25"],["THCV","---","0.00000","0.00"],["THCVA","---","0.00000","0.00"],["CBN","0.0003","0.00050","0.18"],["d9-THC","0.0003","0.00155","5.37"],["d8-THC","0.0003","0.00000","0.00"],["CBC","---","0.00000","0.00"],["THCA","---","0.00000","0.00"],["CBCA","---","0.00000","0.00"],["Total","0.003","",""]],"html":"<table>\n <thead>\n <tr>\n <th>Analyte<\/th>\n <th>LOQ (mg\/mL)<\/th>\n <th>Results (%)<\/th>\n <th>Results (mg\/unit)<\/th>\n <\/tr>\n <\/thead>\n <tbody>\n <tr>\n <td>CBDVA<\/td>\n <td>---<\/td>\n <td>0.00000<\/td>\n <td>0.00<\/td>\n <\/tr>\n <tr>\n <td>CBDV<\/td>\n <td>---<\/td>\n <td>0.00000<\/td>\n <td>0.00<\/td>\n <\/tr>\n <tr>\n <td>CBDA<\/td>\n <td>---<\/td>\n <td>0.00000<\/td>\n <td>0.00<\/td>\n <\/tr>\n <tr>\n <td>CBGA<\/td>\n <td>---<\/td>\n <td>0.00000<\/td>\n <td>0.00<\/td>\n <\/tr>\n <tr>\n <td>CBG<\/td>\n <td>0.0003<\/td>\n <td>0.00059<\/td>\n <td>2.12<\/td>\n <\/tr>\n <tr>\n <td>CBD<\/td>\n <td>0.0003<\/td>\n <td>0.00063<\/td>\n <td>2.25<\/td>\n <\/tr>\n <tr>\n <td>THCV<\/td>\n <td>---<\/td>\n <td>0.00000<\/td>\n <td>0.00<\/td>\n <\/tr>\n <tr>\n <td>THCVA<\/td>\n <td>---<\/td>\n <td>0.00000<\/td>\n <td>0.00<\/td>\n <\/tr>\n <tr>\n <td>CBN<\/td>\n <td>0.0003<\/td>\n <td>0.00050<\/td>\n <td>0.18<\/td>\n <\/tr>\n <tr>\n <td>d9-THC<\/td>\n <td>0.0003<\/td>\n <td>0.00155<\/td>\n <td>5.37<\/td>\n <\/tr>\n <tr>\n <td>d8-THC<\/td>\n <td>0.0003<\/td>\n <td>0.00000<\/td>\n <td>0.00<\/td>\n <\/tr>\n <tr>\n <td>CBC<\/td>\n <td>---<\/td>\n <td>0.00000<\/td>\n <td>0.00<\/td>\n <\/tr>\n <tr>\n <td>THCA<\/td>\n <td>---<\/td>\n <td>0.00000<\/td>\n <td>0.00<\/td>\n <\/tr>\n <tr>\n <td>CBCA<\/td>\n <td>---<\/td>\n <td>0.00000<\/td>\n <td>0.00<\/td>\n <\/tr>\n <tr>\n <td>Total<\/td>\n <td colspan=\"3\">0.003<\/td>\n <\/tr>\n <\/tbody>\n<\/table>","md":"| Analyte | LOQ (mg\/mL) | Results (%) | Results (mg\/unit) |\n| ------- | ----------- | ----------- | ----------------- |\n| CBDVA | --- | 0.00000 | 0.00 |\n| CBDV | --- | 0.00000 | 0.00 |\n| CBDA | --- | 0.00000 | 0.00 |\n| CBGA | --- | 0.00000 | 0.00 |\n| CBG | 0.0003 | 0.00059 | 2.12 |\n| CBD | 0.0003 | 0.00063 | 2.25 |\n| THCV | --- | 0.00000 | 0.00 |\n| THCVA | --- | 0.00000 | 0.00 |\n| CBN | 0.0003 | 0.00050 | 0.18 |\n| d9-THC | 0.0003 | 0.00155 | 5.37 |\n| d8-THC | 0.0003 | 0.00000 | 0.00 |\n| CBC | --- | 0.00000 | 0.00 |\n| THCA | --- | 0.00000 | 0.00 |\n| CBCA | --- | 0.00000 | 0.00 |\n| Total | 0.003 | | |","isPerfectTable":true,"csv":"\"Analyte\",\"LOQ (mg\/mL)\",\"Results (%)\",\"Results (mg\/unit)\"\n\"CBDVA\",\"---\",\"0.00000\",\"0.00\"\n\"CBDV\",\"---\",\"0.00000\",\"0.00\"\n\"CBDA\",\"---\",\"0.00000\",\"0.00\"\n\"CBGA\",\"---\",\"0.00000\",\"0.00\"\n\"CBG\",\"0.0003\",\"0.00059\",\"2.12\"\n\"CBD\",\"0.0003\",\"0.00063\",\"2.25\"\n\"THCV\",\"---\",\"0.00000\",\"0.00\"\n\"THCVA\",\"---\",\"0.00000\",\"0.00\"\n\"CBN\",\"0.0003\",\"0.00050\",\"0.18\"\n\"d9-THC\",\"0.0003\",\"0.00155\",\"5.37\"\n\"d8-THC\",\"0.0003\",\"0.00000\",\"0.00\"\n\"CBC\",\"---\",\"0.00000\",\"0.00\"\n\"THCA\",\"---\",\"0.00000\",\"0.00\"\n\"CBCA\",\"---\",\"0.00000\",\"0.00\"\n\"Total\",\"0.003\",\"\",\"\""},{"type":"text","value":"LOQ = Limit of Quantification; Total THC = d9-THC + (0.877 x THCA); Total CBD = CBD + (0.877 x CBDA)\n\n----\n\nAnalyst: Johanna Holloway \nDate: 06\/06\/2025 \n\nFina Analytics \n2300 Brown Ave Ste 13 \nWaseca, MN 56093 \n(507)-214-3550 #6 \nanalytics@finaLabs.co \n\nThis item has been tested by Fina Analytics and the results relate only to the sample tested. Fina Analytics makes no claim as to the efficacy, safety or other risks associated with de or non-detected amounts of substances reported herein. The reported result is based on the sample weight. This Certificate of Analysis shall not be reproduced except in full, without approval of Fina Analytics. Validated testing methodologies with an ISO IEC 17025:2017 accredited quality system was used when an (*) is present on the Certificate of Analysis. Measurement of uncertainty is not used for pass\/fail conditions but available upon request.","md":"LOQ = Limit of Quantification; Total THC = d9-THC + (0.877 x THCA); Total CBD = CBD + (0.877 x CBDA)\n\n----\n\nAnalyst: Johanna Holloway \nDate: 06\/06\/2025 \n\nFina Analytics \n2300 Brown Ave Ste 13 \nWaseca, MN 56093 \n(507)-214-3550 #6 \nanalytics@finaLabs.co \n\nThis item has been tested by Fina Analytics and the results relate only to the sample tested. Fina Analytics makes no claim as to the efficacy, safety or other risks associated with de or non-detected amounts of substances reported herein. The reported result is based on the sample weight. This Certificate of Analysis shall not be reproduced except in full, without approval of Fina Analytics. Validated testing methodologies with an ISO IEC 17025:2017 accredited quality system was used when an (*) is present on the Certificate of Analysis. Measurement of uncertainty is not used for pass\/fail conditions but available upon request."}],"status":"OK","originalOrientationAngle":0,"links":[],"triggeredAutoMode":false,"parsingMode":"multimodal-openai-gpt4o","structuredData":null,"noStructuredContent":false,"noTextContent":false,"pageHeaderMarkdown":"\nCertificate of Analysis\n1 of 1\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":"\nCertificate of Analysis\n1 of 1\n\n# WILLIE'S REMEDY PASSIONFRUIT ORANGE GUAVA\n\n**Sample ID:** 505F1013.03 \n**Type:** Finished Product \n**Matrix:** Beverage \n**Unit Size:** 357.22g \n\n**Batch ID:** CPL250506 \n**Collected:** 6\/5\/2025 \n**Received:** 6\/5\/2025 \n**Completed:** 6\/6\/2025 \n\n**Client** \nMidwest Extraction Services \n507-214-3550 \nLic. #: 20211071 \n\n| Total THC | Total THC | Total Cannabinoids |\n|-----------|-----------|--------------------|\n| 5.37mg\/unit | 0.0% | 0.00% |\n\n## Cannabinoids by HPLC-UV\n\n| Analyte | LOQ (mg\/mL) | Results (%) | Results (mg\/unit) |\n| ------- | ----------- | ----------- | ----------------- |\n| CBDVA | --- | 0.00000 | 0.00 |\n| CBDV | --- | 0.00000 | 0.00 |\n| CBDA | --- | 0.00000 | 0.00 |\n| CBGA | --- | 0.00000 | 0.00 |\n| CBG | 0.0003 | 0.00059 | 2.12 |\n| CBD | 0.0003 | 0.00063 | 2.25 |\n| THCV | --- | 0.00000 | 0.00 |\n| THCVA | --- | 0.00000 | 0.00 |\n| CBN | 0.0003 | 0.00050 | 0.18 |\n| d9-THC | 0.0003 | 0.00155 | 5.37 |\n| d8-THC | 0.0003 | 0.00000 | 0.00 |\n| CBC | --- | 0.00000 | 0.00 |\n| THCA | --- | 0.00000 | 0.00 |\n| CBCA | --- | 0.00000 | 0.00 |\n| Total | 0.003 | | |\n\n\nLOQ = Limit of Quantification; Total THC = d9-THC + (0.877 x THCA); Total CBD = CBD + (0.877 x CBDA)\n\n----\n\nAnalyst: Johanna Holloway \nDate: 06\/06\/2025 \n\nFina Analytics \n2300 Brown Ave Ste 13 \nWaseca, MN 56093 \n(507)-214-3550 #6 \nanalytics@finaLabs.co \n\nThis item has been tested by Fina Analytics and the results relate only to the sample tested. Fina Analytics makes no claim as to the efficacy, safety or other risks associated with de or non-detected amounts of substances reported herein. The reported result is based on the sample weight. This Certificate of Analysis shall not be reproduced except in full, without approval of Fina Analytics. Validated testing methodologies with an ISO IEC 17025:2017 accredited quality system was used when an (*) is present on the Certificate of Analysis. Measurement of uncertainty is not used for pass\/fail conditions but available upon request.","jobDetails":{"webhook_configurations":null,"job_name":"parse_raw_file_job","partitions":{"file_parsing_id_partition":"adb74162-0381-429a-b775-e2fabd3066fe"},"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\/adb74162-0381-429a-b775-e2fabd3066fe\/input.pdf","input_s3_region":"us-east-1","output_s3_path_prefix":"s3:\/\/llama-platform-file-parsing\/fb_iKieaLfVCeTaHV3IzxdANsa7NAD2\/adb74162-0381-429a-b775-e2fabd3066fe","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":"6.6.2025-unlocked.pdf","original_file_name":"6.6.2025-unlocked.pdf","file_key":"s3:\/\/llama-platform-file-parsing\/fb_iKieaLfVCeTaHV3IzxdANsa7NAD2\/adb74162-0381-429a-b775-e2fabd3066fe\/input.pdf","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-24T11:52:06.088000Z","project_id":"983c7754-5052-4149-b409-986d83545a50","id":"adfcb9fd-1872-4f7e-b757-388098e9ecca","status":"SUCCESS","error_code":null,"error_message":null,"attempts":1,"started_at":"2025-07-24T11:52:06.131000Z","ended_at":"2025-07-24T11:52:48.147000Z","updated_at":"2025-07-24T11:52:48.157000Z","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":"6.6.2025-unlocked.pdf","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\/adb74162-0381-429a-b775-e2fabd3066fe\/input.pdf","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\/adb74162-0381-429a-b775-e2fabd3066fe","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":"adfcb9fd-1872-4f7e-b757-388098e9ecca","jobOutOfQueueTimestamp":1753357926153,"jobCreatedAtTimestamp":1753357926153,"legacy_job_name":"parse_raw_file_job","legacy_file_parsing_id_partition":"adb74162-0381-429a-b775-e2fabd3066fe","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-24T11:52:06.088000Z","temporal_run_id":null,"temporal_workflow_id":null,"documentAborter":[]},"metadata":{"pdf-pages":1,"pdf-real-pages":1,"pdf-mdLength":2457,"pdf-multimodal-time":39382,"pdf-multimodal-pdf2Image":312,"pdf-inputTokens":1133,"pdf-outputTokens":1152,"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 \"\\nCertificate of Analysis\\n1 of 1\\n\\n# WILLIE'S REMEDY PASSIONFRUIT ORANGE GUAVA\\n\\n**Sample ID:** 505F1013.03 \\n**Type:** Finished Product \\n**Matrix:** Beverage \\n**Unit Size:** 357.22g \\n\\n**Batch ID:** CPL250506 \\n**Collected:** 6\\\/5\\\/2025 \\n**Received:** 6\\\/5\\\/2025 \\n**Completed:** 6\\\/6\\\/2025 \\n\\n**Client** \\nMidwest Extraction Services \\n507-214-3550 \\nLic. #: 20211071 \\n\\n| Total THC | Total THC | Total Cannabinoids |\\n|-----------|-----------|--------------------|\\n| 5.37mg\\\/unit | 0.0% | 0.00% |\\n\\n## Cannabinoids by HPLC-UV\\n\\n| Analyte | LOQ (mg\\\/mL) | Results (%) | Results (mg\\\/unit) |\\n| ------- | ----------- | ----------- | ----------------- |\\n| CBDVA | --- | 0.00000 | 0.00 |\\n| CBDV | --- | 0.00000 | 0.00 |\\n| CBDA | --- | 0.00000 | 0.00 |\\n| CBGA | --- | 0.00000 | 0.00 |\\n| CBG | 0.0003 | 0.00059 | 2.12 |\\n| CBD | 0.0003 | 0.00063 | 2.25 |\\n| THCV | --- | 0.00000 | 0.00 |\\n| THCVA | --- | 0.00000 | 0.00 |\\n| CBN | 0.0003 | 0.00050 | 0.18 |\\n| d9-THC | 0.0003 | 0.00155 | 5.37 |\\n| d8-THC | 0.0003 | 0.00000 | 0.00 |\\n| CBC | --- | 0.00000 | 0.00 |\\n| THCA | --- | 0.00000 | 0.00 |\\n| CBCA | --- | 0.00000 | 0.00 |\\n| Total | 0.003 | | |\\n\\n\\nLOQ = Limit of Quantification; Total THC = d9-THC + (0.877 x THCA); Total CBD = CBD + (0.877 x CBDA)\\n\\n----\\n\\nAnalyst: Johanna Holloway \\nDate: 06\\\/06\\\/2025 \\n\\nFina Analytics \\n2300 Brown Ave Ste 13 \\nWaseca, MN 56093 \\n(507)-214-3550 #6 \\nanalytics@finaLabs.co \\n\\nThis item has been tested by Fina Analytics and the results relate only to the sample tested. Fina Analytics makes no claim as to the efficacy, safety or other risks associated with de or non-detected amounts of substances reported herein. The reported result is based on the sample weight. This Certificate of Analysis shall not be reproduced except in full, without approval of Fina Analytics. Validated testing methodologies with an ISO IEC 17025:2017 accredited quality system was used when an (*) is present on the Certificate of Analysis. Measurement of uncertainty is not used for pass\\\/fail conditions but available upon request.\"\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 \"\\nCertificate of Analysis\\n1 of 1\\n\\n# WILLIE'S REMEDY PASSIONFRUIT ORANGE GUAVA\\n\\n**Sample ID:** 505F1013.03 \\n**Type:** Finished Product \\n**Matrix:** Beverage \\n**Unit Size:** 357.22g \\n\\n**Batch ID:** CPL250506 \\n**Collected:** 6\\\/5\\\/2025 \\n**Received:** 6\\\/5\\\/2025 \\n**Completed:** 6\\\/6\\\/2025 \\n\\n**Client** \\nMidwest Extraction Services \\n507-214-3550 \\nLic. #: 20211071 \\n\\n| Total THC | Total THC | Total Cannabinoids |\\n|-----------|-----------|--------------------|\\n| 5.37mg\\\/unit | 0.0% | 0.00% |\\n\\n## Cannabinoids by HPLC-UV\\n\\n| Analyte | LOQ (mg\\\/mL) | Results (%) | Results (mg\\\/unit) |\\n| ------- | ----------- | ----------- | ----------------- |\\n| CBDVA | --- | 0.00000 | 0.00 |\\n| CBDV | --- | 0.00000 | 0.00 |\\n| CBDA | --- | 0.00000 | 0.00 |\\n| CBGA | --- | 0.00000 | 0.00 |\\n| CBG | 0.0003 | 0.00059 | 2.12 |\\n| CBD | 0.0003 | 0.00063 | 2.25 |\\n| THCV | --- | 0.00000 | 0.00 |\\n| THCVA | --- | 0.00000 | 0.00 |\\n| CBN | 0.0003 | 0.00050 | 0.18 |\\n| d9-THC | 0.0003 | 0.00155 | 5.37 |\\n| d8-THC | 0.0003 | 0.00000 | 0.00 |\\n| CBC | --- | 0.00000 | 0.00 |\\n| THCA | --- | 0.00000 | 0.00 |\\n| CBCA | --- | 0.00000 | 0.00 |\\n| Total | 0.003 | | |\\n\\n\\nLOQ = Limit of Quantification; Total THC = d9-THC + (0.877 x THCA); Total CBD = CBD + (0.877 x CBDA)\\n\\n----\\n\\nAnalyst: Johanna Holloway \\nDate: 06\\\/06\\\/2025 \\n\\nFina Analytics \\n2300 Brown Ave Ste 13 \\nWaseca, MN 56093 \\n(507)-214-3550 #6 \\nanalytics@finaLabs.co \\n\\nThis item has been tested by Fina Analytics and the results relate only to the sample tested. Fina Analytics makes no claim as to the efficacy, safety or other risks associated with de or non-detected amounts of substances reported herein. The reported result is based on the sample weight. This Certificate of Analysis shall not be reproduced except in full, without approval of Fina Analytics. Validated testing methodologies with an ISO IEC 17025:2017 accredited quality system was used when an (*) is present on the Certificate of Analysis. Measurement of uncertainty is not used for pass\\\/fail conditions but available upon request.\"\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 markdown table extracted from the lab report, presenting the cannabinoids and their potency results:\n\n```markdown\n## Cannabinoids Potency Results\n\n| Analyte | LOQ (mg\/mL) | Results (%) | Results (mg\/unit) |\n| ------- | ----------- | ----------- | ----------------- |\n| CBDVA | --- | 0.00000 | 0.00 |\n| CBDV | --- | 0.00000 | 0.00 |\n| CBDA | --- | 0.00000 | 0.00 |\n| CBGA | --- | 0.00000 | 0.00 |\n| CBG | 0.0003 | 0.00059 | 2.12 |\n| CBD | 0.0003 | 0.00063 | 2.25 |\n| THCV | --- | 0.00000 | 0.00 |\n| THCVA | --- | 0.00000 | 0.00 |\n| CBN | 0.0003 | 0.00050 | 0.18 |\n| d9-THC | 0.0003 | 0.00155 | 5.37 |\n| d8-THC | 0.0003 | 0.00000 | 0.00 |\n| CBC | --- | 0.00000 | 0.00 |\n| THCA | --- | 0.00000 | 0.00 |\n| CBCA | --- | 0.00000 | 0.00 |\n| Total | 0.003 | | |\n\nLOQ = Limit of Quantification\n```\n\nThis table summarizes the potency measurement of various cannabinoids present in the sample..\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 \"\\nCertificate of Analysis\\n1 of 1\\n\\n# WILLIE'S REMEDY PASSIONFRUIT ORANGE GUAVA\\n\\n**Sample ID:** 505F1013.03 \\n**Type:** Finished Product \\n**Matrix:** Beverage \\n**Unit Size:** 357.22g \\n\\n**Batch ID:** CPL250506 \\n**Collected:** 6\\\/5\\\/2025 \\n**Received:** 6\\\/5\\\/2025 \\n**Completed:** 6\\\/6\\\/2025 \\n\\n**Client** \\nMidwest Extraction Services \\n507-214-3550 \\nLic. #: 20211071 \\n\\n| Total THC | Total THC | Total Cannabinoids |\\n|-----------|-----------|--------------------|\\n| 5.37mg\\\/unit | 0.0% | 0.00% |\\n\\n## Cannabinoids by HPLC-UV\\n\\n| Analyte | LOQ (mg\\\/mL) | Results (%) | Results (mg\\\/unit) |\\n| ------- | ----------- | ----------- | ----------------- |\\n| CBDVA | --- | 0.00000 | 0.00 |\\n| CBDV | --- | 0.00000 | 0.00 |\\n| CBDA | --- | 0.00000 | 0.00 |\\n| CBGA | --- | 0.00000 | 0.00 |\\n| CBG | 0.0003 | 0.00059 | 2.12 |\\n| CBD | 0.0003 | 0.00063 | 2.25 |\\n| THCV | --- | 0.00000 | 0.00 |\\n| THCVA | --- | 0.00000 | 0.00 |\\n| CBN | 0.0003 | 0.00050 | 0.18 |\\n| d9-THC | 0.0003 | 0.00155 | 5.37 |\\n| d8-THC | 0.0003 | 0.00000 | 0.00 |\\n| CBC | --- | 0.00000 | 0.00 |\\n| THCA | --- | 0.00000 | 0.00 |\\n| CBCA | --- | 0.00000 | 0.00 |\\n| Total | 0.003 | | |\\n\\n\\nLOQ = Limit of Quantification; Total THC = d9-THC + (0.877 x THCA); Total CBD = CBD + (0.877 x CBDA)\\n\\n----\\n\\nAnalyst: Johanna Holloway \\nDate: 06\\\/06\\\/2025 \\n\\nFina Analytics \\n2300 Brown Ave Ste 13 \\nWaseca, MN 56093 \\n(507)-214-3550 #6 \\nanalytics@finaLabs.co \\n\\nThis item has been tested by Fina Analytics and the results relate only to the sample tested. Fina Analytics makes no claim as to the efficacy, safety or other risks associated with de or non-detected amounts of substances reported herein. The reported result is based on the sample weight. This Certificate of Analysis shall not be reproduced except in full, without approval of Fina Analytics. Validated testing methodologies with an ISO IEC 17025:2017 accredited quality system was used when an (*) is present on the Certificate of Analysis. Measurement of uncertainty is not used for pass\\\/fail conditions but available upon request.\"\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 "}]}
{"prompt":"\n I have table of dates from a lab report of a cannabis product in markdown format:\n ```markdown\n| Description | Date |\n|---------------|-----------|\n| Collected | 6\/5\/2025 |\n| Received | 6\/5\/2025 |\n| Completed | 6\/6\/2025 |\n| Analyst Date | 06\/06\/2025 |\n``` \n\n Convert all the date values in this table to standard ISO Format (yyyy-mm-dd)\n "}
{"id":"chatcmpl-BwonQipad9oVuZPekZ89ZECV27KP9","object":"chat.completion","created":1753357984,"model":"gpt-4o-2024-08-06","system_fingerprint":"fp_07871e2ad8","choices":[{"index":0,"message":{"role":"assistant","content":"Here is your table with the dates converted to ISO format:\n\n```markdown\n| Description | Date |\n|---------------|------------|\n| Collected | 2025-06-05 |\n| Received | 2025-06-05 |\n| Completed | 2025-06-06 |\n| Analyst Date | 2025-06-06 |\n```"},"finish_reason":"stop"}],"usage":{"prompt_tokens":130,"completion_tokens":78,"total_tokens":208,"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 is your table with the dates converted to ISO format:\n\n```markdown\n| Description | Date |\n|---------------|------------|\n| Collected | 2025-06-05 |\n| Received | 2025-06-05 |\n| Completed | 2025-06-06 |\n| Analyst Date | 2025-06-06 |\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":"\nCertificate of Analysis \n1 of 1\n\n# WILLIE'S REMEDY CHERRY LIMEADE\n\n**Sample ID:** 509F1032.01 \n**Type:** Finished Product \n**Matrix:** Beverage \n**Unit Size:** 357.07 q \n\n**Batch ID:** CCL250606 \n**Collected:** 6\/9\/2025 \n**Received:** 6\/9\/2025 \n**Completed:** 6\/9\/2025 \n\n**Client** \nMidwest Extraction Services \n507-214-3550 \nLic. #: 20211071 \n\n| Total THC | Total THC | Total Cannabinoids |\n|-----------|-----------|--------------------|\n| 5.47 mg\/unit | 0.0% | 0.00% |\n\n## Cannabinoids by HPLC-UV\n\n<table>\n <thead>\n <tr>\n <th>Analyte<\/th>\n <th>LOQ (mg\/mL)<\/th>\n <th>Results (%)<\/th>\n <th>Results (mg\/unit)<\/th>\n <\/tr>\n <\/thead>\n <tbody>\n <tr>\n <td>CBDVA<\/td>\n <td>---<\/td>\n <td>0.00000<\/td>\n <td>0.00<\/td>\n <\/tr>\n <tr>\n <td>CBDV<\/td>\n <td>---<\/td>\n <td>0.00000<\/td>\n <td>0.00<\/td>\n <\/tr>\n <tr>\n <td>CBDA<\/td>\n <td>---<\/td>\n <td>0.00000<\/td>\n <td>0.00<\/td>\n <\/tr>\n <tr>\n <td>CBGA<\/td>\n <td>---<\/td>\n <td>0.00000<\/td>\n <td>0.00<\/td>\n <\/tr>\n <tr>\n <td>CBG<\/td>\n <td>0.0003<\/td>\n <td>0.00063<\/td>\n <td>2.23<\/td>\n <\/tr>\n <tr>\n <td>CBD<\/td>\n <td>0.0003<\/td>\n <td>0.00061<\/td>\n <td>2.18<\/td>\n <\/tr>\n <tr>\n <td>THCV<\/td>\n <td>---<\/td>\n <td>0.00000<\/td>\n <td>0.00<\/td>\n <\/tr>\n <tr>\n <td>THCVA<\/td>\n <td>---<\/td>\n <td>0.00000<\/td>\n <td>0.00<\/td>\n <\/tr>\n <tr>\n <td>CBN<\/td>\n <td>0.0003<\/td>\n <td>0.00000<\/td>\n <td>0.00<\/td>\n <\/tr>\n <tr>\n <td>d9-THC<\/td>\n <td>0.0003<\/td>\n <td>0.00153<\/td>\n <td>5.47<\/td>\n <\/tr>\n <tr>\n <td>d8-THC<\/td>\n <td>0.0003<\/td>\n <td>0.00000<\/td>\n <td>0.00<\/td>\n <\/tr>\n <tr>\n <td>CBC<\/td>\n <td>---<\/td>\n <td>0.00000<\/td>\n <td>0.00<\/td>\n <\/tr>\n <tr>\n <td>THCA<\/td>\n <td>---<\/td>\n <td>0.00000<\/td>\n <td>0.00<\/td>\n <\/tr>\n <tr>\n <td>CBCA<\/td>\n <td>---<\/td>\n <td>0.00000<\/td>\n <td>0.00<\/td>\n <\/tr>\n <tr>\n <td>Total<\/td>\n <td><\/td>\n <td>0.003<\/td>\n <td><\/td>\n <\/tr>\n <\/tbody>\n<\/table>\n\nLOQ = Limit of Quantification; Total THC = d9-THC + (0.877 x THCA); Total CBD = CBD + (0.877 x CBDA)\n\n----\n\nAnalyst: Johanna Holloway \nDate: 6\/09\/2025 \n\n----\n\nFina Analytics \n2300 Brown Ave Ste 130, \nWaseca, MN 56093 \n(507)-214-3550 #6 \nanalytics@finaLabs.co \n\nThis item has been tested by Fina Analytics and the results relate only to the sample tested. Fina Analytics makes no claim as to the efficacy, safety or other risks associated with de or non-detected amounts of substances reported herein. The reported result is based on the sample weight. This Certificate of Analysis shall not be reproduced except in full, without approval of Fina Analytics. Validated testing methodologies with an ISO IEC 17025:2017 accredited quality system was used when (\u2713) is present on the Certificate of Analysis. Measurement of uncertainty is not used for pass\/fail conditions but available upon request.","images":[{"name":"page_1.jpg","height":0,"width":0,"x":0,"y":0,"type":"full_page_screenshot"}],"charts":[],"items":[{"type":"text","value":"Certificate of Analysis \n1 of 1","md":"Certificate of Analysis \n1 of 1"},{"type":"heading","lvl":1,"value":"WILLIE'S REMEDY CHERRY LIMEADE","md":"# WILLIE'S REMEDY CHERRY LIMEADE"},{"type":"text","value":"**Sample ID:** 509F1032.01 \n**Type:** Finished Product \n**Matrix:** Beverage \n**Unit Size:** 357.07 q \n\n**Batch ID:** CCL250606 \n**Collected:** 6\/9\/2025 \n**Received:** 6\/9\/2025 \n**Completed:** 6\/9\/2025 \n\n**Client** \nMidwest Extraction Services \n507-214-3550 \nLic. #: 20211071","md":"**Sample ID:** 509F1032.01 \n**Type:** Finished Product \n**Matrix:** Beverage \n**Unit Size:** 357.07 q \n\n**Batch ID:** CCL250606 \n**Collected:** 6\/9\/2025 \n**Received:** 6\/9\/2025 \n**Completed:** 6\/9\/2025 \n\n**Client** \nMidwest Extraction Services \n507-214-3550 \nLic. #: 20211071"},{"type":"table","rows":[["Total THC","Total THC","Total Cannabinoids"],["5.47 mg\/unit","0.0%","0.00%"]],"md":"| Total THC | Total THC | Total Cannabinoids |\n| ------------ | --------- | ------------------ |\n| 5.47 mg\/unit | 0.0% | 0.00% |","isPerfectTable":false,"csv":"\"Total THC\",\"Total THC\",\"Total Cannabinoids\"\n\"5.47 mg\/unit\",\"0.0%\",\"0.00%\""},{"type":"heading","lvl":2,"value":"Cannabinoids by HPLC-UV","md":"## Cannabinoids by HPLC-UV"},{"type":"table","rows":[["Analyte","LOQ (mg\/mL)","Results (%)","Results (mg\/unit)"],["CBDVA","---","0.00000","0.00"],["CBDV","---","0.00000","0.00"],["CBDA","---","0.00000","0.00"],["CBGA","---","0.00000","0.00"],["CBG","0.0003","0.00063","2.23"],["CBD","0.0003","0.00061","2.18"],["THCV","---","0.00000","0.00"],["THCVA","---","0.00000","0.00"],["CBN","0.0003","0.00000","0.00"],["d9-THC","0.0003","0.00153","5.47"],["d8-THC","0.0003","0.00000","0.00"],["CBC","---","0.00000","0.00"],["THCA","---","0.00000","0.00"],["CBCA","---","0.00000","0.00"],["Total","","0.003",""]],"html":"<table>\n <thead>\n <tr>\n <th>Analyte<\/th>\n <th>LOQ (mg\/mL)<\/th>\n <th>Results (%)<\/th>\n <th>Results (mg\/unit)<\/th>\n <\/tr>\n <\/thead>\n <tbody>\n <tr>\n <td>CBDVA<\/td>\n <td>---<\/td>\n <td>0.00000<\/td>\n <td>0.00<\/td>\n <\/tr>\n <tr>\n <td>CBDV<\/td>\n <td>---<\/td>\n <td>0.00000<\/td>\n <td>0.00<\/td>\n <\/tr>\n <tr>\n <td>CBDA<\/td>\n <td>---<\/td>\n <td>0.00000<\/td>\n <td>0.00<\/td>\n <\/tr>\n <tr>\n <td>CBGA<\/td>\n <td>---<\/td>\n <td>0.00000<\/td>\n <td>0.00<\/td>\n <\/tr>\n <tr>\n <td>CBG<\/td>\n <td>0.0003<\/td>\n <td>0.00063<\/td>\n <td>2.23<\/td>\n <\/tr>\n <tr>\n <td>CBD<\/td>\n <td>0.0003<\/td>\n <td>0.00061<\/td>\n <td>2.18<\/td>\n <\/tr>\n <tr>\n <td>THCV<\/td>\n <td>---<\/td>\n <td>0.00000<\/td>\n <td>0.00<\/td>\n <\/tr>\n <tr>\n <td>THCVA<\/td>\n <td>---<\/td>\n <td>0.00000<\/td>\n <td>0.00<\/td>\n <\/tr>\n <tr>\n <td>CBN<\/td>\n <td>0.0003<\/td>\n <td>0.00000<\/td>\n <td>0.00<\/td>\n <\/tr>\n <tr>\n <td>d9-THC<\/td>\n <td>0.0003<\/td>\n <td>0.00153<\/td>\n <td>5.47<\/td>\n <\/tr>\n <tr>\n <td>d8-THC<\/td>\n <td>0.0003<\/td>\n <td>0.00000<\/td>\n <td>0.00<\/td>\n <\/tr>\n <tr>\n <td>CBC<\/td>\n <td>---<\/td>\n <td>0.00000<\/td>\n <td>0.00<\/td>\n <\/tr>\n <tr>\n <td>THCA<\/td>\n <td>---<\/td>\n <td>0.00000<\/td>\n <td>0.00<\/td>\n <\/tr>\n <tr>\n <td>CBCA<\/td>\n <td>---<\/td>\n <td>0.00000<\/td>\n <td>0.00<\/td>\n <\/tr>\n <tr>\n <td>Total<\/td>\n <td><\/td>\n <td>0.003<\/td>\n <td><\/td>\n <\/tr>\n <\/tbody>\n<\/table>","md":"| Analyte | LOQ (mg\/mL) | Results (%) | Results (mg\/unit) |\n| ------- | ----------- | ----------- | ----------------- |\n| CBDVA | --- | 0.00000 | 0.00 |\n| CBDV | --- | 0.00000 | 0.00 |\n| CBDA | --- | 0.00000 | 0.00 |\n| CBGA | --- | 0.00000 | 0.00 |\n| CBG | 0.0003 | 0.00063 | 2.23 |\n| CBD | 0.0003 | 0.00061 | 2.18 |\n| THCV | --- | 0.00000 | 0.00 |\n| THCVA | --- | 0.00000 | 0.00 |\n| CBN | 0.0003 | 0.00000 | 0.00 |\n| d9-THC | 0.0003 | 0.00153 | 5.47 |\n| d8-THC | 0.0003 | 0.00000 | 0.00 |\n| CBC | --- | 0.00000 | 0.00 |\n| THCA | --- | 0.00000 | 0.00 |\n| CBCA | --- | 0.00000 | 0.00 |\n| Total | | 0.003 | |","isPerfectTable":true,"csv":"\"Analyte\",\"LOQ (mg\/mL)\",\"Results (%)\",\"Results (mg\/unit)\"\n\"CBDVA\",\"---\",\"0.00000\",\"0.00\"\n\"CBDV\",\"---\",\"0.00000\",\"0.00\"\n\"CBDA\",\"---\",\"0.00000\",\"0.00\"\n\"CBGA\",\"---\",\"0.00000\",\"0.00\"\n\"CBG\",\"0.0003\",\"0.00063\",\"2.23\"\n\"CBD\",\"0.0003\",\"0.00061\",\"2.18\"\n\"THCV\",\"---\",\"0.00000\",\"0.00\"\n\"THCVA\",\"---\",\"0.00000\",\"0.00\"\n\"CBN\",\"0.0003\",\"0.00000\",\"0.00\"\n\"d9-THC\",\"0.0003\",\"0.00153\",\"5.47\"\n\"d8-THC\",\"0.0003\",\"0.00000\",\"0.00\"\n\"CBC\",\"---\",\"0.00000\",\"0.00\"\n\"THCA\",\"---\",\"0.00000\",\"0.00\"\n\"CBCA\",\"---\",\"0.00000\",\"0.00\"\n\"Total\",\"\",\"0.003\",\"\""},{"type":"text","value":"LOQ = Limit of Quantification; Total THC = d9-THC + (0.877 x THCA); Total CBD = CBD + (0.877 x CBDA)\n\n----\n\nAnalyst: Johanna Holloway \nDate: 6\/09\/2025 \n\n----\n\nFina Analytics \n2300 Brown Ave Ste 130, \nWaseca, MN 56093 \n(507)-214-3550 #6 \nanalytics@finaLabs.co \n\nThis item has been tested by Fina Analytics and the results relate only to the sample tested. Fina Analytics makes no claim as to the efficacy, safety or other risks associated with de or non-detected amounts of substances reported herein. The reported result is based on the sample weight. This Certificate of Analysis shall not be reproduced except in full, without approval of Fina Analytics. Validated testing methodologies with an ISO IEC 17025:2017 accredited quality system was used when (\u2713) is present on the Certificate of Analysis. Measurement of uncertainty is not used for pass\/fail conditions but available upon request.","md":"LOQ = Limit of Quantification; Total THC = d9-THC + (0.877 x THCA); Total CBD = CBD + (0.877 x CBDA)\n\n----\n\nAnalyst: Johanna Holloway \nDate: 6\/09\/2025 \n\n----\n\nFina Analytics \n2300 Brown Ave Ste 130, \nWaseca, MN 56093 \n(507)-214-3550 #6 \nanalytics@finaLabs.co \n\nThis item has been tested by Fina Analytics and the results relate only to the sample tested. Fina Analytics makes no claim as to the efficacy, safety or other risks associated with de or non-detected amounts of substances reported herein. The reported result is based on the sample weight. This Certificate of Analysis shall not be reproduced except in full, without approval of Fina Analytics. Validated testing methodologies with an ISO IEC 17025:2017 accredited quality system was used when (\u2713) is present on the Certificate of Analysis. Measurement of uncertainty is not used for pass\/fail conditions but available upon request."}],"status":"OK","originalOrientationAngle":0,"links":[],"triggeredAutoMode":false,"parsingMode":"multimodal-openai-gpt4o","structuredData":null,"noStructuredContent":false,"noTextContent":false,"pageHeaderMarkdown":"\nCertificate of Analysis \n1 of 1\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":"\nCertificate of Analysis \n1 of 1\n\n# WILLIE'S REMEDY CHERRY LIMEADE\n\n**Sample ID:** 509F1032.01 \n**Type:** Finished Product \n**Matrix:** Beverage \n**Unit Size:** 357.07 q \n\n**Batch ID:** CCL250606 \n**Collected:** 6\/9\/2025 \n**Received:** 6\/9\/2025 \n**Completed:** 6\/9\/2025 \n\n**Client** \nMidwest Extraction Services \n507-214-3550 \nLic. #: 20211071 \n\n| Total THC | Total THC | Total Cannabinoids |\n|-----------|-----------|--------------------|\n| 5.47 mg\/unit | 0.0% | 0.00% |\n\n## Cannabinoids by HPLC-UV\n\n| Analyte | LOQ (mg\/mL) | Results (%) | Results (mg\/unit) |\n| ------- | ----------- | ----------- | ----------------- |\n| CBDVA | --- | 0.00000 | 0.00 |\n| CBDV | --- | 0.00000 | 0.00 |\n| CBDA | --- | 0.00000 | 0.00 |\n| CBGA | --- | 0.00000 | 0.00 |\n| CBG | 0.0003 | 0.00063 | 2.23 |\n| CBD | 0.0003 | 0.00061 | 2.18 |\n| THCV | --- | 0.00000 | 0.00 |\n| THCVA | --- | 0.00000 | 0.00 |\n| CBN | 0.0003 | 0.00000 | 0.00 |\n| d9-THC | 0.0003 | 0.00153 | 5.47 |\n| d8-THC | 0.0003 | 0.00000 | 0.00 |\n| CBC | --- | 0.00000 | 0.00 |\n| THCA | --- | 0.00000 | 0.00 |\n| CBCA | --- | 0.00000 | 0.00 |\n| Total | | 0.003 | |\n\n\nLOQ = Limit of Quantification; Total THC = d9-THC + (0.877 x THCA); Total CBD = CBD + (0.877 x CBDA)\n\n----\n\nAnalyst: Johanna Holloway \nDate: 6\/09\/2025 \n\n----\n\nFina Analytics \n2300 Brown Ave Ste 130, \nWaseca, MN 56093 \n(507)-214-3550 #6 \nanalytics@finaLabs.co \n\nThis item has been tested by Fina Analytics and the results relate only to the sample tested. Fina Analytics makes no claim as to the efficacy, safety or other risks associated with de or non-detected amounts of substances reported herein. The reported result is based on the sample weight. This Certificate of Analysis shall not be reproduced except in full, without approval of Fina Analytics. Validated testing methodologies with an ISO IEC 17025:2017 accredited quality system was used when (\u2713) is present on the Certificate of Analysis. Measurement of uncertainty is not used for pass\/fail conditions but available upon request.","jobDetails":{"webhook_configurations":null,"job_name":"parse_raw_file_job","partitions":{"file_parsing_id_partition":"6f27778b-4cc3-4f49-a225-7fe22691e1b8"},"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\/6f27778b-4cc3-4f49-a225-7fe22691e1b8\/input.pdf","input_s3_region":"us-east-1","output_s3_path_prefix":"s3:\/\/llama-platform-file-parsing\/fb_iKieaLfVCeTaHV3IzxdANsa7NAD2\/6f27778b-4cc3-4f49-a225-7fe22691e1b8","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":"6.9.2025-unlocked.pdf","original_file_name":"6.9.2025-unlocked.pdf","file_key":"s3:\/\/llama-platform-file-parsing\/fb_iKieaLfVCeTaHV3IzxdANsa7NAD2\/6f27778b-4cc3-4f49-a225-7fe22691e1b8\/input.pdf","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-24T11:53:15.936000Z","project_id":"983c7754-5052-4149-b409-986d83545a50","id":"3e15c6bb-6c6a-4acd-8603-a970edd5c6c5","status":"SUCCESS","error_code":null,"error_message":null,"attempts":1,"started_at":"2025-07-24T11:53:15.989000Z","ended_at":"2025-07-24T11:54:05.064000Z","updated_at":"2025-07-24T11:54:05.074000Z","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":"6.9.2025-unlocked.pdf","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\/6f27778b-4cc3-4f49-a225-7fe22691e1b8\/input.pdf","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\/6f27778b-4cc3-4f49-a225-7fe22691e1b8","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":"3e15c6bb-6c6a-4acd-8603-a970edd5c6c5","jobOutOfQueueTimestamp":1753357996010,"jobCreatedAtTimestamp":1753357996010,"legacy_job_name":"parse_raw_file_job","legacy_file_parsing_id_partition":"6f27778b-4cc3-4f49-a225-7fe22691e1b8","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-24T11:53:15.936000Z","temporal_run_id":null,"temporal_workflow_id":null,"documentAborter":[]},"metadata":{"pdf-pages":1,"pdf-real-pages":1,"pdf-mdLength":2437,"pdf-multimodal-time":46503,"pdf-multimodal-pdf2Image":293,"pdf-inputTokens":1133,"pdf-outputTokens":1160,"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 \"\\nCertificate of Analysis \\n1 of 1\\n\\n# WILLIE'S REMEDY CHERRY LIMEADE\\n\\n**Sample ID:** 509F1032.01 \\n**Type:** Finished Product \\n**Matrix:** Beverage \\n**Unit Size:** 357.07 q \\n\\n**Batch ID:** CCL250606 \\n**Collected:** 6\\\/9\\\/2025 \\n**Received:** 6\\\/9\\\/2025 \\n**Completed:** 6\\\/9\\\/2025 \\n\\n**Client** \\nMidwest Extraction Services \\n507-214-3550 \\nLic. #: 20211071 \\n\\n| Total THC | Total THC | Total Cannabinoids |\\n|-----------|-----------|--------------------|\\n| 5.47 mg\\\/unit | 0.0% | 0.00% |\\n\\n## Cannabinoids by HPLC-UV\\n\\n| Analyte | LOQ (mg\\\/mL) | Results (%) | Results (mg\\\/unit) |\\n| ------- | ----------- | ----------- | ----------------- |\\n| CBDVA | --- | 0.00000 | 0.00 |\\n| CBDV | --- | 0.00000 | 0.00 |\\n| CBDA | --- | 0.00000 | 0.00 |\\n| CBGA | --- | 0.00000 | 0.00 |\\n| CBG | 0.0003 | 0.00063 | 2.23 |\\n| CBD | 0.0003 | 0.00061 | 2.18 |\\n| THCV | --- | 0.00000 | 0.00 |\\n| THCVA | --- | 0.00000 | 0.00 |\\n| CBN | 0.0003 | 0.00000 | 0.00 |\\n| d9-THC | 0.0003 | 0.00153 | 5.47 |\\n| d8-THC | 0.0003 | 0.00000 | 0.00 |\\n| CBC | --- | 0.00000 | 0.00 |\\n| THCA | --- | 0.00000 | 0.00 |\\n| CBCA | --- | 0.00000 | 0.00 |\\n| Total | | 0.003 | |\\n\\n\\nLOQ = Limit of Quantification; Total THC = d9-THC + (0.877 x THCA); Total CBD = CBD + (0.877 x CBDA)\\n\\n----\\n\\nAnalyst: Johanna Holloway \\nDate: 6\\\/09\\\/2025 \\n\\n----\\n\\nFina Analytics \\n2300 Brown Ave Ste 130, \\nWaseca, MN 56093 \\n(507)-214-3550 #6 \\nanalytics@finaLabs.co \\n\\nThis item has been tested by Fina Analytics and the results relate only to the sample tested. Fina Analytics makes no claim as to the efficacy, safety or other risks associated with de or non-detected amounts of substances reported herein. The reported result is based on the sample weight. This Certificate of Analysis shall not be reproduced except in full, without approval of Fina Analytics. Validated testing methodologies with an ISO IEC 17025:2017 accredited quality system was used when (\\u2713) is present on the Certificate of Analysis. Measurement of uncertainty is not used for pass\\\/fail conditions but available upon request.\"\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 \"\\nCertificate of Analysis \\n1 of 1\\n\\n# WILLIE'S REMEDY CHERRY LIMEADE\\n\\n**Sample ID:** 509F1032.01 \\n**Type:** Finished Product \\n**Matrix:** Beverage \\n**Unit Size:** 357.07 q \\n\\n**Batch ID:** CCL250606 \\n**Collected:** 6\\\/9\\\/2025 \\n**Received:** 6\\\/9\\\/2025 \\n**Completed:** 6\\\/9\\\/2025 \\n\\n**Client** \\nMidwest Extraction Services \\n507-214-3550 \\nLic. #: 20211071 \\n\\n| Total THC | Total THC | Total Cannabinoids |\\n|-----------|-----------|--------------------|\\n| 5.47 mg\\\/unit | 0.0% | 0.00% |\\n\\n## Cannabinoids by HPLC-UV\\n\\n| Analyte | LOQ (mg\\\/mL) | Results (%) | Results (mg\\\/unit) |\\n| ------- | ----------- | ----------- | ----------------- |\\n| CBDVA | --- | 0.00000 | 0.00 |\\n| CBDV | --- | 0.00000 | 0.00 |\\n| CBDA | --- | 0.00000 | 0.00 |\\n| CBGA | --- | 0.00000 | 0.00 |\\n| CBG | 0.0003 | 0.00063 | 2.23 |\\n| CBD | 0.0003 | 0.00061 | 2.18 |\\n| THCV | --- | 0.00000 | 0.00 |\\n| THCVA | --- | 0.00000 | 0.00 |\\n| CBN | 0.0003 | 0.00000 | 0.00 |\\n| d9-THC | 0.0003 | 0.00153 | 5.47 |\\n| d8-THC | 0.0003 | 0.00000 | 0.00 |\\n| CBC | --- | 0.00000 | 0.00 |\\n| THCA | --- | 0.00000 | 0.00 |\\n| CBCA | --- | 0.00000 | 0.00 |\\n| Total | | 0.003 | |\\n\\n\\nLOQ = Limit of Quantification; Total THC = d9-THC + (0.877 x THCA); Total CBD = CBD + (0.877 x CBDA)\\n\\n----\\n\\nAnalyst: Johanna Holloway \\nDate: 6\\\/09\\\/2025 \\n\\n----\\n\\nFina Analytics \\n2300 Brown Ave Ste 130, \\nWaseca, MN 56093 \\n(507)-214-3550 #6 \\nanalytics@finaLabs.co \\n\\nThis item has been tested by Fina Analytics and the results relate only to the sample tested. Fina Analytics makes no claim as to the efficacy, safety or other risks associated with de or non-detected amounts of substances reported herein. The reported result is based on the sample weight. This Certificate of Analysis shall not be reproduced except in full, without approval of Fina Analytics. Validated testing methodologies with an ISO IEC 17025:2017 accredited quality system was used when (\\u2713) is present on the Certificate of Analysis. Measurement of uncertainty is not used for pass\\\/fail conditions but available upon request.\"\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":"user","content":"\n This is a markdown for a cannabis product lab report:\n ---START MARKDOWN HERE---\n \"\\nCertificate of Analysis \\n1 of 1\\n\\n# WILLIE'S REMEDY CHERRY LIMEADE\\n\\n**Sample ID:** 509F1032.01 \\n**Type:** Finished Product \\n**Matrix:** Beverage \\n**Unit Size:** 357.07 q \\n\\n**Batch ID:** CCL250606 \\n**Collected:** 6\\\/9\\\/2025 \\n**Received:** 6\\\/9\\\/2025 \\n**Completed:** 6\\\/9\\\/2025 \\n\\n**Client** \\nMidwest Extraction Services \\n507-214-3550 \\nLic. #: 20211071 \\n\\n| Total THC | Total THC | Total Cannabinoids |\\n|-----------|-----------|--------------------|\\n| 5.47 mg\\\/unit | 0.0% | 0.00% |\\n\\n## Cannabinoids by HPLC-UV\\n\\n| Analyte | LOQ (mg\\\/mL) | Results (%) | Results (mg\\\/unit) |\\n| ------- | ----------- | ----------- | ----------------- |\\n| CBDVA | --- | 0.00000 | 0.00 |\\n| CBDV | --- | 0.00000 | 0.00 |\\n| CBDA | --- | 0.00000 | 0.00 |\\n| CBGA | --- | 0.00000 | 0.00 |\\n| CBG | 0.0003 | 0.00063 | 2.23 |\\n| CBD | 0.0003 | 0.00061 | 2.18 |\\n| THCV | --- | 0.00000 | 0.00 |\\n| THCVA | --- | 0.00000 | 0.00 |\\n| CBN | 0.0003 | 0.00000 | 0.00 |\\n| d9-THC | 0.0003 | 0.00153 | 5.47 |\\n| d8-THC | 0.0003 | 0.00000 | 0.00 |\\n| CBC | --- | 0.00000 | 0.00 |\\n| THCA | --- | 0.00000 | 0.00 |\\n| CBCA | --- | 0.00000 | 0.00 |\\n| Total | | 0.003 | |\\n\\n\\nLOQ = Limit of Quantification; Total THC = d9-THC + (0.877 x THCA); Total CBD = CBD + (0.877 x CBDA)\\n\\n----\\n\\nAnalyst: Johanna Holloway \\nDate: 6\\\/09\\\/2025 \\n\\n----\\n\\nFina Analytics \\n2300 Brown Ave Ste 130, \\nWaseca, MN 56093 \\n(507)-214-3550 #6 \\nanalytics@finaLabs.co \\n\\nThis item has been tested by Fina Analytics and the results relate only to the sample tested. Fina Analytics makes no claim as to the efficacy, safety or other risks associated with de or non-detected amounts of substances reported herein. The reported result is based on the sample weight. This Certificate of Analysis shall not be reproduced except in full, without approval of Fina Analytics. Validated testing methodologies with an ISO IEC 17025:2017 accredited quality system was used when (\\u2713) is present on the Certificate of Analysis. Measurement of uncertainty is not used for pass\\\/fail conditions but available upon request.\"\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 "}]}
{"prompt":"\n I have table of dates from a lab report of a cannabis product in markdown format:\n ```\n| Date | Description |\n|------------|----------------------|\n| 6\/9\/2025 | Collected |\n| 6\/9\/2025 | Received |\n| 6\/9\/2025 | Completed |\n| 6\/09\/2025 | Analyst Date |\n``` \n\n Convert all the date values in this table to standard ISO Format (yyyy-mm-dd)\n "}
{"id":"chatcmpl-BwoocdD5QS7PpMwCoIyCEJ5wKwDRf","object":"chat.completion","created":1753358058,"model":"gpt-4o-2024-08-06","system_fingerprint":"fp_07871e2ad8","choices":[{"index":0,"message":{"role":"assistant","content":"Sure, here's the table with all date values converted to ISO format:\n\n```\n| Date | Description |\n|------------|----------------------|\n| 2025-06-09 | Collected |\n| 2025-06-09 | Received |\n| 2025-06-09 | Completed |\n| 2025-06-09 | Analyst Date |\n```"},"finish_reason":"stop"}],"usage":{"prompt_tokens":130,"completion_tokens":80,"total_tokens":210,"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 Sure, here's the table with all date values converted to ISO format:\n\n```\n| Date | Description |\n|------------|----------------------|\n| 2025-06-09 | Collected |\n| 2025-06-09 | Received |\n| 2025-06-09 | Completed |\n| 2025-06-09 | Analyst Date |\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":"\nCTLA \nContract Testing Laboratories of America\n\n# Certificate of Analysis\n\n## Sample Information\n\n- **CTLA ID:** 139603\n- **Date Received:** 6\/10\/2025\n- **Sample Name:** Willie's Remedy + THC Infused 750mL\n- **Lot Number:** BTL250506\n- **Customer:** Big Brands Utah\n\n<table>\n <thead>\n <tr>\n <th>Analysis<\/th>\n <th>Method<\/th>\n <th>MDL<\/th>\n <th>Specification<\/th>\n <th>Result<\/th>\n <th>Units<\/th>\n <\/tr>\n <\/thead>\n <tbody>\n <tr>\n <td rowspan=\"7\">Rapid Complete Micro<\/td>\n <td>Total Aerobic Microbial Count (USP)<\/td>\n <td>USP <2021><\/td>\n <td>100<\/td>\n <td>Report<\/td>\n <td>cfu\/g<\/td>\n <\/tr>\n <tr>\n <td>Total Coliforms (BAM) (MOD)<\/td>\n <td>BAM CH. 4 (MOD)<\/td>\n <td>10<\/td>\n <td>Report<\/td>\n <td>cfu\/g<\/td>\n <\/tr>\n <tr>\n <td>E.Coli BAM (MOD)<\/td>\n <td>BAM CH. 4 (MOD)<\/td>\n <td><\/td>\n <td>Report<\/td>\n <td><\/td>\n <\/tr>\n <tr>\n <td>Salmonella<\/td>\n <td>USP <2022><\/td>\n <td><\/td>\n <td>Report<\/td>\n <td><\/td>\n <\/tr>\n <tr>\n <td>Staphylococcus aureus <2022><\/td>\n <td>USP <2022><\/td>\n <td><\/td>\n <td>Report<\/td>\n <td><\/td>\n <\/tr>\n <tr>\n <td>Rapid Yeast and Mold<\/td>\n <td>AOAC 2014.05<\/td>\n <td>10<\/td>\n <td>Report<\/td>\n <td>cfu\/g<\/td>\n <\/tr>\n <tr>\n <td>\u03949-THC<\/td>\n <td>HPLC<\/td>\n <td>Report<\/td>\n <td>0.118<\/td>\n <td>mg\/g<\/td>\n <\/tr>\n <\/tbody>\n<\/table>\n\n- **Serving = 1.5 fl oz (44mL)**\n- **DB 06\/26**\n\n**PRELIMINARY REPORT:** this report is being provided for your convenience. Completed results are included above, any tests without results are still in progress and a final COA will be provided once all testing is completed.\n\n----\n\nSpecifications provided by the Customer. Results with an asterisk (*) denote Specifications should be reviewed by the Customer. This Certificate of Analysis represents data for the sample submitted and does not constitute a guarantee of quality for the entire product from which it was taken. These results are provided for the benefit of the Customer. MDL = Method Detection Limit. This document is not to be altered or reproduced except by the original authorizing body (CTLA).\n\n6\/10\/2025 \n[Signature] \nQuality Manager\n\n151 E 3450 N, Ste 202, Spanish Fork, UT 84660 (385) 477-4999 Page 1 of 0\n","images":[{"name":"page_1.jpg","height":0,"width":0,"x":0,"y":0,"type":"full_page_screenshot"}],"charts":[],"items":[{"type":"text","value":"CTLA \nContract Testing Laboratories of America","md":"CTLA \nContract Testing Laboratories of America"},{"type":"heading","lvl":1,"value":"Certificate of Analysis","md":"# Certificate of Analysis"},{"type":"heading","lvl":2,"value":"Sample Information","md":"## Sample Information"},{"type":"text","value":"- **CTLA ID:** 139603\n- **Date Received:** 6\/10\/2025\n- **Sample Name:** Willie's Remedy + THC Infused 750mL\n- **Lot Number:** BTL250506\n- **Customer:** Big Brands Utah","md":"- **CTLA ID:** 139603\n- **Date Received:** 6\/10\/2025\n- **Sample Name:** Willie's Remedy + THC Infused 750mL\n- **Lot Number:** BTL250506\n- **Customer:** Big Brands Utah"},{"type":"table","rows":[["Analysis","Method","MDL","Specification","Result","Units"],["Rapid Complete Micro","Total Aerobic Microbial Count (USP)","USP <2021>","100","Report","cfu\/g"],["","Total Coliforms (BAM) (MOD)","BAM CH. 4 (MOD)","10","Report","cfu\/g"],["","E.Coli BAM (MOD)","BAM CH. 4 (MOD)","","Report",""],["","Salmonella","USP <2022>","","Report",""],["","Staphylococcus aureus <2022>","USP <2022>","","Report",""],["","Rapid Yeast and Mold","AOAC 2014.05","10","Report","cfu\/g"],["","\u03949-THC","HPLC","Report","0.118","mg\/g"]],"html":"<table>\n <thead>\n <tr>\n <th>Analysis<\/th>\n <th>Method<\/th>\n <th>MDL<\/th>\n <th>Specification<\/th>\n <th>Result<\/th>\n <th>Units<\/th>\n <\/tr>\n <\/thead>\n <tbody>\n <tr>\n <td rowspan=\"7\">Rapid Complete Micro<\/td>\n <td>Total Aerobic Microbial Count (USP)<\/td>\n <td>USP <2021><\/td>\n <td>100<\/td>\n <td>Report<\/td>\n <td>cfu\/g<\/td>\n <\/tr>\n <tr>\n <td>Total Coliforms (BAM) (MOD)<\/td>\n <td>BAM CH. 4 (MOD)<\/td>\n <td>10<\/td>\n <td>Report<\/td>\n <td>cfu\/g<\/td>\n <\/tr>\n <tr>\n <td>E.Coli BAM (MOD)<\/td>\n <td>BAM CH. 4 (MOD)<\/td>\n <td><\/td>\n <td>Report<\/td>\n <td><\/td>\n <\/tr>\n <tr>\n <td>Salmonella<\/td>\n <td>USP <2022><\/td>\n <td><\/td>\n <td>Report<\/td>\n <td><\/td>\n <\/tr>\n <tr>\n <td>Staphylococcus aureus <2022><\/td>\n <td>USP <2022><\/td>\n <td><\/td>\n <td>Report<\/td>\n <td><\/td>\n <\/tr>\n <tr>\n <td>Rapid Yeast and Mold<\/td>\n <td>AOAC 2014.05<\/td>\n <td>10<\/td>\n <td>Report<\/td>\n <td>cfu\/g<\/td>\n <\/tr>\n <tr>\n <td>\u03949-THC<\/td>\n <td>HPLC<\/td>\n <td>Report<\/td>\n <td>0.118<\/td>\n <td>mg\/g<\/td>\n <\/tr>\n <\/tbody>\n<\/table>","md":"| Analysis | Method | MDL | Specification | Result | Units |\n| -------------------- | ----------------------------------- | --------------- | ------------- | ------ | ----- |\n| Rapid Complete Micro | Total Aerobic Microbial Count (USP) | USP <2021> | 100 | Report | cfu\/g |\n| | Total Coliforms (BAM) (MOD) | BAM CH. 4 (MOD) | 10 | Report | cfu\/g |\n| | E.Coli BAM (MOD) | BAM CH. 4 (MOD) | | Report | |\n| | Salmonella | USP <2022> | | Report | |\n| | Staphylococcus aureus <2022> | USP <2022> | | Report | |\n| | Rapid Yeast and Mold | AOAC 2014.05 | 10 | Report | cfu\/g |\n| | \u03949-THC | HPLC | Report | 0.118 | mg\/g |","isPerfectTable":false,"csv":"\"Analysis\",\"Method\",\"MDL\",\"Specification\",\"Result\",\"Units\"\n\"Rapid Complete Micro\",\"Total Aerobic Microbial Count (USP)\",\"USP <2021>\",\"100\",\"Report\",\"cfu\/g\"\n\"\",\"Total Coliforms (BAM) (MOD)\",\"BAM CH. 4 (MOD)\",\"10\",\"Report\",\"cfu\/g\"\n\"\",\"E.Coli BAM (MOD)\",\"BAM CH. 4 (MOD)\",\"\",\"Report\",\"\"\n\"\",\"Salmonella\",\"USP <2022>\",\"\",\"Report\",\"\"\n\"\",\"Staphylococcus aureus <2022>\",\"USP <2022>\",\"\",\"Report\",\"\"\n\"\",\"Rapid Yeast and Mold\",\"AOAC 2014.05\",\"10\",\"Report\",\"cfu\/g\"\n\"\",\"\u03949-THC\",\"HPLC\",\"Report\",\"0.118\",\"mg\/g\""},{"type":"text","value":"- **Serving = 1.5 fl oz (44mL)**\n- **DB 06\/26**\n\n**PRELIMINARY REPORT:** this report is being provided for your convenience. Completed results are included above, any tests without results are still in progress and a final COA will be provided once all testing is completed.\n\n----\n\nSpecifications provided by the Customer. Results with an asterisk (*) denote Specifications should be reviewed by the Customer. This Certificate of Analysis represents data for the sample submitted and does not constitute a guarantee of quality for the entire product from which it was taken. These results are provided for the benefit of the Customer. MDL = Method Detection Limit. This document is not to be altered or reproduced except by the original authorizing body (CTLA).\n\n6\/10\/2025 \n[Signature] \nQuality Manager\n\n151 E 3450 N, Ste 202, Spanish Fork, UT 84660 (385) 477-4999 Page 1 of 0","md":"- **Serving = 1.5 fl oz (44mL)**\n- **DB 06\/26**\n\n**PRELIMINARY REPORT:** this report is being provided for your convenience. Completed results are included above, any tests without results are still in progress and a final COA will be provided once all testing is completed.\n\n----\n\nSpecifications provided by the Customer. Results with an asterisk (*) denote Specifications should be reviewed by the Customer. This Certificate of Analysis represents data for the sample submitted and does not constitute a guarantee of quality for the entire product from which it was taken. These results are provided for the benefit of the Customer. MDL = Method Detection Limit. This document is not to be altered or reproduced except by the original authorizing body (CTLA).\n\n6\/10\/2025 \n[Signature] \nQuality Manager\n\n151 E 3450 N, Ste 202, Spanish Fork, UT 84660 (385) 477-4999 Page 1 of 0"}],"status":"OK","originalOrientationAngle":0,"links":[],"triggeredAutoMode":false,"parsingMode":"multimodal-openai-gpt4o","structuredData":null,"noStructuredContent":false,"noTextContent":false,"pageHeaderMarkdown":"\nCTLA \nContract Testing Laboratories of America\n","pageFooterMarkdown":"\n151 E 3450 N, Ste 202, Spanish Fork, UT 84660 (385) 477-4999 Page 1 of 0\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":"\nCTLA \nContract Testing Laboratories of America\n\n# Certificate of Analysis\n\n## Sample Information\n\n- **CTLA ID:** 139603\n- **Date Received:** 6\/10\/2025\n- **Sample Name:** Willie's Remedy + THC Infused 750mL\n- **Lot Number:** BTL250506\n- **Customer:** Big Brands Utah\n\n| Analysis | Method | MDL | Specification | Result | Units |\n| -------------------- | ----------------------------------- | --------------- | ------------- | ------ | ----- |\n| Rapid Complete Micro | Total Aerobic Microbial Count (USP) | USP <2021> | 100 | Report | cfu\/g |\n| | Total Coliforms (BAM) (MOD) | BAM CH. 4 (MOD) | 10 | Report | cfu\/g |\n| | E.Coli BAM (MOD) | BAM CH. 4 (MOD) | | Report | |\n| | Salmonella | USP <2022> | | Report | |\n| | Staphylococcus aureus <2022> | USP <2022> | | Report | |\n| | Rapid Yeast and Mold | AOAC 2014.05 | 10 | Report | cfu\/g |\n| | \u03949-THC | HPLC | Report | 0.118 | mg\/g |\n\n\n- **Serving = 1.5 fl oz (44mL)**\n- **DB 06\/26**\n\n**PRELIMINARY REPORT:** this report is being provided for your convenience. Completed results are included above, any tests without results are still in progress and a final COA will be provided once all testing is completed.\n\n----\n\nSpecifications provided by the Customer. Results with an asterisk (*) denote Specifications should be reviewed by the Customer. This Certificate of Analysis represents data for the sample submitted and does not constitute a guarantee of quality for the entire product from which it was taken. These results are provided for the benefit of the Customer. MDL = Method Detection Limit. This document is not to be altered or reproduced except by the original authorizing body (CTLA).\n\n6\/10\/2025 \n[Signature] \nQuality Manager\n\n151 E 3450 N, Ste 202, Spanish Fork, UT 84660 (385) 477-4999 Page 1 of 0\n","jobDetails":{"webhook_configurations":null,"job_name":"parse_raw_file_job","partitions":{"file_parsing_id_partition":"a8b81260-4422-4fcc-b300-8ec28d6edd03"},"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\/a8b81260-4422-4fcc-b300-8ec28d6edd03\/input.pdf","input_s3_region":"us-east-1","output_s3_path_prefix":"s3:\/\/llama-platform-file-parsing\/fb_iKieaLfVCeTaHV3IzxdANsa7NAD2\/a8b81260-4422-4fcc-b300-8ec28d6edd03","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":"6.10.2025-unlocked.pdf","original_file_name":"6.10.2025-unlocked.pdf","file_key":"s3:\/\/llama-platform-file-parsing\/fb_iKieaLfVCeTaHV3IzxdANsa7NAD2\/a8b81260-4422-4fcc-b300-8ec28d6edd03\/input.pdf","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-24T11:54:23.723000Z","project_id":"983c7754-5052-4149-b409-986d83545a50","id":"60799f0d-8a9a-4de8-b749-593266a658a7","status":"SUCCESS","error_code":null,"error_message":null,"attempts":1,"started_at":"2025-07-24T11:54:23.775000Z","ended_at":"2025-07-24T11:54:48.548000Z","updated_at":"2025-07-24T11:54:48.558000Z","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":"6.10.2025-unlocked.pdf","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\/a8b81260-4422-4fcc-b300-8ec28d6edd03\/input.pdf","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\/a8b81260-4422-4fcc-b300-8ec28d6edd03","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":"60799f0d-8a9a-4de8-b749-593266a658a7","jobOutOfQueueTimestamp":1753358063796,"jobCreatedAtTimestamp":1753358063796,"legacy_job_name":"parse_raw_file_job","legacy_file_parsing_id_partition":"a8b81260-4422-4fcc-b300-8ec28d6edd03","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-24T11:54:23.723000Z","temporal_run_id":null,"temporal_workflow_id":null,"documentAborter":[]},"metadata":{"pdf-pages":1,"pdf-real-pages":1,"pdf-mdLength":2176,"pdf-multimodal-time":22245,"pdf-multimodal-pdf2Image":309,"pdf-inputTokens":1133,"pdf-outputTokens":794,"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 \"\\nCTLA \\nContract Testing Laboratories of America\\n\\n# Certificate of Analysis\\n\\n## Sample Information\\n\\n- **CTLA ID:** 139603\\n- **Date Received:** 6\\\/10\\\/2025\\n- **Sample Name:** Willie's Remedy + THC Infused 750mL\\n- **Lot Number:** BTL250506\\n- **Customer:** Big Brands Utah\\n\\n| Analysis | Method | MDL | Specification | Result | Units |\\n| -------------------- | ----------------------------------- | --------------- | ------------- | ------ | ----- |\\n| Rapid Complete Micro | Total Aerobic Microbial Count (USP) | USP <2021> | 100 | Report | cfu\\\/g |\\n| | Total Coliforms (BAM) (MOD) | BAM CH. 4 (MOD) | 10 | Report | cfu\\\/g |\\n| | E.Coli BAM (MOD) | BAM CH. 4 (MOD) | | Report | |\\n| | Salmonella | USP <2022> | | Report | |\\n| | Staphylococcus aureus <2022> | USP <2022> | | Report | |\\n| | Rapid Yeast and Mold | AOAC 2014.05 | 10 | Report | cfu\\\/g |\\n| | \\u03949-THC | HPLC | Report | 0.118 | mg\\\/g |\\n\\n\\n- **Serving = 1.5 fl oz (44mL)**\\n- **DB 06\\\/26**\\n\\n**PRELIMINARY REPORT:** this report is being provided for your convenience. Completed results are included above, any tests without results are still in progress and a final COA will be provided once all testing is completed.\\n\\n----\\n\\nSpecifications provided by the Customer. Results with an asterisk (*) denote Specifications should be reviewed by the Customer. This Certificate of Analysis represents data for the sample submitted and does not constitute a guarantee of quality for the entire product from which it was taken. These results are provided for the benefit of the Customer. MDL = Method Detection Limit. This document is not to be altered or reproduced except by the original authorizing body (CTLA).\\n\\n6\\\/10\\\/2025 \\n[Signature] \\nQuality Manager\\n\\n151 E 3450 N, Ste 202, Spanish Fork, UT 84660 (385) 477-4999 Page 1 of 0\\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 \"\\nCTLA \\nContract Testing Laboratories of America\\n\\n# Certificate of Analysis\\n\\n## Sample Information\\n\\n- **CTLA ID:** 139603\\n- **Date Received:** 6\\\/10\\\/2025\\n- **Sample Name:** Willie's Remedy + THC Infused 750mL\\n- **Lot Number:** BTL250506\\n- **Customer:** Big Brands Utah\\n\\n| Analysis | Method | MDL | Specification | Result | Units |\\n| -------------------- | ----------------------------------- | --------------- | ------------- | ------ | ----- |\\n| Rapid Complete Micro | Total Aerobic Microbial Count (USP) | USP <2021> | 100 | Report | cfu\\\/g |\\n| | Total Coliforms (BAM) (MOD) | BAM CH. 4 (MOD) | 10 | Report | cfu\\\/g |\\n| | E.Coli BAM (MOD) | BAM CH. 4 (MOD) | | Report | |\\n| | Salmonella | USP <2022> | | Report | |\\n| | Staphylococcus aureus <2022> | USP <2022> | | Report | |\\n| | Rapid Yeast and Mold | AOAC 2014.05 | 10 | Report | cfu\\\/g |\\n| | \\u03949-THC | HPLC | Report | 0.118 | mg\\\/g |\\n\\n\\n- **Serving = 1.5 fl oz (44mL)**\\n- **DB 06\\\/26**\\n\\n**PRELIMINARY REPORT:** this report is being provided for your convenience. Completed results are included above, any tests without results are still in progress and a final COA will be provided once all testing is completed.\\n\\n----\\n\\nSpecifications provided by the Customer. Results with an asterisk (*) denote Specifications should be reviewed by the Customer. This Certificate of Analysis represents data for the sample submitted and does not constitute a guarantee of quality for the entire product from which it was taken. These results are provided for the benefit of the Customer. MDL = Method Detection Limit. This document is not to be altered or reproduced except by the original authorizing body (CTLA).\\n\\n6\\\/10\\\/2025 \\n[Signature] \\nQuality Manager\\n\\n151 E 3450 N, Ste 202, Spanish Fork, UT 84660 (385) 477-4999 Page 1 of 0\\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 : ```markdown\n# Cannabinoids and Potency Results\n\n| Cannabinoid | Method | Result | Units |\n|-------------|--------|--------|------------|\n| \u03949-THC | HPLC | 0.118 | mg\/g |\n```\n.\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 \"\\nCTLA \\nContract Testing Laboratories of America\\n\\n# Certificate of Analysis\\n\\n## Sample Information\\n\\n- **CTLA ID:** 139603\\n- **Date Received:** 6\\\/10\\\/2025\\n- **Sample Name:** Willie's Remedy + THC Infused 750mL\\n- **Lot Number:** BTL250506\\n- **Customer:** Big Brands Utah\\n\\n| Analysis | Method | MDL | Specification | Result | Units |\\n| -------------------- | ----------------------------------- | --------------- | ------------- | ------ | ----- |\\n| Rapid Complete Micro | Total Aerobic Microbial Count (USP) | USP <2021> | 100 | Report | cfu\\\/g |\\n| | Total Coliforms (BAM) (MOD) | BAM CH. 4 (MOD) | 10 | Report | cfu\\\/g |\\n| | E.Coli BAM (MOD) | BAM CH. 4 (MOD) | | Report | |\\n| | Salmonella | USP <2022> | | Report | |\\n| | Staphylococcus aureus <2022> | USP <2022> | | Report | |\\n| | Rapid Yeast and Mold | AOAC 2014.05 | 10 | Report | cfu\\\/g |\\n| | \\u03949-THC | HPLC | Report | 0.118 | mg\\\/g |\\n\\n\\n- **Serving = 1.5 fl oz (44mL)**\\n- **DB 06\\\/26**\\n\\n**PRELIMINARY REPORT:** this report is being provided for your convenience. Completed results are included above, any tests without results are still in progress and a final COA will be provided once all testing is completed.\\n\\n----\\n\\nSpecifications provided by the Customer. Results with an asterisk (*) denote Specifications should be reviewed by the Customer. This Certificate of Analysis represents data for the sample submitted and does not constitute a guarantee of quality for the entire product from which it was taken. These results are provided for the benefit of the Customer. MDL = Method Detection Limit. This document is not to be altered or reproduced except by the original authorizing body (CTLA).\\n\\n6\\\/10\\\/2025 \\n[Signature] \\nQuality Manager\\n\\n151 E 3450 N, Ste 202, Spanish Fork, UT 84660 (385) 477-4999 Page 1 of 0\\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-BwopJ1ieFkTK9OoazpPeyhG4dmUbx","object":"chat.completion","created":1753358101,"model":"gpt-4o-2024-08-06","system_fingerprint":"fp_a288987b44","choices":[{"index":0,"message":{"role":"assistant","content":"```markdown\n| Date | Description |\n|------------|----------------------|\n| 6\/10\/2025 | Date Received |\n| 6\/26 | DB |\n| 6\/10\/2025 | Date of Report |\n```\n"},"finish_reason":"stop"}],"usage":{"prompt_tokens":628,"completion_tokens":57,"total_tokens":685,"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}}}