{"json":{"pages":[{"page":1,"md":"This image shows a stylized UFO shape in purple with a green outline. Inside the UFO, there is a green cannabis leaf.","images":[{"name":"page_1.jpg","height":0,"width":0,"x":0,"y":0,"type":"full_page_screenshot"}],"charts":[],"items":[{"type":"text","value":"This image shows a stylized UFO shape in purple with a green outline. Inside the UFO, there is a green cannabis leaf.","md":"This image shows a stylized UFO shape in purple with a green outline. Inside the UFO, there is a green cannabis leaf."}],"status":"OK","originalOrientationAngle":0,"links":[],"triggeredAutoMode":false,"parsingMode":"multimodal-openai-gpt4o","structuredData":null,"noStructuredContent":false,"noTextContent":false,"pageHeaderMarkdown":"","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":"This image shows a stylized UFO shape in purple with a green outline. Inside the UFO, there is a green cannabis leaf.","jobDetails":{"webhook_configurations":null,"job_name":"parse_raw_file_job","partitions":{"file_parsing_id_partition":"38b2ae25-116a-4b4d-878b-f93e261c1915"},"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\/38b2ae25-116a-4b4d-878b-f93e261c1915\/input.png","input_s3_region":"us-east-1","output_s3_path_prefix":"s3:\/\/llama-platform-file-parsing\/fb_iKieaLfVCeTaHV3IzxdANsa7NAD2\/38b2ae25-116a-4b4d-878b-f93e261c1915","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":"ActiveTHCAnalysisReport.png","original_file_name":"ActiveTHCAnalysisReport.png","file_key":"s3:\/\/llama-platform-file-parsing\/fb_iKieaLfVCeTaHV3IzxdANsa7NAD2\/38b2ae25-116a-4b4d-878b-f93e261c1915\/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:42:09.803000Z","project_id":"983c7754-5052-4149-b409-986d83545a50","id":"f344a708-e8cf-42a3-a478-b4aa366e929c","status":"SUCCESS","error_code":null,"error_message":null,"attempts":1,"started_at":"2025-07-25T03:42:09.847000Z","ended_at":"2025-07-25T03:42:15.103000Z","updated_at":"2025-07-25T03:42:15.109000Z","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":"ActiveTHCAnalysisReport.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\/38b2ae25-116a-4b4d-878b-f93e261c1915\/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\/38b2ae25-116a-4b4d-878b-f93e261c1915","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":"f344a708-e8cf-42a3-a478-b4aa366e929c","jobOutOfQueueTimestamp":1753414929864,"jobCreatedAtTimestamp":1753414929864,"legacy_job_name":"parse_raw_file_job","legacy_file_parsing_id_partition":"38b2ae25-116a-4b4d-878b-f93e261c1915","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:42:09.803000Z","temporal_run_id":null,"temporal_workflow_id":null,"documentAborter":[]},"metadata":{"pdf-pages":1,"pdf-real-pages":1,"pdf-mdLength":117,"pdf-multimodal-time":2708,"pdf-multimodal-pdf2Image":274,"pdf-inputTokens":1473,"pdf-outputTokens":26,"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 \"This image shows a stylized UFO shape in purple with a green outline. Inside the UFO, there is a green cannabis leaf.\"\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 \"This image shows a stylized UFO shape in purple with a green outline. Inside the UFO, there is a green cannabis leaf.\"\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 "}]}
{"id":"chatcmpl-Bx3c7t5lyy2TcrMBXoSWKZNCoQOxg","object":"chat.completion","created":1753414943,"model":"gpt-4o-2024-11-20","choices":[{"index":0,"message":{"role":"assistant","content":"Unfortunately, the provided text does not include any cannabinoid data or potency results for me to extract and format into a table. If you provide the relevant data (e.g., cannabinoid concentrations, sample ID, etc.), I will happily create a cannabinoids and potency results table for you in markdown format!"},"finish_reason":"stop"}],"usage":{"prompt_tokens":101,"completion_tokens":60,"total_tokens":161,"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 cannabis lab analyst"},{"role":"user","content":"\n I have the markdown of a cannabis product lab results : Unfortunately, the provided text does not include any cannabinoid data or potency results for me to extract and format into a table. If you provide the relevant data (e.g., cannabinoid concentrations, sample ID, etc.), I will happily create a cannabinoids and potency results table for you in markdown format!.\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 \"This image shows a stylized UFO shape in purple with a green outline. Inside the UFO, there is a green cannabis leaf.\"\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-Bx3c9uHnApGGQg2cbiP5roWo182cZ","object":"chat.completion","created":1753414945,"model":"gpt-4o-2024-11-20","choices":[{"index":0,"message":{"role":"assistant","content":"There are no explicit date texts in the provided lab report markdown. Since I only extract dates and cannot derive them, there are no dates to provide in the output table.\n\nIf you'd like to clarify or provide another section with specific dates, I\u2019d be happy to assist!"},"finish_reason":"stop"}],"usage":{"prompt_tokens":103,"completion_tokens":54,"total_tokens":157,"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":"\n I have table of dates from a lab report of a cannabis product in markdown format:\n There are no explicit date texts in the provided lab report markdown. Since I only extract dates and cannot derive them, there are no dates to provide in the output table.\n\nIf you'd like to clarify or provide another section with specific dates, I\u2019d be happy to assist! \n\n Convert all the date values in this table to standard ISO Format (yyyy-mm-dd)\n "}
{"id":"chatcmpl-Bx3cBy1nHMW1c0tUz5wzELrxIKJAL","object":"chat.completion","created":1753414947,"model":"gpt-4o-2024-11-20","choices":[{"index":0,"message":{"role":"assistant","content":"As there are no explicit or visible date texts within the provided lab report markdown, there are no dates to convert to ISO format. If you can provide specific dates or share a section of the report that includes recognizable date values, I will gladly help in converting them! Let me know how you\u2019d like to proceed."},"finish_reason":"stop"}],"usage":{"prompt_tokens":115,"completion_tokens":63,"total_tokens":178,"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 As there are no explicit or visible date texts within the provided lab report markdown, there are no dates to convert to ISO format. If you can provide specific dates or share a section of the report that includes recognizable date values, I will gladly help in converting them! Let me know how you\u2019d like to proceed. \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}}}
{"prompt":[{"role":"system","content":"You are an ai that can match cannabis product names to their lab report based on the product name and lab report matching name"},{"role":"user","content":"\n I have an array of product names as follows\n [\"600mg CBD For Dogs Florida\"]\n\n I also have an array of lab reports of those products. \n This data is an array of objects where each object is a lab report, the object has the lab report name, lab report matching name and its url.\n The matching name of the lab report is similar to atleast one of the products given above. \n Match the product names to the correct lab report based on the product name and matching name.\n Give me the resulting product to lab report matching data.\n The lab report data are as follows : \n\n [{\"sample_matrix\":\"\",\"sample_name\":\"\",\"matching_name\":\"\",\"name\":\"King Kalm 150mg\",\"url\":\"https:\\\/\\\/cdn.shopify.com\\\/s\\\/files\\\/1\\\/1046\\\/5168\\\/files\\\/150mg_Batch_22022B_exp_06092022.pdf?v=1656704060\",\"category\":\"CBD Oils\"},{\"sample_matrix\":\"\",\"sample_name\":\"\",\"matching_name\":\"\",\"name\":\"Mange and Mite Management\",\"url\":\"https:\\\/\\\/yourcoa.com\\\/coa\\\/coa-view?sample=DA41001007-001&mrk=1&isViewOnly=1&is_marketing_only=1\",\"category\":\"CBD Topicals\"},{\"sample_matrix\":\"\",\"sample_name\":\"\",\"matching_name\":\"\",\"name\":\"King Kalm Soothe\",\"url\":\"https:\\\/\\\/yourcoa.com\\\/coa\\\/coa-view?sample=DA41001007-002&mrk=1&isViewOnly=1&is_marketing_only=1\",\"category\":\"CBD Topicals\"},{\"sample_matrix\":\"\",\"sample_name\":\"\",\"matching_name\":\"\",\"name\":\"King Kalm Balm\",\"url\":\"https:\\\/\\\/yourcoa.com\\\/coa\\\/coa-view?sample=DA41001007-003&mrk=1&isViewOnly=1&is_marketing_only=1\",\"category\":\"CBD Topicals\"},{\"sample_matrix\":\"\",\"sample_name\":\"\",\"matching_name\":\"\",\"name\":\"Tucker's Gold 1000MG CBD\",\"url\":\"https:\\\/\\\/www.verifycbd.com\\\/reportv2\\\/7ba9z15618\",\"category\":\"CBD Oils\"},{\"sample_matrix\":\"\",\"sample_name\":\"\",\"matching_name\":\"\",\"name\":\"King Kalm 600mg\",\"url\":\"https:\\\/\\\/www.verifycbd.com\\\/reportv2\\\/7a5bz151f5\",\"category\":\"CBD Oils\"},{\"sample_matrix\":\"\",\"sample_name\":\"\",\"matching_name\":\"\",\"name\":\"King Kalm 600mg\",\"url\":\"https:\\\/\\\/www.verifycbd.com\\\/reportv2\\\/746dz1410d\",\"category\":\"CBD Oils\"},{\"sample_matrix\":\"\",\"sample_name\":\"\",\"matching_name\":\"\",\"name\":\"King Kalm 600mg\",\"url\":\"https:\\\/\\\/www.verifycbd.com\\\/reportv2\\\/6defz12f2f\",\"category\":\"CBD Oils\"},{\"sample_matrix\":\"\",\"sample_name\":\"\",\"matching_name\":\"\",\"name\":\"King Kalm 600mg\",\"url\":\"https:\\\/\\\/www.verifycbd.com\\\/reportv2\\\/6829z11d4a\",\"category\":\"CBD Oils\"},{\"sample_matrix\":\"\",\"sample_name\":\"\",\"matching_name\":\"\",\"name\":\"King Kalm 300mg\",\"url\":\"https:\\\/\\\/www.verifycbd.com\\\/reportv2\\\/7a5cz151f7\",\"category\":\"CBD Oils\"},{\"sample_matrix\":\"\",\"sample_name\":\"\",\"matching_name\":\"\",\"name\":\"King Kalm 300mg\",\"url\":\"https:\\\/\\\/www.verifycbd.com\\\/reportv2\\\/6829z11d4d\",\"category\":\"CBD Oils\"},{\"sample_matrix\":\"\",\"sample_name\":\"\",\"matching_name\":\"\",\"name\":\"King Kalm 300mg\",\"url\":\"https:\\\/\\\/www.verifycbd.com\\\/report\\\/8266z175d1\",\"category\":\"CBD Oils\"},{\"sample_matrix\":\"\",\"sample_name\":\"\",\"matching_name\":\"\",\"name\":\"King Kalm 150mg\",\"url\":\"https:\\\/\\\/www.verifycbd.com\\\/reportv2\\\/7a5cz151f6\",\"category\":\"CBD Oils\"},{\"sample_matrix\":\"\",\"sample_name\":\"\",\"matching_name\":\"\",\"name\":\"King Kalm 150mg\",\"url\":\"https:\\\/\\\/www.verifycbd.com\\\/reportv2\\\/746dz1410f\",\"category\":\"CBD Oils\"},{\"sample_matrix\":\"\",\"sample_name\":\"\",\"matching_name\":\"\",\"name\":\"King Kalm 150mg\",\"url\":\"https:\\\/\\\/www.verifycbd.com\\\/reportv2\\\/6829z11d4b\",\"category\":\"CBD Oils\"},{\"sample_matrix\":\"\",\"sample_name\":\"\",\"matching_name\":\"\",\"name\":\"King Kalm 75mg\",\"url\":\"https:\\\/\\\/www.verifycbd.com\\\/reportv2\\\/746dz1410e\",\"category\":\"CBD Oils\"},{\"sample_matrix\":\"\",\"sample_name\":\"\",\"matching_name\":\"\",\"name\":\"King Kalm 75mg\",\"url\":\"https:\\\/\\\/www.verifycbd.com\\\/reportv2\\\/6829z11d4c\",\"category\":\"CBD Oils\"},{\"sample_matrix\":\"\",\"sample_name\":\"\",\"matching_name\":\"\",\"name\":\"King Kalm 75mg\",\"url\":\"https:\\\/\\\/www.verifycbd.com\\\/report\\\/8266z175d3\",\"category\":\"CBD Oils\"},{\"sample_matrix\":\"\",\"sample_name\":\"\",\"matching_name\":\"\",\"name\":\"King Kalm 75mg\",\"url\":\"https:\\\/\\\/www.verifycbd.com\\\/report\\\/7c64z162d7\",\"category\":\"CBD Oils\"},{\"sample_matrix\":\"\",\"sample_name\":\"\",\"matching_name\":\"\",\"name\":\"King Kalm Crunch Blueberry Blaze\",\"url\":\"https:\\\/\\\/www.verifycbd.com\\\/reportv2\\\/76e5z148cf\",\"category\":\"CBD Treats\"},{\"sample_matrix\":\"\",\"sample_name\":\"\",\"matching_name\":\"\",\"name\":\"King Kalm Crunch Blueberry Blaze\",\"url\":\"https:\\\/\\\/www.verifycbd.com\\\/reportv2\\\/6defz12f2d\",\"category\":\"CBD Treats\"},{\"sample_matrix\":\"\",\"sample_name\":\"\",\"matching_name\":\"\",\"name\":\"King Kalm Crunch Blueberry Blaze\",\"url\":\"https:\\\/\\\/www.verifycbd.com\\\/report\\\/8404z17afb\",\"category\":\"CBD Treats\"},{\"sample_matrix\":\"\",\"sample_name\":\"\",\"matching_name\":\"\",\"name\":\"King Kalm Crunch Blueberry Blaze\",\"url\":\"https:\\\/\\\/www.verifycbd.com\\\/report\\\/729bz1445d\",\"category\":\"CBD Treats\"},{\"sample_matrix\":\"\",\"sample_name\":\"\",\"matching_name\":\"\",\"name\":\"King Kalm Crunch Apple Cinnamon\",\"url\":\"https:\\\/\\\/www.verifycbd.com\\\/reportv2\\\/76e5z148d0\",\"category\":\"CBD Treats\"},{\"sample_matrix\":\"\",\"sample_name\":\"\",\"matching_name\":\"\",\"name\":\"King Kalm Crunch Apple Cinnamon\",\"url\":\"https:\\\/\\\/www.verifycbd.com\\\/reportv2\\\/6c37z12935\",\"category\":\"CBD Treats\"},{\"sample_matrix\":\"\",\"sample_name\":\"\",\"matching_name\":\"\",\"name\":\"King Kalm Crunch Apple Cinnamon\",\"url\":\"https:\\\/\\\/www.verifycbd.com\\\/reportv2\\\/6821z11d33\",\"category\":\"CBD Treats\"},{\"sample_matrix\":\"\",\"sample_name\":\"\",\"matching_name\":\"\",\"name\":\"King Kalm Crunch Apple Cinnamon\",\"url\":\"https:\\\/\\\/www.verifycbd.com\\\/report\\\/8418z17b32\",\"category\":\"CBD Treats\"},{\"sample_matrix\":\"\",\"sample_name\":\"\",\"matching_name\":\"\",\"name\":\"King Kalm Crunch Grass-fed Beef\",\"url\":\"https:\\\/\\\/www.verifycbd.com\\\/reportv2\\\/76e5z148ce\",\"category\":\"CBD Treats\"},{\"sample_matrix\":\"\",\"sample_name\":\"\",\"matching_name\":\"\",\"name\":\"Mange and Mite Management\",\"url\":\"https:\\\/\\\/www.verifycbd.com\\\/reportv2\\\/6764z11ae6\",\"category\":\"CBD Topicals\"},{\"sample_matrix\":\"\",\"sample_name\":\"\",\"matching_name\":\"\",\"name\":\"King Kalm Soothe\",\"url\":\"https:\\\/\\\/www.verifycbd.com\\\/report\\\/8404z17afa\",\"category\":\"CBD Topicals\"},{\"sample_matrix\":\"\",\"sample_name\":\"\",\"matching_name\":\"\",\"name\":\"King Kalm Balm\",\"url\":\"https:\\\/\\\/www.verifycbd.com\\\/report\\\/8404z17af9\",\"category\":\"CBD Topicals\"}]\n "}],"jsonSchema":{"name":"match_product_to_lab_report","strict":true,"schema":{"type":"object","properties":{"matchings":{"type":"array","items":{"type":"object","properties":{"product_name":{"type":"string","description":"The name of the product"},"lab_report":{"type":"object","properties":{"lab_report_name":{"type":"string","description":"The lab report name"},"lab_report_matching_name":{"type":"string","description":"The matching name of the lap report"},"lab_report_url":{"type":"string","description":"The url of the lab report"},"lab_report_id":{"type":"number","description":"the id of the lab report from the original given array"}},"required":["lab_report_name","lab_report_matching_name","lab_report_url","lab_report_id"],"additionalProperties":false}},"required":["product_name","lab_report"],"additionalProperties":false}}},"required":["matchings"],"additionalProperties":false}}}
{"prompt":[{"role":"system","content":"You are an ai that can match cannabis product names to their lab report based on the product name and lab report matching name"},{"role":"user","content":"\n I have an array of product names as follows\n [\"600mg CBD For Dogs Minneapolis\"]\n\n I also have an array of lab reports of those products. \n This data is an array of objects where each object is a lab report, the object has the lab report name, lab report matching name and its url.\n The matching name of the lab report is similar to atleast one of the products given above. \n Match the product names to the correct lab report based on the product name and matching name.\n Give me the resulting product to lab report matching data.\n The lab report data are as follows : \n\n [{\"sample_matrix\":\"\",\"sample_name\":\"\",\"matching_name\":\"\",\"name\":\"King Kalm 150mg\",\"url\":\"https:\\\/\\\/cdn.shopify.com\\\/s\\\/files\\\/1\\\/1046\\\/5168\\\/files\\\/150mg_Batch_22022B_exp_06092022.pdf?v=1656704060\",\"category\":\"CBD Oils\"},{\"sample_matrix\":\"\",\"sample_name\":\"\",\"matching_name\":\"\",\"name\":\"Mange and Mite Management\",\"url\":\"https:\\\/\\\/yourcoa.com\\\/coa\\\/coa-view?sample=DA41001007-001&mrk=1&isViewOnly=1&is_marketing_only=1\",\"category\":\"CBD Topicals\"},{\"sample_matrix\":\"\",\"sample_name\":\"\",\"matching_name\":\"\",\"name\":\"King Kalm Soothe\",\"url\":\"https:\\\/\\\/yourcoa.com\\\/coa\\\/coa-view?sample=DA41001007-002&mrk=1&isViewOnly=1&is_marketing_only=1\",\"category\":\"CBD Topicals\"},{\"sample_matrix\":\"\",\"sample_name\":\"\",\"matching_name\":\"\",\"name\":\"King Kalm Balm\",\"url\":\"https:\\\/\\\/yourcoa.com\\\/coa\\\/coa-view?sample=DA41001007-003&mrk=1&isViewOnly=1&is_marketing_only=1\",\"category\":\"CBD Topicals\"},{\"sample_matrix\":\"\",\"sample_name\":\"\",\"matching_name\":\"\",\"name\":\"Tucker's Gold 1000MG CBD\",\"url\":\"https:\\\/\\\/www.verifycbd.com\\\/reportv2\\\/7ba9z15618\",\"category\":\"CBD Oils\"},{\"sample_matrix\":\"\",\"sample_name\":\"\",\"matching_name\":\"\",\"name\":\"King Kalm 600mg\",\"url\":\"https:\\\/\\\/www.verifycbd.com\\\/reportv2\\\/7a5bz151f5\",\"category\":\"CBD Oils\"},{\"sample_matrix\":\"\",\"sample_name\":\"\",\"matching_name\":\"\",\"name\":\"King Kalm 600mg\",\"url\":\"https:\\\/\\\/www.verifycbd.com\\\/reportv2\\\/746dz1410d\",\"category\":\"CBD Oils\"},{\"sample_matrix\":\"\",\"sample_name\":\"\",\"matching_name\":\"\",\"name\":\"King Kalm 600mg\",\"url\":\"https:\\\/\\\/www.verifycbd.com\\\/reportv2\\\/6defz12f2f\",\"category\":\"CBD Oils\"},{\"sample_matrix\":\"\",\"sample_name\":\"\",\"matching_name\":\"\",\"name\":\"King Kalm 600mg\",\"url\":\"https:\\\/\\\/www.verifycbd.com\\\/reportv2\\\/6829z11d4a\",\"category\":\"CBD Oils\"},{\"sample_matrix\":\"\",\"sample_name\":\"\",\"matching_name\":\"\",\"name\":\"King Kalm 300mg\",\"url\":\"https:\\\/\\\/www.verifycbd.com\\\/reportv2\\\/7a5cz151f7\",\"category\":\"CBD Oils\"},{\"sample_matrix\":\"\",\"sample_name\":\"\",\"matching_name\":\"\",\"name\":\"King Kalm 300mg\",\"url\":\"https:\\\/\\\/www.verifycbd.com\\\/reportv2\\\/6829z11d4d\",\"category\":\"CBD Oils\"},{\"sample_matrix\":\"\",\"sample_name\":\"\",\"matching_name\":\"\",\"name\":\"King Kalm 300mg\",\"url\":\"https:\\\/\\\/www.verifycbd.com\\\/report\\\/8266z175d1\",\"category\":\"CBD Oils\"},{\"sample_matrix\":\"\",\"sample_name\":\"\",\"matching_name\":\"\",\"name\":\"King Kalm 150mg\",\"url\":\"https:\\\/\\\/www.verifycbd.com\\\/reportv2\\\/7a5cz151f6\",\"category\":\"CBD Oils\"},{\"sample_matrix\":\"\",\"sample_name\":\"\",\"matching_name\":\"\",\"name\":\"King Kalm 150mg\",\"url\":\"https:\\\/\\\/www.verifycbd.com\\\/reportv2\\\/746dz1410f\",\"category\":\"CBD Oils\"},{\"sample_matrix\":\"\",\"sample_name\":\"\",\"matching_name\":\"\",\"name\":\"King Kalm 150mg\",\"url\":\"https:\\\/\\\/www.verifycbd.com\\\/reportv2\\\/6829z11d4b\",\"category\":\"CBD Oils\"},{\"sample_matrix\":\"\",\"sample_name\":\"\",\"matching_name\":\"\",\"name\":\"King Kalm 75mg\",\"url\":\"https:\\\/\\\/www.verifycbd.com\\\/reportv2\\\/746dz1410e\",\"category\":\"CBD Oils\"},{\"sample_matrix\":\"\",\"sample_name\":\"\",\"matching_name\":\"\",\"name\":\"King Kalm 75mg\",\"url\":\"https:\\\/\\\/www.verifycbd.com\\\/reportv2\\\/6829z11d4c\",\"category\":\"CBD Oils\"},{\"sample_matrix\":\"\",\"sample_name\":\"\",\"matching_name\":\"\",\"name\":\"King Kalm 75mg\",\"url\":\"https:\\\/\\\/www.verifycbd.com\\\/report\\\/8266z175d3\",\"category\":\"CBD Oils\"},{\"sample_matrix\":\"\",\"sample_name\":\"\",\"matching_name\":\"\",\"name\":\"King Kalm 75mg\",\"url\":\"https:\\\/\\\/www.verifycbd.com\\\/report\\\/7c64z162d7\",\"category\":\"CBD Oils\"},{\"sample_matrix\":\"\",\"sample_name\":\"\",\"matching_name\":\"\",\"name\":\"King Kalm Crunch Blueberry Blaze\",\"url\":\"https:\\\/\\\/www.verifycbd.com\\\/reportv2\\\/76e5z148cf\",\"category\":\"CBD Treats\"},{\"sample_matrix\":\"\",\"sample_name\":\"\",\"matching_name\":\"\",\"name\":\"King Kalm Crunch Blueberry Blaze\",\"url\":\"https:\\\/\\\/www.verifycbd.com\\\/reportv2\\\/6defz12f2d\",\"category\":\"CBD Treats\"},{\"sample_matrix\":\"\",\"sample_name\":\"\",\"matching_name\":\"\",\"name\":\"King Kalm Crunch Blueberry Blaze\",\"url\":\"https:\\\/\\\/www.verifycbd.com\\\/report\\\/8404z17afb\",\"category\":\"CBD Treats\"},{\"sample_matrix\":\"\",\"sample_name\":\"\",\"matching_name\":\"\",\"name\":\"King Kalm Crunch Blueberry Blaze\",\"url\":\"https:\\\/\\\/www.verifycbd.com\\\/report\\\/729bz1445d\",\"category\":\"CBD Treats\"},{\"sample_matrix\":\"\",\"sample_name\":\"\",\"matching_name\":\"\",\"name\":\"King Kalm Crunch Apple Cinnamon\",\"url\":\"https:\\\/\\\/www.verifycbd.com\\\/reportv2\\\/76e5z148d0\",\"category\":\"CBD Treats\"},{\"sample_matrix\":\"\",\"sample_name\":\"\",\"matching_name\":\"\",\"name\":\"King Kalm Crunch Apple Cinnamon\",\"url\":\"https:\\\/\\\/www.verifycbd.com\\\/reportv2\\\/6c37z12935\",\"category\":\"CBD Treats\"},{\"sample_matrix\":\"\",\"sample_name\":\"\",\"matching_name\":\"\",\"name\":\"King Kalm Crunch Apple Cinnamon\",\"url\":\"https:\\\/\\\/www.verifycbd.com\\\/reportv2\\\/6821z11d33\",\"category\":\"CBD Treats\"},{\"sample_matrix\":\"\",\"sample_name\":\"\",\"matching_name\":\"\",\"name\":\"King Kalm Crunch Apple Cinnamon\",\"url\":\"https:\\\/\\\/www.verifycbd.com\\\/report\\\/8418z17b32\",\"category\":\"CBD Treats\"},{\"sample_matrix\":\"\",\"sample_name\":\"\",\"matching_name\":\"\",\"name\":\"King Kalm Crunch Grass-fed Beef\",\"url\":\"https:\\\/\\\/www.verifycbd.com\\\/reportv2\\\/76e5z148ce\",\"category\":\"CBD Treats\"},{\"sample_matrix\":\"\",\"sample_name\":\"\",\"matching_name\":\"\",\"name\":\"Mange and Mite Management\",\"url\":\"https:\\\/\\\/www.verifycbd.com\\\/reportv2\\\/6764z11ae6\",\"category\":\"CBD Topicals\"},{\"sample_matrix\":\"\",\"sample_name\":\"\",\"matching_name\":\"\",\"name\":\"King Kalm Soothe\",\"url\":\"https:\\\/\\\/www.verifycbd.com\\\/report\\\/8404z17afa\",\"category\":\"CBD Topicals\"},{\"sample_matrix\":\"\",\"sample_name\":\"\",\"matching_name\":\"\",\"name\":\"King Kalm Balm\",\"url\":\"https:\\\/\\\/www.verifycbd.com\\\/report\\\/8404z17af9\",\"category\":\"CBD Topicals\"}]\n "}],"jsonSchema":{"name":"match_product_to_lab_report","strict":true,"schema":{"type":"object","properties":{"matchings":{"type":"array","items":{"type":"object","properties":{"product_name":{"type":"string","description":"The name of the product"},"lab_report":{"type":"object","properties":{"lab_report_name":{"type":"string","description":"The lab report name"},"lab_report_matching_name":{"type":"string","description":"The matching name of the lap report"},"lab_report_url":{"type":"string","description":"The url of the lab report"},"lab_report_id":{"type":"number","description":"the id of the lab report from the original given array"}},"required":["lab_report_name","lab_report_matching_name","lab_report_url","lab_report_id"],"additionalProperties":false}},"required":["product_name","lab_report"],"additionalProperties":false}}},"required":["matchings"],"additionalProperties":false}}}
{"prompt":[{"role":"system","content":"You are an ai that can match cannabis product names to their lab report based on the product name and lab report matching name"},{"role":"user","content":"\n I have an array of product names as follows\n [\"King Kalm CBD 75mg FREE Klean Paws 20 lbs or less\"]\n\n I also have an array of lab reports of those products. \n This data is an array of objects where each object is a lab report, the object has the lab report name, lab report matching name and its url.\n The matching name of the lab report is similar to atleast one of the products given above. \n Match the product names to the correct lab report based on the product name and matching name.\n Give me the resulting product to lab report matching data.\n The lab report data are as follows : \n\n [{\"sample_matrix\":\"\",\"sample_name\":\"\",\"matching_name\":\"\",\"name\":\"King Kalm 150mg\",\"url\":\"https:\\\/\\\/cdn.shopify.com\\\/s\\\/files\\\/1\\\/1046\\\/5168\\\/files\\\/150mg_Batch_22022B_exp_06092022.pdf?v=1656704060\",\"category\":\"CBD Oils\"},{\"sample_matrix\":\"\",\"sample_name\":\"\",\"matching_name\":\"\",\"name\":\"Mange and Mite Management\",\"url\":\"https:\\\/\\\/yourcoa.com\\\/coa\\\/coa-view?sample=DA41001007-001&mrk=1&isViewOnly=1&is_marketing_only=1\",\"category\":\"CBD Topicals\"},{\"sample_matrix\":\"\",\"sample_name\":\"\",\"matching_name\":\"\",\"name\":\"King Kalm Soothe\",\"url\":\"https:\\\/\\\/yourcoa.com\\\/coa\\\/coa-view?sample=DA41001007-002&mrk=1&isViewOnly=1&is_marketing_only=1\",\"category\":\"CBD Topicals\"},{\"sample_matrix\":\"\",\"sample_name\":\"\",\"matching_name\":\"\",\"name\":\"King Kalm Balm\",\"url\":\"https:\\\/\\\/yourcoa.com\\\/coa\\\/coa-view?sample=DA41001007-003&mrk=1&isViewOnly=1&is_marketing_only=1\",\"category\":\"CBD Topicals\"},{\"sample_matrix\":\"\",\"sample_name\":\"\",\"matching_name\":\"\",\"name\":\"Tucker's Gold 1000MG CBD\",\"url\":\"https:\\\/\\\/www.verifycbd.com\\\/reportv2\\\/7ba9z15618\",\"category\":\"CBD Oils\"},{\"sample_matrix\":\"\",\"sample_name\":\"\",\"matching_name\":\"\",\"name\":\"King Kalm 600mg\",\"url\":\"https:\\\/\\\/www.verifycbd.com\\\/reportv2\\\/7a5bz151f5\",\"category\":\"CBD Oils\"},{\"sample_matrix\":\"\",\"sample_name\":\"\",\"matching_name\":\"\",\"name\":\"King Kalm 600mg\",\"url\":\"https:\\\/\\\/www.verifycbd.com\\\/reportv2\\\/746dz1410d\",\"category\":\"CBD Oils\"},{\"sample_matrix\":\"\",\"sample_name\":\"\",\"matching_name\":\"\",\"name\":\"King Kalm 600mg\",\"url\":\"https:\\\/\\\/www.verifycbd.com\\\/reportv2\\\/6defz12f2f\",\"category\":\"CBD Oils\"},{\"sample_matrix\":\"\",\"sample_name\":\"\",\"matching_name\":\"\",\"name\":\"King Kalm 600mg\",\"url\":\"https:\\\/\\\/www.verifycbd.com\\\/reportv2\\\/6829z11d4a\",\"category\":\"CBD Oils\"},{\"sample_matrix\":\"\",\"sample_name\":\"\",\"matching_name\":\"\",\"name\":\"King Kalm 300mg\",\"url\":\"https:\\\/\\\/www.verifycbd.com\\\/reportv2\\\/7a5cz151f7\",\"category\":\"CBD Oils\"},{\"sample_matrix\":\"\",\"sample_name\":\"\",\"matching_name\":\"\",\"name\":\"King Kalm 300mg\",\"url\":\"https:\\\/\\\/www.verifycbd.com\\\/reportv2\\\/6829z11d4d\",\"category\":\"CBD Oils\"},{\"sample_matrix\":\"\",\"sample_name\":\"\",\"matching_name\":\"\",\"name\":\"King Kalm 300mg\",\"url\":\"https:\\\/\\\/www.verifycbd.com\\\/report\\\/8266z175d1\",\"category\":\"CBD Oils\"},{\"sample_matrix\":\"\",\"sample_name\":\"\",\"matching_name\":\"\",\"name\":\"King Kalm 150mg\",\"url\":\"https:\\\/\\\/www.verifycbd.com\\\/reportv2\\\/7a5cz151f6\",\"category\":\"CBD Oils\"},{\"sample_matrix\":\"\",\"sample_name\":\"\",\"matching_name\":\"\",\"name\":\"King Kalm 150mg\",\"url\":\"https:\\\/\\\/www.verifycbd.com\\\/reportv2\\\/746dz1410f\",\"category\":\"CBD Oils\"},{\"sample_matrix\":\"\",\"sample_name\":\"\",\"matching_name\":\"\",\"name\":\"King Kalm 150mg\",\"url\":\"https:\\\/\\\/www.verifycbd.com\\\/reportv2\\\/6829z11d4b\",\"category\":\"CBD Oils\"},{\"sample_matrix\":\"\",\"sample_name\":\"\",\"matching_name\":\"\",\"name\":\"King Kalm 75mg\",\"url\":\"https:\\\/\\\/www.verifycbd.com\\\/reportv2\\\/746dz1410e\",\"category\":\"CBD Oils\"},{\"sample_matrix\":\"\",\"sample_name\":\"\",\"matching_name\":\"\",\"name\":\"King Kalm 75mg\",\"url\":\"https:\\\/\\\/www.verifycbd.com\\\/reportv2\\\/6829z11d4c\",\"category\":\"CBD Oils\"},{\"sample_matrix\":\"\",\"sample_name\":\"\",\"matching_name\":\"\",\"name\":\"King Kalm 75mg\",\"url\":\"https:\\\/\\\/www.verifycbd.com\\\/report\\\/8266z175d3\",\"category\":\"CBD Oils\"},{\"sample_matrix\":\"\",\"sample_name\":\"\",\"matching_name\":\"\",\"name\":\"King Kalm 75mg\",\"url\":\"https:\\\/\\\/www.verifycbd.com\\\/report\\\/7c64z162d7\",\"category\":\"CBD Oils\"},{\"sample_matrix\":\"\",\"sample_name\":\"\",\"matching_name\":\"\",\"name\":\"King Kalm Crunch Blueberry Blaze\",\"url\":\"https:\\\/\\\/www.verifycbd.com\\\/reportv2\\\/76e5z148cf\",\"category\":\"CBD Treats\"},{\"sample_matrix\":\"\",\"sample_name\":\"\",\"matching_name\":\"\",\"name\":\"King Kalm Crunch Blueberry Blaze\",\"url\":\"https:\\\/\\\/www.verifycbd.com\\\/reportv2\\\/6defz12f2d\",\"category\":\"CBD Treats\"},{\"sample_matrix\":\"\",\"sample_name\":\"\",\"matching_name\":\"\",\"name\":\"King Kalm Crunch Blueberry Blaze\",\"url\":\"https:\\\/\\\/www.verifycbd.com\\\/report\\\/8404z17afb\",\"category\":\"CBD Treats\"},{\"sample_matrix\":\"\",\"sample_name\":\"\",\"matching_name\":\"\",\"name\":\"King Kalm Crunch Blueberry Blaze\",\"url\":\"https:\\\/\\\/www.verifycbd.com\\\/report\\\/729bz1445d\",\"category\":\"CBD Treats\"},{\"sample_matrix\":\"\",\"sample_name\":\"\",\"matching_name\":\"\",\"name\":\"King Kalm Crunch Apple Cinnamon\",\"url\":\"https:\\\/\\\/www.verifycbd.com\\\/reportv2\\\/76e5z148d0\",\"category\":\"CBD Treats\"},{\"sample_matrix\":\"\",\"sample_name\":\"\",\"matching_name\":\"\",\"name\":\"King Kalm Crunch Apple Cinnamon\",\"url\":\"https:\\\/\\\/www.verifycbd.com\\\/reportv2\\\/6c37z12935\",\"category\":\"CBD Treats\"},{\"sample_matrix\":\"\",\"sample_name\":\"\",\"matching_name\":\"\",\"name\":\"King Kalm Crunch Apple Cinnamon\",\"url\":\"https:\\\/\\\/www.verifycbd.com\\\/reportv2\\\/6821z11d33\",\"category\":\"CBD Treats\"},{\"sample_matrix\":\"\",\"sample_name\":\"\",\"matching_name\":\"\",\"name\":\"King Kalm Crunch Apple Cinnamon\",\"url\":\"https:\\\/\\\/www.verifycbd.com\\\/report\\\/8418z17b32\",\"category\":\"CBD Treats\"},{\"sample_matrix\":\"\",\"sample_name\":\"\",\"matching_name\":\"\",\"name\":\"King Kalm Crunch Grass-fed Beef\",\"url\":\"https:\\\/\\\/www.verifycbd.com\\\/reportv2\\\/76e5z148ce\",\"category\":\"CBD Treats\"},{\"sample_matrix\":\"\",\"sample_name\":\"\",\"matching_name\":\"\",\"name\":\"Mange and Mite Management\",\"url\":\"https:\\\/\\\/www.verifycbd.com\\\/reportv2\\\/6764z11ae6\",\"category\":\"CBD Topicals\"},{\"sample_matrix\":\"\",\"sample_name\":\"\",\"matching_name\":\"\",\"name\":\"King Kalm Soothe\",\"url\":\"https:\\\/\\\/www.verifycbd.com\\\/report\\\/8404z17afa\",\"category\":\"CBD Topicals\"},{\"sample_matrix\":\"\",\"sample_name\":\"\",\"matching_name\":\"\",\"name\":\"King Kalm Balm\",\"url\":\"https:\\\/\\\/www.verifycbd.com\\\/report\\\/8404z17af9\",\"category\":\"CBD Topicals\"}]\n "}],"jsonSchema":{"name":"match_product_to_lab_report","strict":true,"schema":{"type":"object","properties":{"matchings":{"type":"array","items":{"type":"object","properties":{"product_name":{"type":"string","description":"The name of the product"},"lab_report":{"type":"object","properties":{"lab_report_name":{"type":"string","description":"The lab report name"},"lab_report_matching_name":{"type":"string","description":"The matching name of the lap report"},"lab_report_url":{"type":"string","description":"The url of the lab report"},"lab_report_id":{"type":"number","description":"the id of the lab report from the original given array"}},"required":["lab_report_name","lab_report_matching_name","lab_report_url","lab_report_id"],"additionalProperties":false}},"required":["product_name","lab_report"],"additionalProperties":false}}},"required":["matchings"],"additionalProperties":false}}}
{"originalAiResponse":{"id":"chatcmpl-Bx3kXZw5Riow0Z17dqcHfXTuSRDPL","object":"chat.completion","created":1753415465,"model":"gpt-4o-2024-11-20","system_fingerprint":"fp_c67768f680","choices":[{"index":0,"message":{"role":"assistant","content":"{\"productName\":\"GMO Cookies Flower\",\"productType\":\"cannabis\",\"labReports\":[{\"labReportName\":\"Lab Test Results\",\"labReportUrl\":\"https:\/\/www.boom.shop\/product\/data\/GMO-Cookies-LabReport.pdf\"}]}"},"finish_reason":"stop"}],"usage":{"prompt_tokens":2494,"completion_tokens":50,"total_tokens":2544,"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}}},"content":{"productName":"GMO Cookies Flower","productType":"cannabis","labReports":[{"labReportName":"Lab Test Results","labReportUrl":"https:\/\/www.boom.shop\/product\/data\/GMO-Cookies-LabReport.pdf"}]}}
{"prompt":[{"role":"user","content":"\n This is a markdown for a cannabis product lab report:\n ---START MARKDOWN HERE---\n \"\\nAromatic Plant Research Center \\n230 N 1200 E STE 100 \\nLehi, UT 84043 \\nwww.aromaticplant.org\\n\\n# Comprehensive Analysis Report\\n\\n## Sample Overview\\n\\n**Client:** HempLucid \\n852 E 1910 S Unit 3, Provo, UT 84606 \\n\\n**Sample Name:** HL-MCT600NAT-CBD \\n**Sample Matrix:** Tincture \\n**Sample Lot:** 182021 \\n\\n**Date Received:** 10\\\/11\\\/2024 \\n**APRC #:** HPL241014C \\n\\n| Assay | Disposition | Date Tested |\\n| ------------------------------------------ | ----------- | ----------- |\\n| Hemp or R\\\\&D Cannabinoid Testing (Potency) | Tested | 10-15-2024 |\\n\\n\\nAccreditation #115229 \\nAromatic Plant Research Center is an ISO 17025:2017 certified laboratory.\\n\\nCopyright \\u00a9 2020 by Aromatic Plant Research Center (APRC). All rights reserved. The information in this test report may not be reproduced except in full. These results only apply to the samples included in this report.\\n\\nPage 1 of 2\\n\\n---\\n\\nAromatic Plant Research Center \\n230 N 1200 E STE 100 \\nLehi, UT 84043 \\nwww.aromaticplant.org \\n\\n# Instrument Analysis Report\\n\\n## Potency\\n\\n**Method:** SOP 1-2026.03 \\n**Sample Name:** HL-MCT600NAT-CBD \\n**APRC Lot Number:** HPL241014C \\n\\n| Cannabinoid | RT | Total % | Total mg\\\/g |\\n| --------------------------------------------------- | ----- | ------- | ---------- |\\n| Cannabidivarinic Acid (CBDVA) | ND | ND | ND |\\n| Cannabidivarin (CBDV) | ND | ND | ND |\\n| Cannabidiolic Acid (CBDA) | ND | ND | ND |\\n| Cannabigerolic Acid (CBGA) | ND | ND | ND |\\n| Cannabinol (CBN) | \\\\<LOQ | \\\\<LOQ | \\\\<LOQ |\\n| Cannabidiol (CBD) | 3.58 | 2.14 | 21.45 |\\n| Cannabigerol (CBG) | 3.38 | 0.03 | 0.26 |\\n| Tetrahydrocannabivarin (THCV) | ND | ND | ND |\\n| Tetrahydrocannabivarin Acid (THCVA) | ND | ND | ND |\\n| Delta-9-Tetrahydrocannabinol (\\u03949-THC) | 6.75 | 0.07 | 0.74 |\\n| Delta-8-Tetrahydrocannabinol (\\u03948-THC) | ND | ND | ND |\\n| Tetrahydrocannabinolic acid (THCA-A) | ND | ND | ND |\\n| Cannabichromene (CBC) | 8.49 | 0.06 | 0.64 |\\n| Cannabichromene Acid (CBCA) | ND | ND | ND |\\n| \\u039410 and \\u03946a,10a-Tetrahydrocannabinol, mixed isomers | ND | ND | ND |\\n| (6aR,9R)-\\u039410-Tetrahydrocannabidiol | NT | NT | NT |\\n| (6aR,9S)-\\u039410-Tetrahydrocannabidiol | NT | NT | NT |\\n| 9(R+S)-\\u03946a,10a-Tetrahydrocannabidiol | NT | NT | NT |\\n| Cannabitcitran (CBTC) | ND | ND | ND |\\n\\n\\n**Performed by:** Tessa Crook \\n**Reviewed by:** Riley Hunter \\n\\n| | % | mg\\\/g |\\n| ------------------ | ---- | ----- |\\n| Total Cannabinoids | 2.31 | 23.09 |\\n| Total THCt | 0.07 | 0.74 |\\n| Total CBDs | 2.14 | 21.45 |\\n\\n\\n<sup>t<\\\/sup>Total Thc is calculated by \\u03949-THC + (THCA-A*0.877) \\n<sup>s<\\\/sup>Total CBD is calculated by CBD + (CBDA*0.877) \\n\\nLOD > 0.005% by mass, LOQ > 0.01% by mass \\n\\n**Approved By:** \\nNicholas Saichek, PhD \\nSenior Scientist Mass Spectrometry \\n10\\\/17\\\/2024 \\n\\nCopyright \\u00a9 2020 by Aromatic Plant Research Center (APRC). All rights reserved. The information in this test report may not be reproduced except in full. These results only apply to the samples included in this report. \\nPage 2 of 2\\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-Bx4DpU0FeX5uWUZwauaGskdWbyFyQ","object":"chat.completion","created":1753417281,"model":"gpt-4o-2024-08-06","system_fingerprint":"fp_07871e2ad8","choices":[{"index":0,"message":{"role":"assistant","content":"Here's a table with all the dates extracted from the lab report:\n\n```markdown\n| Description | Date |\n|------------------|------------|\n| Date Received | 10\/11\/2024 |\n| Date Tested | 10-15-2024 |\n| Approved By Date | 10\/17\/2024 |\n```\n\nThese are the dates as they appear in the report, without any derivations."},"finish_reason":"stop"}],"usage":{"prompt_tokens":1289,"completion_tokens":86,"total_tokens":1375,"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 dates extracted from the lab report:\n\n```markdown\n| Description | Date |\n|------------------|------------|\n| Date Received | 10\/11\/2024 |\n| Date Tested | 10-15-2024 |\n| Approved By Date | 10\/17\/2024 |\n```\n\nThese are the dates as they appear in the report, without any derivations. \n\n Convert all the date values in this table to standard ISO Format (yyyy-mm-dd)\n "}
{"id":"chatcmpl-Bx4DsY5tTqnrpoF8cpe0LGI0Kjo4P","object":"chat.completion","created":1753417284,"model":"gpt-4o-2024-08-06","system_fingerprint":"fp_a288987b44","choices":[{"index":0,"message":{"role":"assistant","content":"Certainly! Here's the table with the dates converted to ISO format:\n\n```markdown\n| Description | Date |\n|------------------|------------|\n| Date Received | 2024-10-11 |\n| Date Tested | 2024-10-15 |\n| Approved By Date | 2024-10-17 |\n```"},"finish_reason":"stop"}],"usage":{"prompt_tokens":147,"completion_tokens":69,"total_tokens":216,"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":"user","content":"\n This is a markdown for a cannabis product lab report:\n ---START MARKDOWN HERE---\n \"\\nENCORE LABS \\nEncore Labs \\n75 N Vinedo Ave. \\nPasadena, CA 91107 \\n(626) 696-3086 \\nhttps:\\\/\\\/encore-labs.com \\nLic# C8-0000086-LIC \\nR&D Testing \\nCertificate of Analysis \\n1 of 1\\n\\n# Minis\\n\\n**METRC Batch:** \\n**METRC Sample:** \\n**Sample ID:** 2403ENC2577_7750 \\n**Strain:** Mini \\n**Matrix:** Ingestible \\n**Type:** Soft Chew \\n**Batch#:** 00274 \\n\\n**Collected:** 03\\\/21\\\/2024 \\n**Received:** 03\\\/21\\\/2024 \\n**Completed:** 03\\\/22\\\/2024 \\n**Sample Size:** 1 units; \\n\\n**Distributor** \\nKing B Distribution \\n**Lic. #** \\n502 W 8360 S, \\nSandy, CA, 84020 \\n\\n----\\n\\n![Image of product]\\n\\n## Summary\\n\\n| Test | Date Tested | Instr. Method | Result |\\n|-------------|-------------|---------------|----------|\\n| Cannabinoids| 03\\\/21\\\/2024 | LC-DAD | Pass |\\n\\n----\\n\\n## Cannabinoids\\n\\n**Method:** SOP EL-CANNABINOIDS\\n\\n| | 9.72 mg\\\/unit | 10.42 mg\\\/unit | 20.14 mg\\\/unit |\\n|----------------|--------------|---------------|---------------|\\n| | Total THC | Total CBD | Total Cannabinoids |\\n\\n### Analytes\\n\\n| Analytes | LOQ | Result | Result | Result | |\\n| ------------------- | ----- | ------ | ------ | ------ | ----- |\\n| THCa | 0.012 | 0.037 | ND | ND | |\\n| \\u03949-THC | 0.012 | 0.039 | 0.285 | 2.85 | 9.72 |\\n| \\u03948-THC | 0.014 | 0.044 | ND | ND | |\\n| THCVa | 0.015 | 0.043 | ND | ND | |\\n| THCV | 0.013 | 0.039 | ND | ND | |\\n| CBDa | 0.012 | 0.036 | ND | ND | |\\n| CBD | 0.012 | 0.036 | 0.306 | 3.06 | 10.42 |\\n| CBN | 0.012 | 0.036 | ND | ND | |\\n| CBGA | 0.013 | 0.043 | ND | ND | |\\n| CBG | 0.013 | 0.039 | ND | ND | |\\n| CBCA | 0.012 | 0.035 | ND | ND | |\\n| CBC | 0.013 | 0.041 | ND | ND | |\\n| Total THC | | 0.285 | 2.85 | 9.718 | |\\n| Total CBD | | 0.306 | 3.06 | 10.418 | |\\n| Total Cannabinoids | | 0.590 | 5.90 | 20.135 | |\\n| Sum of Cannabinoids | | 0.590 | 5.90 | 20.135 | |\\n\\n\\n1 Unit = 3.41g; \\nTotal THC = THCa * 0.877 + \\u03949-THC + \\u03948-THC; Total CBD = CBDa * 0.877 + CBD; Total Cannabinoids = (cannabinoid acid forms * 0.877) + cannabinoids; Sum of Cannabinoids = cannabinoid acid forms + cannabinoids; LOQ = Limit of Quantitation; LOD = Limit of Detection; NT = Not Tested; ND = Not Detected. The reported result is based on a sample weight with the applicable moisture content for that sample. Foreign Material Method: SOP EL-FOREIGN; Moisture and Water Activity Method: SOP EL-WATER\\n\\n----\\n\\nKevin Nolan \\nLaboratory Director | 03\\\/22\\\/2024 \\n\\nThis report is not a California regulatory compliance certificate, it is for R&D\\\/Quality Assurance purposes only. Values reported relate only to the product tested. Sample was tested as received from client. Encore Labs makes no claims as to the efficacy, safety or other risks associated with any detected or non-detected levels of any compounds reported herein. This Certificate shall not be reproduced except in full, without the written approval of Encore Labs.\"\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-Bx4Dsg02F5CKyXrfisu7W78oopjC4","object":"chat.completion","created":1753417284,"model":"gpt-4o-2024-11-20","system_fingerprint":"fp_c67768f680","choices":[{"index":0,"message":{"role":"assistant","content":"Here is the extracted date text from the lab report in a table markdown format:\n\n```markdown\n| Date Type | Date |\n|-------------|------------|\n| Collected | 03\/21\/2024 |\n| Received | 03\/21\/2024 |\n| Completed | 03\/22\/2024 |\n| Tested | 03\/21\/2024 |\n| Report Signed | 03\/22\/2024 |\n```"},"finish_reason":"stop"}],"usage":{"prompt_tokens":1214,"completion_tokens":94,"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":[{"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 the dates converted to ISO format:\n\n```markdown\n| Description | Date |\n|------------------|------------|\n| Date Received | 2024-10-11 |\n| Date Tested | 2024-10-15 |\n| Approved By Date | 2024-10-17 |\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}}}
{"prompt":"\n I have table of dates from a lab report of a cannabis product in markdown format:\n Here is the extracted date text from the lab report in a table markdown format:\n\n```markdown\n| Date Type | Date |\n|-------------|------------|\n| Collected | 03\/21\/2024 |\n| Received | 03\/21\/2024 |\n| Completed | 03\/22\/2024 |\n| Tested | 03\/21\/2024 |\n| Report Signed | 03\/22\/2024 |\n``` \n\n Convert all the date values in this table to standard ISO Format (yyyy-mm-dd)\n "}
{"id":"chatcmpl-Bx4Duu0jqbmAtSvmJwr9HN1s4uqnx","object":"chat.completion","created":1753417286,"model":"gpt-4o-2024-11-20","choices":[{"index":0,"message":{"role":"assistant","content":"Here is the updated table with all date values converted to ISO format:\n\n```markdown\n| Date Type | Date |\n|---------------|------------|\n| Collected | 2024-03-21 |\n| Received | 2024-03-21 |\n| Completed | 2024-03-22 |\n| Tested | 2024-03-21 |\n| Report Signed | 2024-03-22 |\n```"},"finish_reason":"stop"}],"usage":{"prompt_tokens":155,"completion_tokens":92,"total_tokens":247,"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 the updated table with all date values converted to ISO format:\n\n```markdown\n| Date Type | Date |\n|---------------|------------|\n| Collected | 2024-03-21 |\n| Received | 2024-03-21 |\n| Completed | 2024-03-22 |\n| Tested | 2024-03-21 |\n| Report Signed | 2024-03-22 |\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}}}
{"prompt":[{"role":"system","content":"You are an ai that can match cannabis product names to their lab report based on the product name and lab report matching name"},{"role":"user","content":"\n I have an array of product names as follows\n [\"Super Silver Haze Strain - 3.5G - Exotic THCA Flower\"]\n\n I also have an array of lab reports of those products. \n This data is an array of objects where each object is a lab report, the object has the lab report name, lab report matching name and its url.\n The matching name of the lab report is similar to atleast one of the products given above. \n Match the product names to the correct lab report based on the product name and matching name.\n Give me the resulting product to lab report matching data.\n The lab report data are as follows : \n\n [{\"sample_matrix\":\"\",\"sample_name\":\"\",\"matching_name\":\"Exotic THCA Flower - Grape Skywalker OG\",\"name\":\"Exotic THCA Flower - Grape Skywalker OG\",\"url\":\"https:\\\/\\\/cdn.shopify.com\\\/s\\\/files\\\/1\\\/0654\\\/7764\\\/0343\\\/files\\\/Motiv-strains-Marin-COA-8-24-GSOG.pdf?v=1724376433\",\"category\":\"Motiv Strains Certificate of Analysis\"},{\"sample_matrix\":\"\",\"sample_name\":\"\",\"matching_name\":\"Exotic THCA Flower - Strawberry Gelato\",\"name\":\"Exotic THCA Flower - Strawberry Gelato\",\"url\":\"https:\\\/\\\/cdn.shopify.com\\\/s\\\/files\\\/1\\\/0654\\\/7764\\\/0343\\\/files\\\/Motiv-strains-Marin-COA-8-24-SG.pdf?v=1724376433\",\"category\":\"Motiv Strains Certificate of Analysis\"},{\"sample_matrix\":\"\",\"sample_name\":\"\",\"matching_name\":\"Exotic THCA Flower - Super Silver Haze\",\"name\":\"Exotic THCA Flower - Super Silver Haze\",\"url\":\"https:\\\/\\\/cdn.shopify.com\\\/s\\\/files\\\/1\\\/0654\\\/7764\\\/0343\\\/files\\\/Motiv-strains-Marin-COA-8-24-SSH.pdf?v=1724376433\",\"category\":\"Motiv Strains Certificate of Analysis\"},{\"sample_matrix\":\"\",\"sample_name\":\"\",\"matching_name\":\"Exotic THCA Flower - Candy Gas\",\"name\":\"Exotic THCA Flower - Candy Gas\",\"url\":\"https:\\\/\\\/cdn.shopify.com\\\/s\\\/files\\\/1\\\/0654\\\/7764\\\/0343\\\/files\\\/Motiv-strains-Marin-COA-8-24-CG.pdf?v=1724376433\",\"category\":\"Motiv Strains Certificate of Analysis\"}]\n "}],"jsonSchema":{"name":"match_product_to_lab_report","strict":true,"schema":{"type":"object","properties":{"matchings":{"type":"array","items":{"type":"object","properties":{"product_name":{"type":"string","description":"The name of the product"},"lab_report":{"type":"object","properties":{"lab_report_name":{"type":"string","description":"The lab report name"},"lab_report_matching_name":{"type":"string","description":"The matching name of the lap report"},"lab_report_url":{"type":"string","description":"The url of the lab report"},"lab_report_id":{"type":"number","description":"the id of the lab report from the original given array"}},"required":["lab_report_name","lab_report_matching_name","lab_report_url","lab_report_id"],"additionalProperties":false}},"required":["product_name","lab_report"],"additionalProperties":false}}},"required":["matchings"],"additionalProperties":false}}}