(msmrw_guidesteps) How do I format the the response so that the returned JSON step data is in sequential order

(0) Share

Report

Posted on by SeansNewTinyCompany

I working on displaying the data of each guide step within a Unity application

When I make a GET request to the endpoint (msmrw_guidesteps)

e.g. https:/#########.api.crm4.dynamics.com/api/data/v9.2/msmrw_guidesteps'

The response that I get is an array of objects, but the steps are not in sequential order

Is there any way to identify the correct order?

Each object within the array does have a "msmrw_guidestepid" property,

All responses (4)

Answers (1)

shiho on at

Like (0)

Report

RE: (msmrw_guidesteps) How do I format the the response so that the returned JSON step data is in sequential order

When a guide step has a next step button instead of responses, that knowledge is stored inside the Guide Step table in row "Response 1 Action Type" (msmrw_response1actiontype) with value 'Go to Next Step'.

The actual reference to the next step is not stored there as only the relationship of the previous step is stored. To get a ordered list you will need to traverse the guide from the last step and store that list in order yourself.
SeansNewTinyCompany 15 on at

Like (0)

Report

RE: (msmrw_guidesteps) How do I format the the response so that the returned JSON step data is in sequential order

Thanks shiho

The 'msmrw_previousstep' property worked fine as expected,

But when I tried the msmrw_response1step I kept on getting null value for each single step value within the guide, I greatly appreciate your help but are you 100% sure that it's "msmrw_response1step" for the next associated step?
Verified answer

shiho on at

Like (0)

Report

RE: (msmrw_guidesteps) How do I format the the response so that the returned JSON step data is in sequential order

Previous and next step information is stored inside rows in the Guide Step table (msmrw_guidestep) in the Dataverse.

Specifically, looking in the row called Previous Step (msmrw_previousstep). Knowledge that the step has a next step button is stored in row called Response 1 Action Type (msmrw_response1actiontype). This does not actually store the next step reference, but rather can only tell you whether the step has a next step associated with it.
Ryan is correct in that you will need to traverse each step and store it in an ordered list.
RyanN on at

Like (0)

Report

RE: (msmrw_guidesteps) How do I format the the response so that the returned JSON step data is in sequential order

Steps are stored as a linked list so you'll need to parse/traverse it accordingly.