Discovery Pattern pulls JSON having 15 records, but only creates 5

NagyDan1
Tera Expert

7 hours ago

Please help with Discovery Pattern logic.

 

We are pulling data from Nutanix (via API link), and I get a JSON, I do see that when I click the "Run Operation" button on the Pattern step, the JSON is coming nicely with 15 records, I can see that clearly. Here comes the issue:

 

But then I have a Transform Table" operation step, which only processes 5 records out of the 15. 😲

 

Why? 😥

 

JSON contains 15 records, but then Transform Table only processes 5. What is wrong? 😥

0 Helpfuls
  • 171 Views
2 REPLIES 2

Tanushree Maiti
Tera Patron

7 hours ago

Hi @NagyDan1 

 

A Transform Table step can fail or halt if it expects a specific column or variable mapping.

Validate your transform map and check if it is throwing any error (check transform history/log). If yes, share the error screen shot.

 

Refer:

https://www.servicenow.com/community/ham-forum/transform-map-not-working-as-some-data-in-staging-tab...

 

Please Accept the solution if it assisted you with your question & Mark this response as Helpful.
Regards
Tanushree Maiti
ServiceNow Technical Architect
LinkedIn: https://www.linkedin.com/in/tanushreemaiti
0 Helpfuls

pr8172510
Tera Guru

7 hours ago

Hi @NagyDan1,

If the Run Operation step returns all 15 records but the Transform Table step processes only 5, the issue is typically in the Transform Table configuration rather than the API response.

 check

  • The JSONPath points to the complete JSON array.

  • Any filter or condition configured on the Transform Table.

  • Whether records are being matched/updated instead of created.

  • Required field mappings for all 15 records.

  • Pattern Debug output to identify skipped or failed records.

 the Pattern Debug output is the best place to determine why records are not being processed by the Transform Table step.

 

0 Helpfuls