About abhishek_c

abhishek_c

I am trying to retrieve metadata of the Folders, By using this API https://711-tfe-064.mktorest.com/rest/asset/v1/folders.json I can able to fetch only main folders not the sub Folders data. Is there any solution to retrieve the metadata of all Folders.

abhishek_c

Hi All, In Marketo how can we get the List of Schema Objects which are main Objects to fetch data from Marketo. Like for eg : Leads, Companies, Opportunities, Opportunities Role, Folders etc. This are few of the Static Objects which we call API to fetch results. So, Is there any API to fetch List of Static Schema Objects or Endpoint Objects to get the data. My Goal is to fetch complete data from Marketo.

abhishek_c

@SanfordWhiteman, I meant under which connection type Marketo comes under. like TABLEAU, POWERBI comes under Chart type and HDFS, S3 comes under File type and SQL,MYSQL, ORACLE comes under DBMS type.

abhishek_c

@SanfordWhiteman, Yes, I referred to the document but I couldn't find any endpoint API for getting the datatype and column name for the one which I mentioned like Email, Folder, Form , Tag, Channel. So, how can we get the details of it's datatype and column name and other details which we have for existing like for Lead API /rest/v1/leads/describe.json.

abhishek_c

@SanfordWhiteman, sorry, I meant " it's not the perfect example". So, we can't get the relation between the tables by any of the API's?

abhishek_c

@SanfordWhiteman, wanted to know under which connection type Marketo comes?

abhishek_c

Hi All, I want information for Marketo comes under which category is it RDBMS, Charts, Report etc...

abhishek_c

Hi All, I want to get column description for all the other API like Email, Folder, Lead Activity, Form , Tag, Channel, Smart Champaign, Smart List. So, Is there any way we can get them as we don't have any API for that?

abhishek_c

Hi All, I wanted to get some info on is there any ways we can get the Relation between the tables like for Ex: For Lead table Id is the Primary Key and in Lead Activity we can find leadId ( it's not the perfect example) . So, I want to get all the relationship but the other tables too. So, is there any way of getting it.

abhishek_c

@Katja_Keesom, I meant like can we have direct access to Marketo Database Access. So, that we can directly query it and fetch the data from Marketo Database instead of the using API's to retrieve the Data. My use-case is to export complete data from Marketo.

abhishek_c

Hi All, Is there any possibility to do direct connection to Marketo Database as I can see most of the companies are doing that. So, is there any way we can directly query and fetch the data from Marketo Database instead of the using API's to retrieve the Data (like for Eg: if Marketo uses Sql Server then Accessing Marketo SQL by IP Address and Credentials to retrieve Data which is store in Marketo). My use-case is to export complete data from Marketo and store it in local Database. If there are different plans for that then we're fine with that too. Can anyone suggest..

abhishek_c

@Jo_Pitts1, I really appreciate the help which is provided by Sanford. I was always being nice and I even said many times like in reply no one was answering and after many hours with no response I created a new thread and thought of deleting the reply in existing thread but there was no option. I already told in that thread please refer to the main thread in that reply too. I don't understand how the lack of forum etiquette came in this. If you can check all my threads it has thanks for helping in replies at last you can verify it. So, is it not the acknowledgement or appreciate from my side given to that person?? To be frank if anything is wasting my time then I just ignore and go on rather creating more hate rate by posting unnecessary paragraphs of text just for creating a new thread. posting paragraphs of text would waste more time if I'm not wrong. I think you need to be nice to all and say it in good etiquette way and it would be great if you're polite. FYI, I replied to Sanford right, I don't understand what is bothering you to come in the others conversation and post I think that should come under lack of forum etiquette. need to try this. Chill, Be Nice to all.

abhishek_c

It would be more user friendly if you provide a delete option for the replies. So, that if no one is answering the query asked in reply i.e., because of basic human nature that he would read heading and the first query and check the first reply and leave that thread. So, In that case a user would can create a new thread with detailed info and delete the query asked in the replies this would solve all the issues for both client who's asking queries and the one who's helping.

abhishek_c

@SanfordWhiteman, It's because No one is answering if I kept it in reply. So, I created a separate thread for that. Why would I ask duplicating questions if anyone had replied in same thread and even there is no option to delete that reply.

abhishek_c

@Jo_Pitts1 , I'm asking it because I need to understand Marketo. As I need to Crawl/PRofile complete Marketo Data and store it in local Database. So, need to understand all dependencies and sync flow to be followed during API's calls like to get All Leads then Activities. I need to store this in MySql using Java. Can you please help me with the link for built code.

abhishek_c

Hi All, Can Anyone help me with Marketo Dependencies and API's sync order to be maintained while calling all API's. As I want to crawl/profile complete data from Marketo and Store in local Database like MySQL. So, wanted to know about Sync order to be maintained like : First All Leads should be fetched from Leads API then Company Changes should be fetched from Company API. And Dependencies like Getting Activities with LeadIds by using API : /rest/v1/activities.json?leadIds={leadIds}

abhishek_c

I want to understand how we are storing Data in Marketo Database is it in Table column like MySql or other?

abhishek_c

Can anyone pls reply for query in : DataBase Architecture Query Link for storing of Data in Marketo Database asked in reply. For reference below is the query.

abhishek_c

I want to understand how we are storing Data in Marketo Database is it in Table column like MySql or other?

abhishek_c

Hi All, I want to get more details about Marketo Database Architecture as it would be more helpful for me to understand and which is the best Database to store for Marketo Data after extracting from API's as we need to perform some operation after extracting the data from Marketo.

abhishek_c

Hi @SanfordWhiteman , Thanks for your response okay I got it. Can you give me more details about Marketo Database Architecture as it would be more helpful for me to understand and which is the best Database to store for Marketo Data after extracting from API's.

abhishek_c

Hi All, I want to extract complete Database of Marketo to store that data in our MySql Database for some processing. Is there any way we can extract complete Marketo Database?

abhishek_c

Hi @Katja_Keesom , Thanks for the advice. Can you please suggest me where can I get support from an expert.

abhishek_c

Hi @Katja_Keesom, Thanks for your response and you have cleared my most of the doubts but still more details I wanted to get started with Marketo. Yes, I have tried the link which you have send and wanted to know more about the Architecture.

abhishek_c

Hi All, I have just gone through the API's and completely new to this Product and I want to understand the complete Database Architecture of Marketo Application as we want to integrate this Product in our application through REST API. So, need depth knowledge on the flow of Data (How Primary or Foreign Key can be referred). How the data flows and what's the best way of understanding Marketo Application. We also need to know which API is been mapped to which Flow and how we can know the dependencies and Lineage of it. What's the best Practice to integrate Marketo through REST API. I already did basic steps like adding users generating Token and accessing data through API and sending Scheduled email through Engagement Program.

Online Status	Offline
Date Last Visited	yesterday

Date Registered	a month ago
Date Last Visited	yesterday
Total Messages Posted	26

Top Badges Earned

Marketo Asset API - Folders

Marketo Endpoint API to fetch list of static objec...

Re: Marketo comes under which DataBase Type

Re: Marketo Table Column Descriptions for others

Re: Marketo Table Relation

Re: Marketo comes under which DataBase Type

Marketo comes under which DataBase Type

Marketo Table Column Descriptions for others

Marketo Table Relation

Re: Marketo Database Access

Marketo Database Access

Re: Marketo DataBase Architecture

Re: Marketo DataBase Architecture

Re: Marketo DataBase Architecture

Re: Marketo DataBase Architecture

MARKETO Dependencies and API's Synchronization Ord...

What Database is used for Marketo Storage

Re: How can we extract entire Marketo Database?

Re: Marketo DataBase Architecture

Marketo DataBase Architecture

Re: How can we extract entire Marketo Database?

How can we extract entire Marketo Database?

Re: Marketo Integration Database Management Flow

Re: Marketo Integration Database Management Flow

Marketo Integration Database Management Flow