Python Zeep SOAP API:OraclePrimavera P6:将变量作为参数传递到调用字符串Li的API函数中

2024-10-03 23:17:40 发布

您现在位置:Python中文网/ 问答频道 /正文

columns = ["ActivityObjectId", "ActivityTimesheetLinkFlag", "ApprovedHours", "ApprovedOvertimeHours", "CreateUser", "CreateDate", "Date", "IsBaseline", 
          "IsTemplate", "LastUpdateDate", "LastUpdateUser", "ObjectId", "OverheadCodeName", "OverheadCodeObjectId", "ProjectId",
          "ProjectName", "ProjectObjectId", "ResourceAssignmentObjectId", "ResourceId", "ResourceIntegratedType", "ResourceName", "ResourceObjectId", "Status", "TimesheetPeriodObjectId", "TimesheetStatusDate", "UnapprovedHours", "UnapprovedOvertimeHours", "WBSObjectId"]

response2 = client.service.ReadResourceHours(columns, "ObjectId = '27490316'")

因此,在本例中,客户端使用“ReadResourceHours”函数调用读取资源小时数。它需要几个参数,1)要从数据库中读取的特定列名,2)过滤条件,在本例中是具有指定值的ObjectId

我创建了一个名为“columns”的字符串列名列表,并传递了对象“columns”。这很好,程序可以读取

但是,在传递字符串文字的筛选条件中,如何将该值存储到变量中,然后将该变量传递到筛选条件中,而不是实际键入"ObjectId = '######'"

原始代码:

response2 = client.service.ReadResourceHours(columns, "ObjectId = '27490316'")

所需示例:

Filter_Condition_One = 27490316
response2 = client.service.ReadResourceHours(columns, "ObjectId" = Filter_Condition_One)

Tags: columns字符串clientservicefiltercondition条件one