AI Integration API with OpenAI

SKö
SKö Customer
in Platform

Hi community,

To enable and empower my data with AI in board, I am looking for a step by step guide on how to set up an API with OpenAI to analyse my data with the big language model ChatGPT and get the text response in board (text cube). I know it's possible, but I haven't found a guide on the forum on how to set it up.
Perhaps someone else in the community has built this use case and could explain to me how to set it up.
Thank you very much!

Answers

  • Samson Sunny
    Samson Sunny Employee, Community Captain
    25 Answers 100 Comments Third Anniversary 25 Likes

    Hi @SKö ,

    I haven't tried this myself but you could do the following:-

    Use Board Public API queries to export the data, provided Open AI is able to consume the endpoint and the authentication must comply with OAuth 2.0 client credentials.

    https://platform.openai.com/docs/api-reference/authentication

    Then after your analysis create a data source connection to OpenAI using the OpenAI API key and import the data into Board using the REST API call and then use the ascii data reader to read it into the text cube.

  • OerderM
    OerderM Customer
    First Comment

    Hi,

    the keyword is RAG (Retrieval Augmented Generation). To do this, you must first convert the board data into an LLM-readable format. In other words, you need a vector database. Then you can transfer the data to the LLM and play the answer back to Board. Langchain and langflow will help you.

    Best regards,

    Marco

  • Fabrizio Straccia
    Fabrizio Straccia Employee
    Fourth Anniversary Name Dropper Level 100: Foundations of Building in Board First Comment

    Hi @SKö,

    Thank you for sharing your interest in leveraging AI to enhance your data analysis with OpenAI !

    We’re excited to inform you about our Board AI initiative (learn more here), which is designed to embed generative AI capabilities into the Board environment. Our Spotlight environment provides a space to explore and test AI - Assisted Analysis, enabling seamless interaction between your data and AI-powered models like ChatGPT.

    To access and start testing this functionality, we encourage you to reach out to your Customer Success Manager (CSM), who can guide you through the process and provide access to the Spotlight environment.

    We’re committed to empowering our users with cutting-edge tools, and we’re thrilled to see your enthusiasm for incorporating AI into your workflows. Don’t hesitate to reach out if you have further questions or need additional support.

    Best regards,

    Fabrizio

Categories