New column//field in pipedrive //Jason

[PaulineB]

Hey,

I currently try to see the new field in the query editor which where inserted throughout a Jason.

Attached you can see an extraxt from the advanced editor:

let
Source = Json.Document(Web.Contents("xx")),
#"Converted to Table" = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Ignore),
#"Expanded Columns" = Table.ExpandRecordColumn(#"Converted to Table", "}),
#"Renamed Columns" = Table.RenameColumns(#"Expanded Columns",Table.ToRows(pipedriveFieldTranslator)),
#"Renamed Columns1" = Table.RenameColumns(#"Renamed Columns",{{"person_name", "contactPersonName"}}),
#"Changed Type" = Table.TransformColumnTypes(#"}}),
#"Replaced Value" = Table.ReplaceValue(#"Changed Type","104","Partner",Replacer.ReplaceText,{"jobCategory"}),

In this format it approximately looks like.

The error message I am getting is :

Expression.Error: We expected new Column Names to have the same number of items as field Names.

I

[v-jiascu-msft]

Hi @PaulineB,

Did you insert any step in the middle of the queries? Can you share a sample please? There are some syntax errors. But it won't relate to the error in this post. 

Best Regards!

Dale