Forum Discussion
PHILLIP DENNIS
Principal | Watkyn LLC
Quickbase Partner
(954) 900-6690 | hello@watkyn.com
www.watkyn.com
------------------------------
Phillip Dennis
------------------------------
- LaszloM2 years agoQrew TraineeThank You Phillip!
That opened the door and now I'm down the rabbit hole into JSON parsing and JINJA filters....
I asked for it, I know...
Thank you so much, just that little piece was what I needed!
------------------------------
Laszlo M
------------------------------- Hongkunliang8 months agoQrew Cadet
Hi Laszlo, I have the same situation. Do you mind to share your code how to get the user id? Much appreciated!
Best regards,
Hongkun
------------------------------
Hongkun liang
------------------------------
- MalcolmMcDonald2 years agoQrew CadetThis is a gift -- thank you Phillip!
------------------------------
Malcolm McDonald
------------------------------ - DamonWalls2 years agoQrew MemberWhat would channel/step would come after the Quickbase Make Request channel step that would accept the {{a.json.qdbapi.value}} response?
------------------------------
Damon Walls
------------------------------- MalcolmMcDonald2 years agoQrew CadetFor my use, I did another make request as the second request depended on the the result of the first.
https://xxx.quickbase.com/db/xxx?a=API_SendInvitation&userid={{b.json.qdbapi.userid}}&usertext="Welcome."
I can definitely see use cases where you would want to create a record to store the request and result, or update a record with new information etc.
------------------------------
Malcolm McDonald
------------------------------- DamonWalls2 years agoQrew MemberThank. I'm looking to make a second as well depending on the result of the first. I'm making a GetUserRole call and need to check the response to see if the user is in specific roles already, if not make another request call to AddUserToRole.
Anyone have any insight on how the expression should look to check the response via {{b.json.qdbapi.value}}? Definitely a Jinja newbie.
------------------------------
Damon Walls
------------------------------
- PrashantMaheshw8 months agoQrew Captain
Huge shout out to Phillip for discovering and posting this. It was a major lifesaver for me to find the RecordID of the item I just created using QuickBase MAKE REQUEST step in pipeline
------------------------------
Prashant Maheshwari
------------------------------- Hongkunliang8 months agoQrew Cadet
Hi Prashant, I have the similar case as yours. I am using the Make Request to call API "CopyMasterDetail", I'd like to get the parentRid. Should I directly use the b.json.qdbapi.parentrid or parsing the b.content? Thanks in advance!
------------------------------
Hongkun liang
------------------------------- PrashantMaheshw8 months agoQrew Captain
you can capture the response at https://jsonpathfinder.com/ and find the exact path of the item.
In my case the value was found at {{b.json["metadata"]["createdRecordIds"][0]}}
b represents the step and id was was what QuickBase created.
------------------------------
Prashant Maheshwari
------------------------------