**Background:**
I have been working on this the past day and will appreciate any insight. I am creating a Logic App that automates the transfer of data from CosmosDB to CRM. My dilemma is that in creating my logic app, the fields are a 'lookup' field. I am unsure of where to find the GUIDs for these lookup fields.
This is what I have done so far:
**Dilemma:**
I am trying to find the record ID or GUID for the 'Feature Category' lookup field. How exactly do I do this? I researched where someone mentions to search within CosmosDB,how would I do this?
There are other articles that state you have to List Records' within the Logic App? However, I am not fully understanding this.
Any insight is greatly appreciated.
Solved! Go to Solution.
Hi @jasmine2020
CRM lookup id (GUID) will be different. Believe you have a Feature Category entity in CRM. What you need to do is filter the Feature category (text value) from Cosmos DB. See below.
This will return the GUID of the related record in CRM. Once you found the GUID map this value in your CRM action step.
Thanks
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogHi @jasmine2020
That means the text is not stored under the field called 'name'. Open any feature category record in CRM. Click form customization and check the field schema name. Use that schema name. If not try ems_name. That might work. It's a pure guess.
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogHi @jasmine2020
CRM lookup id (GUID) will be different. Believe you have a Feature Category entity in CRM. What you need to do is filter the Feature category (text value) from Cosmos DB. See below.
This will return the GUID of the related record in CRM. Once you found the GUID map this value in your CRM action step.
Thanks
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogThank you @abm
Ok I think I understand, so is the text located within my JSON parse? For example:
Since I am wanting the Feature Category lookup, I would need to do this?
I just want to make sure this is correct
And then I would need to examine the output of this to find the record GUID?
Is there a way to query for all of the text names? How would I find each text name within this entity (I only know about the ASME Azure because I ran this particular logic app)
Thank you!
Hi @jasmine2020
Yes that's correct. Map the Parse JSON related property (Feature Category) to your filter query. Then examine the output and get the GUID. Not sure what you meant by all text names?
Thanks
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blog@abm Thank you.
Because the GUID that will be produced is just the GUID for that particular text right? "ASME: Azure Stack", but I have a large dataset. How would I get all of the text names? Maybe I am just seeing one text name.
Hi @jasmine2020
Are you asking how would you get all the text names from your Cosmos DB?
Thanks
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogAlso, @abm ,
I just ran this and got an error that says:
Is there another keyword that I should use?
Hi @jasmine2020
That means the text is not stored under the field called 'name'. Open any feature category record in CRM. Click form customization and check the field schema name. Use that schema name. If not try ems_name. That might work. It's a pure guess.
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogHi @jasmine2020
Not that form. What you need to do is place the cursor inside the Feature category lookup. Browse and click new. Your other option is click the Advanced Find option and select Feature Category and download the FetchXML. Open the file and find the name.
Thanks
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blog@abm ok thank you. I am working in a sandbox environment. Will this affect if I can search the title or not?
I do not see 'new' or advanced search when I look within the feature cat field..
Hello @abm
I ran a query against my text fields and I have over 3000. To find the GUID for the feature category, would I have to repeat this process 3000 times? or once I find the GUID for ANY text, I am good?
Thank you
Hi @jasmine2020
Believe they are unique. If not unique you need to make a decision which one you need to use.
Thanks
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogUser | Count |
---|---|
88 | |
37 | |
25 | |
13 | |
13 |
User | Count |
---|---|
121 | |
55 | |
36 | |
24 | |
21 |