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

New column//field in pipedrive //Jason

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

 

 

1 REPLY 1
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!

Dale

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.