Expand my Community achievements bar.

Update schema for batch upload

Avatar

Level 2

Hi everyone, 

We don't have anyone using API at our company and doing things in AEP UI. 

 

We have existing schema, dataset, and scheduled batch files. (Field A,B,C)

 

Now we want to onboard a different file based on a same primary key. (Field D,E,F)

 

What we did was 1. Update existing schema by adding field D,E,F. 2) Created dataset based on that schema 3) upload sample data into the dataset. 

 

When we try step 3, I am keep getting 'A required field [_bellca] of type object is missing from the input data. Please add the required field and try again' Why is this? I am attaching screenshot of our network schema. 

The individual fields are the subset of each object. (_bellca being the highest hierarchy) Is there a step I am forgetting from the UI?

jooyeon_han_0-1731600287813.png

 

 

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

2 Replies

Avatar

Community Advisor

@jooyeon_han 

Does your input data file have the correct format? I.e. are your fields in this format?

 

_bellca.bellCustomerAttributes

_bellca.bellCustomerEligilityList

_bellca.bellCustomerIdentities

_bellca.bellUDFField

Avatar

Level 2

Hi @DavidRoss91 

Thank you for your reply. 

 

The existing batch fileA captures the fields that are associated to the first three hierarchy. (Each individual hierarchy has subset of fields and those are all captured).

_bellca.bellCustomerAttributes

_bellca.bellCustomerEligilityList

_bellca.bellCustomerIdentities

 

Now for the new batch fileB I would like to setup, the all fields that are associated to the last hierarchy (_bellca.bellUDFField) are included, including the primary key.

 

I thought when adding a new data source (new batch file), I should update the existing schema by adding the new fields that are coming in, and setup a separate dataset so when the new batch file is uploaded, it will do the mapping based on the primary key. 

I am very new to updating this and I am lost

jooyeon_han_0-1731609209278.png