How to Map this

Jackie Beaupre

• February 16, 2022 12:58

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 

0

• 

  Courtney Jordan Experience Strategy & Design Director Community moderator

  • February 16, 2022 16:55

  

  

  

  Moved this to our main integrator.io community topic

  0
• 

  Scott Henderson CTO

  • February 16, 2022 18:38

  

  

  

  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.

  0

Please sign in to leave a comment.