Data Warehousing and Data integration

Using ChatGPT fro email processing

More
2 years 7 months ago #23029 by Simon
Hi.

I have created a prompt that is used to assign a category to customer feedback: positive negative etc.
I know how to process emails using AET and I am wondering if it can work with ChatGPT.

 Thank you,
  Simon

Please Log in or Create an account to join the conversation.

More
2 years 7 months ago #23030 by Peter.Jonson
Hi Simon.

Thank you for your question
We would need to make some modifications to the HTTP Post action to make it work for you.
Once they are ready I will create a working example for you and let you know.

Peter Jonson
ETL Developer

Please Log in or Create an account to join the conversation.

More
2 years 7 months ago - 2 years 7 months ago #23047 by admin
Hi Simon

Just letting you know that we have made all the necessary changes to  HTTP Post action and it should be possible now to work with ChatGpt.

Please use the following link to access ChatGpt api

api.openai.com/v1/completions

JSON example

{
  "model": "text-davinci-003",
  "prompt":"What is the capital of great britain",
  "temperature":0.7,
  "max_tokens":150
}

The result is stored in <HTTP Post Result> variable




 

Mike
ETL Architect
Last edit: 2 years 7 months ago by admin.

Please Log in or Create an account to join the conversation.

More
2 years 4 months ago #23151 by prashant
I modified your prompt like below and got an output 
Code:
{   "model": "gpt-3.5-turbo",   "messages": [     {       "role": "system",       "content": "User: What is the capital of Great Britain?"     }   ],   "temperature": 0.7,   "max_tokens": 150 }


Although I keep getting error below. It does write the output to the file but the error is consistent.


 

Please Log in or Create an account to join the conversation.

More
2 years 4 months ago #23155 by admin
The issue you reported was addressed in the latest release

Mike
ETL Architect

Please Log in or Create an account to join the conversation.

Cookies user preferences
We use cookies to ensure you to get the best experience on our website. If you decline the use of cookies, this website may not function as expected.
Accept all
Decline all
Read more
Marketing
Set of techniques which have for object the commercial strategy and in particular the market study.
Google
Accept
Decline
Analytics
Tools used to analyze the data to measure the effectiveness of a website and to understand how it works.
Google Analytics
Accept
Decline
Google Analytics
Accept
Decline
Functional
Tools used to give you more features when navigating on the website, this can include social sharing.
Advertisement
If you accept, the ads on the page will be adapted to your preferences.
Google Ad
Accept
Decline
Save