Hey there, i need some help accessing links array from Fusion cloud apps REST services. links array is not shown anywhere in data profile…
I created REST service with wizard, left everything as is, discovery found all operations (GET, POST, PATCH) and i can test operation (get rows from the cloud) and see the data. All good.
Now i need a href object from links array, and it is not in the data profile.
I only used Simple HTTP requests by now, and arrays were just added as cols to the data profile, but with SaaS apps it is not the same (or maybe APEX upgrades changed this behavior, idk). Anyhow, i thought i can just add some columns to the profile, so i saw i get links array and some other data in JSON under @context object
So adding Array type to data profile, with @context.links should produce my links array, i added @context.links.name as another column
But now i get error when i try to sync data to local table (that gets updated by APEX because profile changed). And i get it, this should be another table to sync multiple links per JSON object (row), i don't understand how to set it up…
Then i saw request URL, and i think this fails because it requests @context…
And then there is this option i could never set it up properly:
If i add another GET operation to fetch multiple rows (because i think there will be multiple links in the array) i get another error:
I don't really know how to do this, there isn't a lot of tutorials online, and documentation lacks more info about the whole @context field (or i didn't find it). So after asking a quick question on X, mr. Jayson pointed me to this forum to get some help from anyone who managed to get the stuff working - that is, syncing JSON arrays into local table with other data from fusion cloud apps… Of course, i pretty much also want to know the background workings of APEX REST services, ie. the :APEX$resourceKey definition (i mean, how does it know its PK from just a rest call etc…) Thanks for any help!
Best regards, Matic!