Am Building Scenarios with Email to OpenAI to extract information and do the next step,

How To
1

I have email reading from microsoft 365 and conencted with OpenAI. the problem is how to set OpenAI to generate output as JSON in certain scenario. and gereate text output in certain scenario

1 Like
2

Hi @Kiran_Kumar

To get json output from open ai GO to advance settings and select the following options:

image
image697Ă—717 83 KB

Best regards,

Msquare Automation
Platinum Partner of Make
@Msquare_Automation

3

image
image447Ă—607 35.7 KB

Not getting the Response output as you shown

1 Like
4

and also there is no Advance settings option

Thanks in Advance

1 Like
5

Hi @Kiran_Kumar

You are using wrong module “Transform text to structured data”. Instead you need to use “Create a Completion” module.

image
image488Ă—441 24.2 KB

Best regards,

Msquare Automation
Platinum Partner of Make
@Msquare_Automation

6

Thanks,
Request to just validate my scenario
First i wanted to read email from my Microsoft 365, then get the email content to OpenAI , if the email consists of Vehicle and Scacid (which is our internal id) for vehicles, openAI has to provide me in Json format [{“vehicle”:“AP09CC2318”,“SCIC”:“AXCD”},{“vehicle”:“AP09CC2318”,“SCIC”:“AXCD”}] like this. some time email consists of table format of list of vehicles with SCIC some time they write in text if one two vehicles.
Kindly Suggest

1 Like
7

Hi @Kiran_Kumar

To get vehicles and Scid, two methods can be used. One using OpenAI and other using “regex”. It depends how the this data comes into email body and which methods is more convenient.

Could you please share an example email to assist you better?
Best regards,

Msquare Automation
Platinum Partner of Make
@Msquare_Automation

8

following were the forms we get in email

  1. In Table format Carrier and Vehicle Number

    image
    image213Ă—130 6.07 KB

  2. Some times Carrier is mentioned one time in the text of email and vehicle list will be provided as table
    This second method is due to carrier is same for all vehicles if the email is from the same transporter.

output i wanted to hit API with JSON