Forum Discussion

PaulineB's avatar
PaulineB
Frequent Visitor
8 years ago

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

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Icon for Microsoft Employee rankMicrosoft Employee

    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