Integration with Oracle Data Transform

[DAdmin9]

We need something else which is the SQL statement to retrieve all the required fields from both the tickets table and calls table.

We have some fields that are required in the project in both tables tickets and calls.

We need the SQL statement that calls these fields to fetch them using Oracle Data Transform.

this is a link for our request:

https://drive.google.com/file/d/1r8zAbAc0_w8ouODcldL2F10DhkEyablr/view?usp=sharing

Regards,

[Jaycee_Lewis]

Hi, @DAdmin9 👋 Thanks for the interesting question. 

It sounds like you're looking for a SQL query to retrieve specific fields from the tickets and calls tables in your Oracle Database for use with HubSpot portal. Is that correct?

While HubSpot itself cannot provide a custom SQL statement for your database, providing more details about your requirements could enable members of the community with relevant experience to offer guidance.

Questions to help the community:

• Please specify the exact fields you need from these tables
• How you plan to use this data within HubSpot?
• Are you aiming to update existing records, create new ones, or use the data for analysis and reporting?

Hopefully, some of our community members might be able to share insights or examples of SQL queries they've used previously.

Best,

Jaycee

[DAdmin9]

We do not need an API call. We want the SQL queries to fetch these data and the data from the Calls table, because like you have seen in the video above, we do not know where the columns or data come from.

Therefore, we need the SQL queries used for tickets and calls.

[DAdmin9]

The project will move the data from HubSpot to the Autonomous database for advanced cloud supervision on Oracle Cloud Infrastructure. We will use the data same as your system, we just need a fully real time integration system to supervise these data alongside other data from different BUs. As for the required fields, we need these fields from Tickets:

Branch
Branch_office
cause_of_complaint
close_date
create_date
pipeline
product
product_type
service_category
ticket_belongs_to
Ticket_id
Ticket_reason
Source
Ticket_source
Ticket_Status
Ticket_Type
Time_To_Clsoe_HH_MM_SS