How to Map this

Integrator.io
,
1

Hi,

I have a JSON response (see below) coming back and cannot seem to get the value back for 2 fields:

I need to know how I can pull out the Billing Type and state. What I tried was:

Project[*].entities[*].state.id

"Project": [
{
"entities": [
{
"id": "/Project/77x229fm8s13kyzjphcvkg2lo121",
"sysid": "P-72901",
"C_ServicesRevenue": null,
"C_CPONumber": "",
"C_OCId_Project": null,
"name": "Testing for Cases, Risks, Issues, etc",
"description": null,
"BillingType": {
"id": "/ProjectBillingType/Fixed Price"
},
"state": {
"id": "/State/Active"
}
},

thanks

2

Moved this to our main integrator.io community topic

3

I dont understand the context, but Project[0].entities[0].state.id will work if all you need is the first entries in the arrays. If you are trying to iterate through all the entries, then you will need to map the entire response to a new field in your source record, and then you can use handlebars to iterate, or a hook to iterate, in subsequent steps in your flow. If the full response is too big to map back into your source record, then you can also use a transformation or hook to shrink it first.

I imagine my response here is going to be confusing, but again, it is hard to help without more context on what you are doing.