在Navision 2009中通过Sql查询计算WebService更新的密钥 [英] Calculate Key for WebService Update from Sql Query in Navision 2009

问题描述

我将Navision 2009中的某些Pages作为Web服务公开。要更新记录，您必须发出读取请求，并将密钥字段与更新请求一起发送。

I am exposing some Pages in Navision 2009 as web services. To update a record, you have to issue a Read request, and send the Key field along with your Update request.

我宁愿自己计算密钥，原因有两个：

I would rather calculate the Key myself for 2 reasons:

1. 在读取请求中使用过滤器很尴尬-一个SQL查询适合一行。


2. 性能太糟糕了。

我已经知道，至少部分密钥是Base64编码的字符串，构成主键的列。我希望有人可以告诉我在哪里看（数据库，代码库，文档等）来告诉我密钥的计算方式。

I've been able to figure out that at least part of the key is a Base64 encoded string of the columns that make up the primary key. I hope that someone can tell me where to look (database, code base, docs, etc) to tell me how the Key is calculated.

推荐答案

对不起，我不知道如何计算密钥。除了考虑计算密钥外，您是否考虑过在代码单元中进行数据处理，并将该代码单元公开为Web服务？

Sorry, I don't know how to calculate the key. Instead of calculating the key, have you considered doing your data manipulation in a codeunit instead, and exposing that codeunit as a webservice?

这篇关于在Navision 2009中通过Sql查询计算WebService更新的密钥的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！