Showing results for 
Search instead for 
Did you mean: 
PaulineB Frequent Visitor
Frequent Visitor

New column//field in pipedrive //Jason



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:

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.





Community Support Team
Community Support Team

Re: New column//field in pipedrive //Jason

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!


Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.