Unanswered

Update lookup table values through Rest api in Project Online

(0) Share

Report

Posted on by rajatk09

I am trying to Project Online Lookup Table value using Send a HTTP request to Sharepoint using Flow.
I am trying to create new entry in lookup table using Rest but getting an error.

ERROR : An unexpected 'PrimitiveValue' node was found when reading from the JSON reader. A 'StartObject' node was expected.
clientRequestId: af31b745-2214-4635-9a45-0fa1311e7d2c
serviceRequestId: aea3c29f-30ba-b000-fc46-67eccb973d3b

Using Post message :

URI:

_api/ProjectServer/LookupTables('00008e67-65a3-4898-baaa-d82d995bbb02')/Entries/Add

Body

{'parameters':{

'Value':'110',
'Description':'Added from Flow',
'SortIndex':'7',
'ParentId':'dd67bf95-85a3-eb11-bfa0-00155dc0a600'
}}
Using following References https://docs.microsoft.com/en-us/previous-versions/office/project-javascript-api/jj668218(v=office.15)

https://docs.microsoft.com/en-us/previous-versions/office/project-javascript-api/jj668483(v=office.15)
@Anonymous

Categories:

Using flows

I have the same question (0)

All responses (2)

Answers (0)

Muthu_Haris 2 on at

Like (0)

Report
Copy link

Link copied!

Hi Raja, I am also facing the same issue. Did you able to fix the issue

Was this reply helpful? Yes No
dradomtsev 5 on at

Like (0)

Report
Copy link

Link copied!

Hi @rajatk09 ,
as said in article Project-docs-pr/LookupEntryCreationInformation.md at master · OfficeDev/Project-docs-pr (github.com) parameter 'Value' is of type LookupEntryValue so the value of parameter 'Value' should be
{'Decimal':'110'}
The full body of the request would be like
{'parameters':{
'Value':{'Decimal':'110'},
'Description':'Added from Flow',
'SortIndex':'7',
'ParentId':'dd67bf95-85a3-eb11-bfa0-00155dc0a600'
}}

Was this reply helpful? Yes No