Hey Vishnu, Thanks for the series. Quick comment: The Omnistudio interface is slightly different 1 yr later. Firstly, Object names are Singular, not Plural. EG: Contact, vs Contacts. Additionally, I had to play with the Extract Step definition to pull a proper JSON. More specifically, I had to name the Contact EXTRACT Output Path as "Account:Contact" for it to return contact records in the Preview tab.
Just wanted to say thanks, I have absolutely no idea and this is on my learning list. A colleague was stuck as he wanted to get three levels of hierarchy in json output. I googled to find a solution for him and came across this video. Thanks for your effort and keep it up.
You used “Vlocity.NULL” and query ran successfully without using $. But for me it’s showing error if I don’t use $. Please explain. Also is Vlocity case sensitive?
Hi, Thanks for the playlist. Actually I am facing an issue at 2:21 when we add the extract step and then execute it. It is showing i.e., "NO VALID SOQL QUERY DATA". Can you please help me out with this.
And why in my Preview result, the data order (from top to bottom) is Account name, Contact name, Account website? I did order them as Contact name, Account name, Account website in the Output tab. Does Omnistudio sort them randamly?
You really helped me a lot while interview preparation. I have few doubts on EPC and order Management also . Is there any chance you can create videos on those areas also.
when you have a result like this: {a:b} it easy used on the flexcard because show as a table and you can take from de field section, but it have this structure !! {node1:{node2:{a:b}}} or {node: {a:b}} or sobjete type, how can you get the data ??
@@0to1Code Thanks for the reply is ur video series on Vlocity is enough for taking up the interview, or any other topics should I have more insights on.
How do we do this from a person account? Or a household account that needs to grab all of its roles which are person accounts which are account contact relationships? (include record types on accounts)
Sorry i posted this in previous video (turbo extract) by mistake. It is actually this video ! I have a doubt so, In this video you extracted parent to child i.e from accounts you extracted contacts associated .So can we extract it in the reverse that is from child to parent like from opportunity , i want to retrieve accounts associated with it ?
The way i am doing on 6:11 for filter Account.Name. You can do in extract path. The field might not be coming in dropdown but you should able to do like contacts:Account.Name in extract path. Give it a try.
Heyy I try to fetch account record N my extract output same as yours but when I put "Velocity.NULL " the output didn't show if I put "$Vlocity.NULL " then my output is show ? Can you tell me why
This is my first time using Vlocity for my new Project and you're helping way more than the Trailhead. I love your clear tutorials!
Glad to hear that! Best of luck on your learning journey.
Hey Vishnu, Thanks for the series. Quick comment: The Omnistudio interface is slightly different 1 yr later. Firstly, Object names are Singular, not Plural. EG: Contact, vs Contacts. Additionally, I had to play with the Extract Step definition to pull a proper JSON. More specifically, I had to name the Contact EXTRACT Output Path as "Account:Contact" for it to return contact records in the Preview tab.
Just wanted to say thanks, I have absolutely no idea and this is on my learning list. A colleague was stuck as he wanted to get three levels of hierarchy in json output. I googled to find a solution for him and came across this video. Thanks for your effort and keep it up.
Glad Rajiv, I am able to help through my knowledge.
You used “Vlocity.NULL” and query ran successfully without using $. But for me it’s showing error if I don’t use $. Please explain. Also is Vlocity case sensitive?
This material is excellent. Life-saver. I think I'll actually be able to utilize Omnistudio now.
13.32 I see in the options "Use Translations" but I can't see in my DR Extract. How I can enable it so I can see that checkbox ?
thank you very much.
with simple examples you made it easy to understand what and how to use omnistudios
Glad it was helpful!
Hi,
Thanks for the playlist.
Actually I am facing an issue at 2:21 when we add the extract step and then execute it. It is showing i.e., "NO VALID SOQL QUERY DATA".
Can you please help me out with this.
Did you find out why?
@@sravyalingala4766 please try as Id "$Vlocity.NULL"
*Note the $ mark
And why in my Preview result, the data order (from top to bottom) is Account name, Contact name, Account website? I did order them as Contact name, Account name, Account website in the Output tab. Does Omnistudio sort them randamly?
Well Explained about all the items in the Extract DR, Liked the transform feature and hierarchy convertor.
Glad it helped.
You really helped me a lot while interview preparation. I have few doubts on EPC and order Management also . Is there any chance you can create videos on those areas also.
Thank You for the explanations.
when you have a result like this: {a:b} it easy used on the flexcard because show as a table and you can take from de field section, but it have this structure !! {node1:{node2:{a:b}}} or {node: {a:b}} or sobjete type, how can you get the data ??
I have sign up an account but when I login I am not getting omnistudio
Very good tutorial! Thanks. 🙏
How to use subqueries in dataraptor extract?
Sir can you provide the ppt which you have used in videos its very helpful for me.
I don't have those PPTs anymore. I used to overwrite them. Noob move :)
Hi I am new to Vlocity and learning from here and trailheads, so what is the use of this JSON data we are extracting in real project view.
This JSON data will be used in OmniScript and Flexcard to power the data on UI.
@@0to1Code Thanks for the reply is ur video series on Vlocity is enough for taking up the interview, or any other topics should I have more insights on.
@@De4Th_ST4R Not sure mate, What questions will they ask. But should be good to learn and answer.
Superb please keep make more vedio on vlocity
you can place on the output, the field Account.Name ??
How do we do this from a person account? Or a household account that needs to grab all of its roles which are person accounts which are account contact relationships? (include record types on accounts)
Did you ever find out? Person Accounts do have hidden contact records... or they used to...
I did not. Yes they do have contacts attached.
@@xtrafreeway4me I'm thinking all the fields you'd want are within the account record. So you'd use a DataRaptor TurboX
How to use lookup field in extract..
Sorry i posted this in previous video (turbo extract) by mistake.
It is actually this video !
I have a doubt so,
In this video you extracted parent to child i.e from accounts you extracted contacts associated .So can we extract it in the reverse that is from child to parent like from opportunity , i want to retrieve accounts associated with it ?
The way i am doing on 6:11 for filter Account.Name. You can do in extract path. The field might not be coming in dropdown but you should able to do like contacts:Account.Name in extract path. Give it a try.
@@0to1Code No its not working.
This is the best tutorial ever, but can you please get rid of the awful music please?
Can't now!
Heyy I try to fetch account record N my extract output same as yours but when I put "Velocity.NULL " the output didn't show if I put "$Vlocity.NULL " then my output is show ? Can you tell me why
Velocity.NULL is incorrect. this is a global variable. Its Vlocity without e.
@@0to1Code Okay thanks and your video is help me a lot for learning the vlocity more than trailhead