Check and accept Disclaimer before use

API Usage Instructions

Welcome to Share My List.

Most the world best AI models of "Table Question Answering" can take only <100 records.

This the only New model that can take: 100... up to 20 000 !!! records

Remarkable speed in generating human-readable queries.

The system can handle such complex Queries to table as:

> java with rating above 4.7 and review num > 5k

Example

Queries can contain:

Uses

Testing "Table Question Answering" at any size for:

Below are examples of uploading CSV files into the model and Answering your questions.

JSON format also supported, please provide them as an array of records. Example:

        
    [
        {
            "name": "John", "age": 25, "city": "New York"
        },
        {
            "name": "Jane", "age": 30, "city": "Los Angeles"
        }
        ...
    ]
        
    

UPLOAD your CSV or JSON

file_name - is used as a key to your data collection.

Example of Function to upload the CSV file_path:

        
    def upload_file(file_path):
        try:
            api_url = "https://www.share-my-list.com/upload_647ngiuon550e840e29b41d4637644665544asdf00.html"
            # Open the file in binary mode
            with open(file_path, 'r') as file:
                # Use requests.post to send a POST request with the file
                response = requests.post(api_url, files={'file': file})

                # Check if the request was successful
                if response.status_code == 200:
                    print("File uploaded successfully!")
                else:
                    print("Failed to upload file. Status code:", str(response.status_code))
                return response
        except requests.RequestException as e:
            print("Error: uploading file." + e)
        return None
        
    

How to use in your test:

        
        # Pay attention your_file_name.csv is used for querying the data, not a full path
        file_name = "your_file_name.csv"
        path_to_file = "./path/to/your/file/" + file_name
        upload_response = upload_file(path_to_file)
        print("Response code: " + upload_response.status_code)
        
    

Start Question Answer your TABLE

Example of Function to Question Answer your table uploaded above:

        
    def query_uploaded_table(file_name, query):
        try:
            url = "https://www.share-my-list.com/all_query_company_ds35647ngiuon550e840e29b41d46376446655440000.html"
            post_data = {"query_param": query, "db_name": file_name}
            response = requests.post(url, data=post_data)
            # Check if the request was successful (status code 200)
            if response.status_code == 200:
                print("Data read successfully!")
                return response.json()
            else:
                print("Error: reading data.")
        except requests.RequestException as e:
            print("Error: reading data." + e)
        return None
        
    

Example of usage:

        
        file_name = "your_file_name.csv"
        query = "all rings with price < 10"
        query_response = query_uploaded_table(file_name, query)
        print(query_response)
        
    

Last updated: 05/01/2024