Mapping Fields Between Netsuite and Zuora for Sales Order Flow

[vishnuagarwal349 (Vishnu Agarwal)]

Hi everyone,

I’m working on integrating Netsuite and Zuora for a sales order flow and need some guidance on field mapping. The expected output is a complex, nested JSON payload that includes multiple data points such as:

Customer Details: Name, email, billing/shipping addresses, etc.
Order Items: Product details, quantity, pricing, discounts, etc.
Billing and Subscription Data: Payment terms, subscription dates, and related metadata.

Challenges:
Mapping fields between Netsuite and Zuora, especially with nested structures.
Ensuring the JSON payload complies with Zuora's API specifications.

Request:
I’d appreciate any of the following:

1) Best practices for mapping fields between Netsuite and Zuora.
2) Sample mappings or JSON payloads from similar integrations.
3) Any scripts to automate or simplify the process.

Additional Details:
If helpful, I can share a sample JSON structure that outlines the expected payload format.

Looking forward to your insights and recommendations. Thanks in advance for your help!

[Yonton_Mehler]

Hi @vishnuagarwal349 ,

If you can, please provide a sample JSON of the payload you plan to import into Zoura.

Typically, when posting a complex JSON object it's best to use the Mapper2.0 to build the structure. It can be a tedious when you're new to Mapper2.0, but gets significantly easier with practice.
If you provide the JSON of what you need, I'll send you some screenshots of how to build it and that should set you on the right path.

Thanks,

Yonton Mehler
Sr. Dev
Celigo

[vishnuagarwal349 (Vishnu Agarwal)]

Hi Yonton,

I have completed the mapping using Mapper 2.0, and below is the shared screenshots for reference. However, the generated JSON does not match the expected structure as per the payload shared earlier.

Mapping Done for Generated JSON screenshots:

Generated JSON screenshot:

Additionally, here is the API documentation link that outlines the expected payload format: Create an order

Could you review the mapping and let me know if any adjustments are needed? I would appreciate any guidance on aligning it correctly.

Thanks,
Vishnu Agarwal