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:

Words and phrases - semantic AI LLM Search

> want to see adventure movies about space

Numbers - prices, count, ratings filtering

> all bananas with price < $2

Geo Locations - cities, countries, addresses

> give me all Chinese restaurants near Boston

Dates - filter by date before and after

> show me all AI event after Apr-2023

Uses

Testing "Table Question Answering" at any size for:

your company's data
your services or products price list
events calendars Semantic Search
your best places, restaurants, courses - share with your friends

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 file_name.csv (or json) to the API.
Start Querying the file_name.csv.

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